FORM PAGE: <HTML> <HEAD> <TITLE>The FSU Office of Telecommunications || Departmental Order Form</TITLE> <SCRIPT language="javascript" src="../validator.js"></SCRIPT> <SCRIPT type="text/javascript"> if (navigator.cookieEnabled == 0) { alert("You need to enable cookies for this form to remember your information."); } --> </SCRIPT> <SCRIPT LANGUAGE="JavaScript"> <!-- This script and many more are available free online at --> <!-- The JavaScript Source!! http://javascript.internet.com --> <!-- Original: Nick Baker --> <!-- Begin // Cookie Functions //////////////////// (:) // Set the cookie. // SetCookie('your_cookie_name', 'your_cookie_value', exp); // Get the cookie. // var someVariable = GetCookie('your_cookie_name'); var expDays = 100; var exp = new Date(); exp.setTime(exp.getTime() + (expDays*24*60*60*1000)); function getCookieVal (offset) { var endstr = document.cookie.indexOf (";", offset); if (endstr == -1) { endstr = document.cookie.length; } return unescape(document.cookie.substring(offset, endstr)); } function GetCookie (name) { var arg = name + "="; var alen = arg.length; var clen = document.cookie.length; var i = 0; while (i < clen) { var j = i + alen; if (document.cookie.substring(i, j) == arg) return getCookieVal (j); i = document.cookie.indexOf(" ", i) + 1; if (i == 0) break; } return null; } function SetCookie (name, value) { var argv = SetCookie.arguments; var argc = SetCookie.arguments.length; var expires = (argc > 2) ? argv[2] : null; var path = (argc > 3) ? argv[3] : null; var domain = (argc > 4) ? argv[4] : null; var secure = (argc > 5) ? argv[5] : false; document.cookie = name + "=" + escape (value) + ((expires == null) ? "" : ("; expires=" + expires.toGMTString())) + ((path == null) ? "" : ("; path=" + path)) + ((domain == null) ? "" : ("; domain=" + domain)) + ((secure == true) ? "; secure" : ""); } // cookieForms saves form content of a page. // use the following code to call it: // <body onLoad="cookieForms('open', 'form_1', 'form_2', 'form_n')" onUnLoad="cookieForms('save', 'form_1', 'form_2', 'form_n')"> // It works on text fields and dropdowns in IE 5+ // It only works on text fields in Netscape 4.5 function cookieForms() { var mode = cookieForms.arguments[0]; for(f=1; f<cookieForms.arguments.length; f++) { formName = cookieForms.arguments[f]; if(mode == 'open') { cookieValue = GetCookie('saved_'+formName); if(cookieValue != null) { var cookieArray = cookieValue.split('#cf#'); if(cookieArray.length == document[formName].elements.length) { for(i=0; i<document[formName].elements.length; i++) { if(cookieArray[i].substring(0,6) == 'select') { document[formName].elements[i].options.selectedIndex = cookieArray[i].substring(7, cookieArray[i].length-1); } else if((cookieArray[i] == 'cbtrue') || (cookieArray[i] == 'rbtrue')) { document[formName].elements[i].checked = true; } else if((cookieArray[i] == 'cbfalse') || (cookieArray[i] == 'rbfalse')) { document[formName].elements[i].checked = false; } else { document[formName].elements[i].value = (cookieArray[i]) ? cookieArray[i] : ''; } } } } } if(mode == 'save') { cookieValue = ''; for(i=0; i<document[formName].elements.length; i++) { fieldType = document[formName].elements[i].type; if(fieldType == 'password') { passValue = ''; } else if(fieldType == 'checkbox') { passValue = 'cb'+document[formName].elements[i].checked; } else if(fieldType == 'radio') { passValue = 'rb'+document[formName].elements[i].checked; } else { passValue = document[formName].elements[i].value; } cookieValue = cookieValue + passValue + '#cf#'; } cookieValue = cookieValue.substring(0, cookieValue.length-4); // Remove last delimiter SetCookie('saved_'+formName, cookieValue, exp); } } } // End --> </SCRIPT> <SCRIPT LANGUAGE="JavaScript"> var isNN = (navigator.appName.indexOf("Netscape")!=-1); function autoTab(input,len, e) { var keyCode = (isNN) ? e.which : e.keyCode; var filter = (isNN) ? [0,8,9] : [0,8,9,16,17,18,37,38,39,40,46]; if(input.value.length >= len && !containsElement(filter,keyCode)) { input.value = input.value.slice(0, len); input.form[(getIndex(input)+1) % input.form.length].focus(); } function containsElement(arr, ele) { var found = false, index = 0; while(!found && index < arr.length) if(arr[index] == ele) found = true; else index++; return found; } function getIndex(input) { var index = -1, i = 0, found = false; while (i < input.form.length && index == -1) if (input.form[i] == input)index = i; else i++; return index; } return true; } </SCRIPT> <SCRIPT language=JavaScript> function popUp(URL) { day = new Date(); id = day.getTime(); eval("page" + id + " = window.open(URL, '" + id + "', 'toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=0,resizable=0,wid th=480,height=400,left = 100,top = 60');"); } </SCRIPT> <LINK href="hg.css" rel="stylesheet" type="text/css"> <LINK href="tsr.css" rel="stylesheet" type="text/css"> </HEAD> <BODY bgColor=#ffffff text=#000000 link=#330000 vLink=#000000 aLink=#990000 onLoad="cookieForms('open', 'form')" onUnload="cookieForms('save', 'form')"> <CENTER> <FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B><IMG src="images/tsrbanner2.jpg" width="625" height="65"></B> </FONT> <TABLE width="625" border="0" cellpadding="5" cellspacing="0" bgcolor="#990000"> <TR align="center" bgcolor="#FFFFCC"> <TD valign="top" nowrap bordercolor="#990000" bgcolor="#FFFFCC"><P><FONT size="-7" face="Verdana, Arial, Helvetica, sans-serif"><EM>If you DO NOT have an FSU OMNI NUMBER & need to receive an invoice, click <A href="http://www2.otc.fsu.edu/Forms/TSR/OA_Order_Form.php">HERE</A> </EM></FONT></P></TD> </TR> </TABLE> <TABLE width="625" border="0" cellpadding="1" cellspacing="0" bordercolor="#CC0000"> <TR valign="middle"> <TD width="50%" align="center" valign="top" nowrap><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <!-- BEGIN ProvideSupport.com CODE --> <SCRIPT language="JavaScript" src="http://image.providesupport.com/js/otc.js"></SCRIPT> <A href="http://www.providesupport.com" target="_blank"><IMG src="http://image.providesupport.com/image/otc.gif" alt="Live Chat" border="0"></A> <!-- END ProvideSupport.com CODE --> </FONT></TD> <TD width="50%" align="center" valign="middle" nowrap><TABLE width="200" border="0" cellpadding="3" cellspacing="0"> <TR> <TD nowrap><FONT size="-7" face="Verdana, Arial, Helvetica, sans-serif"><B>To request repairs</B>,<BR> please use our<BR> Online Repair Form</FONT></TD> <TD align="right"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><A href="http://www2.otc.fsu.edu/Forms/Repair/Repair_Form.php"><IMG src="images/btn-repair-sm.gif" alt="Go to Repair Form" width="65" height="30" border="0"></A></FONT></TD> </TR> </TABLE></TD> </TR> </TABLE> </CENTER> <FORM ACTION="orderconfirm.php" METHOD="POST" enctype="multipart/form-data" name="form" onSubmit="return v.exec()"> <DIV align="center" id="error_form" style="display: block;"></DIV> <CENTER> <TABLE width="625" border="0" cellpadding="0" cellspacing="6"> <TR> <TD align="right" valign="top"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B><IMG src="images/note-btn.gif" alt="Note icon" width="15" height="15"></B></FONT></TD> <TD align="left" valign="top"><P><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif">If you rely on the AUTOFILL/SAVED INFO ("cookies") feature on this form, please note that you will need to reselect from the dropdown fields each time.</FONT><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B><FONT color="#CC0000">HINT: </FONT></B><FONT color="#CC0000">By typing the first few letters of a drop-down list, the selection will "jump" to that area of the list! </FONT> </FONT></P></TD> <TD width="14%" align="center" valign="middle"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif">Click<BR> <INPUT type=reset value="CLR" tabindex="47" name="reset2"> <BR> to clear all</FONT></TD> <TD width="17%" align="right" valign="middle"><TABLE border="1" bordercolor="#999999" cellspacing="0" cellpadding="3"> <TR> <TD align="center" valign="middle"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><I><IMG src="images/stargreens.gif" alt="Required" align="absmiddle"> = <B><FONT color="#990000">Required!</FONT></B></I></FONT></TD> </TR> </TABLE></TD> </TR> </TABLE> <TABLE width="625" border="0" cellpadding="2" cellspacing="0" bgcolor="#CCCCCC"> <TR> <TD width="50%" align="center" scope="col"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif" class="style15"><B>Contact Information</B></FONT><FONT color="#660000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><B><BR> </B><I>To be filled out by the person in the department who will coordinate completion of the order </I></FONT></TD> </TR> </TABLE> <TABLE width="625" border="0" cellspacing="0" cellpadding="3"> <TR valign="top"> <TD width="237" id="t_Contact_Name" scope="row"><P><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>Contact Name: <IMG src="images/stargreens.gif" alt="Required Field!"><I><A href="http://www.otc.fsu.edu/TSR_Help.html#1"><IMG src="images/tipblue.gif" alt="Access Help Files" border="0"></A></I></B><B> <BR> <INPUT maxlength=30 size=35 name="Contact_Name" tabindex="1"> <BR> </B></FONT></P> </TD> <TD width="151" align="center" id="t_Contact_Phone"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>Contact Phone: <IMG src="images/stargreens.gif" alt="Required Field!"><I><A href="http://www.otc.fsu.edu/TSR_Help.html#3" target=_blank><IMG src="images/tipblue.gif" alt="Access Help Files" border="0"></A></I><BR> <INPUT maxlength=10 size=16 name="Contact_Phone" tabindex="2"> </B></FONT></TD> <TD width="219" id="t_Contact_Email"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>Contact E-mail: <IMG src="images/stargreens.gif" alt="Required Field!"><I><A href="http://www.otc.fsu.edu/TSR_Help.html#2"><IMG src="images/tipblue.gif" alt="Access Help Files" border="0"></A></I> <BR> <INPUT name="Contact_Email" tabindex="3" size=35 maxlength="50"> </B></FONT></TD> </TR> <TR valign="top"> <TD scope="row" id="t_Contact_Room"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>Contact Rm: <INPUT maxlength=20 size=10 name="Contact_Room" tabindex="4"> <I><IMG src="images/stargreens.gif" alt="Required Field!"></I></B></FONT></TD> <TD> </TD> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>NOTE: </B><I>Enter multiple email addresses by separating them with a semi-colon (; )</I></FONT></TD> </TR> </TABLE> <TABLE width="625" border="0" cellpadding="0" cellspacing="1"> <TR> <TD colspan="3" bgcolor="#EFEFEF"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>Contact Bldg/Location:</B></FONT><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B><IMG src="images/stargreens.gif" alt="Required Field!" /> <IMG src="images/note-btn.gif" alt="note icon" width="15" height="15" /></B></FONT></TD> </TR> </TABLE> <TABLE width="625" border="0" cellpadding="0" cellspacing="1"> <TR> <TD width="19"><P> </P></TD> <TD width="603" colspan="2"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>Choose from List<FONT color="#990000"> (If NOT LISTED, BE SURE to type in below!) </FONT>: <BR> <SELECT name="Contact_Bldg" tabindex="5"> <OPTION selected>NOT LISTED - Type in Below</OPTION> <?php require_once('../FX/FX.php'); // configure a connection to FileMaker Server Advanced $ordersQuery = new FX('www2.otc.fsu.edu', '80', 'FMPro7'); // set database and layout information $ordersQuery->SetDBData('WEB_Forms', 'Ref_FSU_Buildings', 'all'); // set database username and password $ordersQuery->SetDBUserPass('***', '***'); // retrieve all records in this database available to the current user $ordersQuery->AddSortParam('ListForWeb', 'ascend'); $orders = $ordersQuery->DoFXAction(FX_ACTION_FINDALL); foreach ($orders as $contact) { echo " <option>{$contact['ListForWeb']}\n"; } ?> </SELECT> </B></FONT></TD> </TR> <TR> <TD><IMG src="/images/spacer.gif" alt="clear spacer" width="15" height="1" /></TD> <TD colspan="2"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B> <FONT color="#990000">OR</FONT> Type in here: <LABEL> </LABEL> <INPUT name="Contact_Bldg_Unlisted" id="Contact_Bldg_Unlisted" tabindex="6" size="60" maxlength="60" /> </B></FONT></TD> </TR> </TABLE> <TABLE width="625" border="0" cellpadding="2" cellspacing="0" bordercolor="#660000"> <TR borderColor=#660000 bgColor=#dece9c> <TD align=center bgcolor="#CCCCCC"><SPAN class="style15"><FONT face="Verdana, Arial, Helvetica, sans-serif"><B>Department Billing Contact Information</B></FONT></SPAN><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B><FONT color="#660000"><BR> </FONT></B><FONT color="#660000"><I>The Department Budget Representative from the Authorized Budget Signature List in OMNI</I></FONT></FONT></TD> </TR> </TABLE> <TABLE width="625" border="0" cellpadding="0" cellspacing="1"> <TR> <TD colspan="3" bgcolor="#EFEFEF"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>Department Name:</B></FONT><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B><IMG src="images/stargreens.gif" alt="Required Field!" /> <IMG src="images/note-btn.gif" alt="note icon" width="15" height="15" /></B></FONT></TD> </TR> </TABLE> <TABLE width="625" border="0" cellpadding="0" cellspacing="1"> <TR> <TD width="19"><P> </P></TD> <TD width="603" colspan="2"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>Choose from List<FONT color="#990000"> (If NOT LISTED, BE SURE to type in below!) </FONT>: <BR> </B> <SELECT size="1" name="Department_Name" tabindex="7"> <OPTION selected>NOT LISTED - Type in Below</OPTION> <?php require_once('../FX/FX.php'); // configure a connection to FileMaker Server Advanced $ordersQuery = new FX('www2.otc.fsu.edu', '80', 'FMPro7'); // set database and layout information $ordersQuery->SetDBData('WEB_Forms', 'SG_Sections', 'all'); // set database username and password $ordersQuery->SetDBUserPass('***', '***'); // retrieve all records in this database available to the current user $ordersQuery->AddSortParam('SectionName', 'ascend'); $orders = $ordersQuery->DoFXAction(FX_ACTION_FINDALL); foreach ($orders as $contact) { echo " <option>{$contact['SectionName']}\n"; } ?> </SELECT> </FONT></TD> </TR> <TR> <TD><IMG src="/images/spacer.gif" alt="clear spacer" width="15" height="1" /></TD> <TD colspan="2"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B> <FONT color="#990000">OR</FONT> Type in here: <LABEL> </LABEL> <INPUT name="Department_Unlisted" id="Department_Unlisted" tabindex="8" size="60" maxlength="60" /> </B></FONT></TD> </TR> </TABLE> <TABLE width="625" border="0" cellspacing="0" cellpadding="2"> <TR> <TH align="left" scope="col" id="t_Budget_Auth_Signature"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>Budget Authorized Signature/Manager Name:<BR> <IMG src="images/stargreens.gif" alt="Required Field!"> <I><A href="http://www.otc.fsu.edu/TSR_Help.html#1"><IMG src="images/tipblue.gif" alt="Access Help Files" border="0"></A></I> <INPUT maxlength=30 size=35 name="Budget_Auth_Signature" tabindex="9"> </B></FONT></TH> <TH scope="col" id="t_Budget_Phone"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>Budget Manager Phone #:<BR> <IMG src="images/stargreens.gif" alt="Required Field!"></B> <INPUT maxlength=10 size=14 name="Budget_Phone" tabindex="10"> </FONT></TH> </TR> <TR> <TD align="left" scope="row" id="t_Budget_Email_Address"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>Budget Mgr E-Mail Address:<I><A href="http://www.otc.fsu.edu/TSR_Help.html#9" target=_blank><IMG src="images/tipblue.gif" alt="Access Help Files" border="0"></A></I></B><BR> <B> <IMG src="images/stargreens.gif" alt="Required Field!"> <INPUT maxlength=50 size=35 name="Budget_Email_Address" tabindex="11"> </B></FONT></TH> <TD> </TD> </TR> </TABLE> <TABLE width="625" border=0 cellpadding="6" borderColor=#660000 bgcolor="#660000"> <TBODY> <TR borderColor=#660000 bgColor=#dece9c> <TD width="625" align=center bgcolor="#CCCCCC"><SPAN class="style15"><FONT face="Verdana, Arial, Helvetica, sans-serif"><B>Budget (OMNI) Information</B></FONT></SPAN> </TD> </TR> </TBODY> </TABLE> <TABLE width="625" border="0" cellpadding="2" cellspacing="0"> <TR> <TH colspan="2" align="left" valign="middle" bgcolor="#FFDDDD" scope="row"><FONT color="#660000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>NOTES REGARDING SUBMITTED BUDGET NUMBERS:</B></FONT></TH> </TR> <TR> <TD width="5%" align="right" valign="top" scope="row"><B><FONT color="#660000" size="3" face="Georgia, Times New Roman, Times, serif">* </FONT></B></TD> <TD width="95%" align="left" valign="middle" scope="row"><P><I><FONT color="#660000" size="1" face="Verdana, Arial, Helvetica, sans-serif"> The "Official" Budget Manager, as pulled from FSU's OMNI System, will be informed via email of this order. </FONT></I></P></TD> </TR> <TR> <TD align="right" valign="top" scope="col"><B><FONT color="#660000" size="3" face="Georgia, Times New Roman, Times, serif"> * </FONT></B></TD> <TD align="left" scope="col"><P><FONT color="#660000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><I>One-Time (non-recurring) charges will appear on the charge detail of the phone line for the above mentioned Budget Manager.</I></FONT></P></TD> </TR> </TABLE> <TABLE width="625" border="1" cellpadding="2" cellspacing="0" bordercolor="#660000"> <TR align="center" valign="middle" bordercolor="#000000" bgcolor="#dece9c"> <TD><FONT color="#660000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>ALL CHARG</B></FONT><FONT color="#660000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>ES <IMG src="images/stargreens.gif" alt="Required Field!"></B><BR> (Monthly & 1-Time) </FONT></TD> <TD><FONT color="#660000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>OPTIONAL<BR> 1-Time Charges</B></FONT></TD> </TR> <TR valign="top"> <TH scope="row"><TABLE border="0" cellpadding="1"> <TR align="center" vAlign=top> <TD align="center" nowrap><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <INPUT name="Budget_Rec_DeptID" id="Budget_Rec_DeptID" tabindex="12" size=9 maxlength=6 onKeyUp="return autoTab(this, 6, event);"> </FONT></TD> <TD nowrap><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <INPUT name="Budget_Rec_FundCode" id="Budget_Rec_FundCode" tabindex="13" size=5 maxlength=3 onKeyUp="return autoTab(this, 3, event);" /> <B><SUP>1</SUP></B></FONT></TD> <TD nowrap><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <INPUT name="Budget_Rec_Project" id="Budget_Rec_Project" tabindex="14" value="000000000" size=12 maxlength=9> </FONT></TD> </TR> <TR align="center" vAlign=middle> <TD align="center" valign="top" nowrap id="t_Budget_Rec_DeptID"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B> Dept ID </B></FONT></TD> <TD align="center" valign="top" nowrap id="t_Budget_Rec_FundCode"><P><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>Fund Code</B> </FONT></P></TD> <TD valign="top" nowrap id="t_Budget_Rec_Project"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>Project* </B></FONT></TD> </TR> <TR align="center" vAlign=middle> <TD align="center" valign="top" nowrap id="t_Budget_Rec_DeptID"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif">(6 digits)</FONT></TD> <TD align="center" valign="top" nowrap id="t_Budget_Rec_FundCode"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> (3 digits)</FONT></TD> <TD valign="top" nowrap id="t_Budget_Rec_Project"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif">*If N/A, leave 9 ZEROs;<BR> all others enter 6-digits<BR> (<I>NO construction here)</I></FONT></TD> </TR> <TR align="center" vAlign=middle> <TD height="16" colspan="3" valign="top"><TABLE width="100%" border="0" cellpadding="4" cellspacing="0" bordercolor="#660000" bgcolor="#FFFFCC"> <TR bgcolor="#FFFFF2"> <TD align="right" valign="top"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><u><EM>Optional</EM></u><B><I><A href="http://www.otc.fsu.edu/TSR_Help.html#cf"><BR> </A></I></B> Chartfields<BR> <B><I><A href="http://www.otc.fsu.edu/TSR_Help.html#cf"><IMG src="images/tipblue.gif" alt="Access Help Files" border="0"></A></I></B><BR> </FONT></TD> <TD align="left" valign="top" nowrap><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B> 1. <SELECT name="ChartField_1" tabindex="15"> <OPTION selected>N/A</OPTION> <?php require_once('../FX/FX.php'); // configure a connection to FileMaker Server Advanced $ordersQuery = new FX('www2.otc.fsu.edu', '80', 'FMPro7'); // set database and layout information $ordersQuery->SetDBData('WEB_Forms', 'Ref_ChartFields1', 'all'); // set database username and password $ordersQuery->SetDBUserPass('***', '***'); // retrieve all records in this database available to the current user $ordersQuery->AddSortParam('ChartField_Info', 'ascend'); $orders = $ordersQuery->DoFXAction(FX_ACTION_FINDALL); foreach ($orders as $contact) { echo " <option>{$contact['ChartField_Info']}\n"; } ?> </SELECT> <BR> 2. <SELECT name="ChartField_2" tabindex="16"> <OPTION selected>N/A</OPTION> <?php require_once('../FX/FX.php'); // configure a connection to FileMaker Server Advanced $ordersQuery = new FX('www2.otc.fsu.edu', '80', 'FMPro7'); // set database and layout information $ordersQuery->SetDBData('WEB_Forms', 'Ref_ChartFields2', 'all'); // set database username and password $ordersQuery->SetDBUserPass('***', '***'); // retrieve all records in this database available to the current user $ordersQuery->AddSortParam('ChartField_Info', 'ascend'); $orders = $ordersQuery->DoFXAction(FX_ACTION_FINDALL); foreach ($orders as $contact) { echo " <option>{$contact['ChartField_Info']}\n"; } ?> </SELECT> <BR> 3. <SELECT name="ChartField_3" tabindex="17"> <OPTION selected>N/A</OPTION> <?php require_once('../FX/FX.php'); // configure a connection to FileMaker Server Advanced $ordersQuery = new FX('www2.otc.fsu.edu', '80', 'FMPro7'); // set database and layout information $ordersQuery->SetDBData('WEB_Forms', 'Ref_ChartFields3', 'all'); // set database username and password $ordersQuery->SetDBUserPass('***', '***'); // retrieve all records in this database available to the current user $ordersQuery->AddSortParam('ChartField_Info', 'ascend'); $orders = $ordersQuery->DoFXAction(FX_ACTION_FINDALL); foreach ($orders as $contact) { echo " <option>{$contact['ChartField_Info']}\n"; } ?> </SELECT> </B></FONT></TD> </TR> <TR bgcolor="#FFFFF2"> <TD colspan="2" align="left" valign="top"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><I>Chartfields can ONLY be applied to monthly (recurring), NOT 1-time (non-recurring) or construction charges.</I></FONT></TD> </TR> </TABLE> <TABLE border="0" cellspacing="0" cellpadding="5"> <TR valign="top"> <TD width="3"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B><SUP>1</SUP></B></FONT></TD> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif">If Fund Code begins with "5" (Sponsored Research), a 6-digit Project <u>must</u> be entered (type over zeros). </FONT></TD> </TR> </TABLE></TD> </TR> </TABLE></TH> <TD><P align="center"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif">Complete this side<B> ONLY</B> i<FONT color="#000000">f </FONT></FONT><FONT color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif">Budget (OMNI) information differs from left side <B>OR</B> if order is for <B>construction</B>*</FONT></P> <TABLE width="94%" border="1" align="center" cellpadding="3" cellspacing="0" bordercolor="#990000"> <TR> <TD align="center" bgcolor="#FFFFCC"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>*CONSTRUCTION PROJECTS: <BR> </B>If order is construction, complete LEFT side with <BR> NON-CONSTRUCTION budget number AND <BR> ALSO enter construction budget below.</FONT></TD> </TR> </TABLE> <FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><BR> </FONT> <TABLE width="100%" border="0" cellpadding="1"> <TR align="center" valign="top"> <TD align="center"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <INPUT name="Budget_NR_DeptID" id="Budget_NR_DeptID" tabindex="18" size=9 maxlength=6 onKeyUp="return autoTab(this, 6, event);"> </FONT></TD> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <INPUT name="Budget_NR_FundCode" id="Budget_NR_FundCode" tabindex="19" size=5 maxlength=3 onKeyUp="return autoTab(this, 3, event);"> </FONT></TD> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <INPUT name="Budget_NR_Project" id="Budget_NR_Project" tabindex="20" size=12 maxlength=9> </FONT></TD> </TR> <TR align="center" vAlign=middle> <TD align="center" valign="top" nowrap><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif">Dept ID<BR> (6 digits)</FONT></TD> <TD valign="top" nowrap><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif">Fund Code<BR> (3 digits)</FONT></TD> <TD valign="top"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif">Project (if applicable)<BR> *If N/A, enter 9 ZEROs;<BR> 9 digits for Construction;<BR> all others enter 6-digits</FONT></TD> </TR> </TABLE></TD> </TR> </TABLE> <TABLE width="625" border=0 cellpadding="2" cellspacing="0" borderColor=#660000 bgcolor="#660000"> <TBODY> <TR borderColor=#660000 bgColor=#dece9c> <TD width="625" align=center bgcolor="#CCCCCC"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>Service Information <BR> </B><I>This section pertains to services you requested</I> </FONT></TD> </TR> </TBODY> </TABLE> <TABLE width="625" border="0" cellpadding="0" cellspacing="1"> <TR> <TD colspan="3" bgcolor="#EFEFEF"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>Service Building Address: <IMG src="images/stargreens.gif" alt="Required Field!" /> <I><A href="http://www.otc.fsu.edu/TSR_Help.html#12" target="_blank"><IMG src="images/tipblue.gif" alt="Access Help Files" border="0" /></A></I></B><B> </B></FONT></TD> </TR> </TABLE> <TABLE width="625" border="0" cellpadding="0" cellspacing="1"> <TR> <TD width="19"><P> </P></TD> <TD width="603" colspan="2"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>Choose from List<FONT color="#990000"> (If NOT LISTED, BE SURE to type in below!) </FONT>: <BR> </B><B><IMG src="images/note-btn.gif" alt="note icon" width="15" height="15" /> <SELECT name="Service_Location_Bldg" tabindex="21"> <OPTION selected>NOT LISTED - Type in Below</OPTION> <?php require_once('../FX/FX.php'); // configure a connection to FileMaker Server Advanced $ordersQuery = new FX('www2.otc.fsu.edu', '80', 'FMPro7'); // set database and layout information $ordersQuery->SetDBData('WEB_Forms', 'Ref_FSU_Buildings', 'all'); // set database username and password $ordersQuery->SetDBUserPass('***', '***'); // retrieve all records in this database available to the current user $ordersQuery->AddSortParam('ListForWeb', 'ascend'); $orders = $ordersQuery->DoFXAction(FX_ACTION_FINDALL); foreach ($orders as $contact) { echo "<option>{$contact['ListForWeb']}\n"; } ?> </SELECT> </B></FONT></TD> </TR> <TR> <TD><IMG src="/images/spacer.gif" alt="clear spacer" width="15" height="1" /></TD> <TD colspan="2"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B> <FONT color="#990000">OR</FONT> Type in here: <LABEL> </LABEL> <INPUT name="Service_Bldg_Unlisted" id="Service_Bldg_Unlisted" tabindex="22" size="60" maxlength="60" /> </B></FONT></TD> </TR> </TABLE> <TABLE width="625" border="0" cellspacing="0" cellpadding="2"> <TR> <TD align="left" valign="top" nowrap id="t_Service_Location_Rm"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B><IMG src="images/stargreens.gif" alt="Required Field!">Service Rm Number: <INPUT name="Service_Location_Rm" tabindex="23" size="12" maxlength=10> </B></FONT></TD> </TR> </TABLE> <TABLE width="625" border=0 borderColor=#660000> <TBODY> <TR borderColor=#660000> <TD align=center><TABLE border="0" cellpadding="4" cellspacing="0" bordercolor="#660000"> <TR bgcolor="#DECE9C"> <TD colspan="2" align="center" valign="top"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>Please check all services that apply</B><BR> Be sure to include the details in the "Details of Work" box below! </FONT></TD> </TR> <TR> <TD width="50%" align="center" valign="top"><CENTER> <TABLE width="100%" border="0" cellspacing="2" cellpadding="3"> <TR valign="middle" bgcolor="#990000"> <TD colspan="2" bgcolor="#CCCCCC"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>VOICE SERVICES</B></FONT></TD> </TR> <TR valign="top" bgcolor="#FFFFFF"> <TD width="8%"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <B> <INPUT name="BasicSvc_Features" type="checkbox" id="BasicSvc_Features" tabindex="24" value="Basic Service Features" onClick="alert('If you will be requiring installation or relocation of phone jack/outlet, please check box under WIRING REQUIRED below')"> </B> </FONT></TD> <TD width="92%"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><A href="http://www.otc.fsu.edu/Department/Offer/BSOffer.html" target="_blank">Basic Telephone Service</A>/<BR> <A href="http://www.otc.fsu.edu/Department/Offer/FCCoffer.html" target="_blank">Custom Calling Features</A> </FONT></TD> </TR> <TR valign="top" bgcolor="#FFFFFF"> <TD bgcolor="#E8E8E8"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B> <INPUT name="Instrument" type=checkbox id="Instrument" tabindex="25" value="Instrument"> </B></FONT></TD> <TD bgcolor="#F0F0F0"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><A href="http://www.otc.fsu.edu/Department/Offer/IOffer.html" target="_blank">Instruments/Equipment</A> </FONT></TD> </TR> <TR valign="top"> <TD colspan="2"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><A href="http://www.otc.fsu.edu/Department/Offer/OLDOffer.html" target="_blank"><B>Long Distance</B></A><B> Options</B></FONT></TD> </TR> <TR valign="top" bgcolor="#E8E8E8"> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B> <INPUT type=checkbox value="800 Number" name="Number_800" tabindex="26"> </B></FONT></TD> <TD valign="middle" nowrap bgcolor="#F0F0F0"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><A href="http://www.otc.fsu.edu/Department/Offer/OLDOffer.html#800number" target="_blank">800 Number</A></FONT></TD> </TR> <TR valign="top"> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B> <INPUT type=checkbox value="Calling Card" name="Calling_Card" tabindex="27"> </B></FONT></TD> <TD valign="middle" nowrap><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><A href="http://www.otc.fsu.edu/Department/Offer/OLDOffer.html#callingcard" target="_blank">Calling Card</A></FONT></TD> </TR> <TR valign="top" bgcolor="#F0F0F0"> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B> <INPUT name="COS" type=checkbox id="COS" tabindex="28" value="Class Of Service Change"> </B></FONT></TD> <TD valign="middle" nowrap><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <B> </B> <A href="http://www.otc.fsu.edu/Department/Offer/BSOffer.html#dc" target="_blank">Class of Service</A><BR> Dialing abilities (29)</FONT></TD> </TR> <TR valign="top"> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B> <INPUT name="Auth_Code" type=checkbox id="Auth_Code" tabindex="29" value="Authorization Code"> </B></FONT></TD> <TD valign="middle" nowrap><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <B> </B> <A href="http://www.otc.fsu.edu/Department/Offer/OLDOffer.html" target="_blank">Auth Code Change</A></FONT></TD> </TR> <TR valign="bottom" bgcolor="#FFFFFF"> <TD valign="top" bgcolor="#F0F0F0"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <B> <INPUT onClick="alert('Your new voice mail order must contain the following information: Phone number on which to place voice mail; Attendant phone number; Class of Service; Size/Type of Box; and User name.')" type=checkbox value="Voice Mail" tabindex="30" name="Voice_Mail"> </B> </FONT></TD> <TD valign="middle" bgcolor="#F0F0F0"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><A href="http://www.otc.fsu.edu/Department/Offer/VMOffer.html" target="_blank">Voice Mail</A> </FONT></TD> </TR> <TR valign="bottom" bgcolor="#FFFFFF"> <TD valign="top"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B> </B></FONT></TD> <TD valign="middle"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B> <INPUT type=checkbox value="Reset Voicemail Passcode" name="VM_Passcode_Reset" tabindex="31"> </B>Reset Voice Mail Passcode (only)</FONT></TD> </TR> <TR valign="middle" bgcolor="#F0F0F0"> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <B> <INPUT name="Meet_Me" type=checkbox id="Meet_Me" tabindex="32" value="Meet-Me-Conference"> </B> </FONT></TD> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><A href="http://www.otc.fsu.edu/Department/Offer/MMCOffer.html" target="_blank">Meet-Me Conference</A> (Up to 30 participants)</FONT></TD> </TR> <TR valign="top" bgcolor="#FFFFFF"> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <B> <INPUT onClick="alert('You have requested a Cellular Purchase. By submitting an online order for a Cellular Purchase you recognize that each department and respective department heads are responsible for all cellular phone charges incurred. Cellular phones are to be used only for University and State business.')" tabindex="33" type=checkbox value="Cellular Service" name="Cellular_Service"> </B> </FONT></TD> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><A href="http://www.otc.fsu.edu/Department/Offer/WSOffer.html" target="_blank">Cellular/Wireless Service</A> (includes cellular, PDA's, connection cards, pagers, radios) </FONT></TD> </TR> </TABLE> </CENTER></TD> <TD width="50%" align="center" valign="top"><CENTER> <TABLE width="100%" border="0" cellspacing="0" cellpadding="3"> <TR valign="middle" bgcolor="#990000"> <TD colspan="2" bgcolor="#CCCCCC"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>VIDEO SERVICES</B></FONT></TD> </TR> <TR valign="top" bgcolor="#FFFFFF"> <TD width="8%"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <B> <INPUT type=checkbox onClick="alert('If you will be requiring installation or relocation of cable jack/outlet, please check box under WIRING REQUIRED below')" value="Seminole Cablevision (SCV)" name="SCV" tabindex="34"> </B> </FONT></TD> <TD width="92%"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><A href="http://www.otc.fsu.edu/Department/Offer/SCVOffer.html">Cable TV Service</A> (Seminole CableVision)</FONT></TD> </TR> <TR valign="top" bgcolor="#F0F0F0"> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <B> <INPUT type=checkbox value="Video Conference" name="Video_Conference" tabindex="35"> </B> </FONT></TD> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><A href="http://www.otc.fsu.edu/Department/Offer/VCOffer.html">Video Conference/Room & Polycom Rental</A></FONT></TD> </TR> </TABLE> <TABLE width="100%" border="0" cellpadding="4" cellspacing="0"> <TR valign="middle" bgcolor="#990000"> <TD colspan="2" bgcolor="#CCCCCC"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>DATA SERVICES</B></FONT></TD> </TR> <TR valign="middle"> <TD width="8%"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <INPUT name="Networking" tabindex="36" type="checkbox" id="Networking" onClick="alert('If you will be requiring installation or relocation of network jack/outlet, please check box under WIRING REQUIRED below')" value="Networking Services"> </FONT></TD> <TD width="92%"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><A href="http://www.otc.fsu.edu/Networking/NetMenu.html">Networking Setup/Configuration</A> </FONT></TD> </TR> <TR valign="bottom" bgcolor="#E8E8E8"> <TD colspan="2"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>High Speed Internet Access (off-campus)</B></FONT></TD> </TR> <TR valign="top"> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B> <INPUT name="DSL" type=checkbox id="DSL" tabindex="37" onClick="alert('If you will be requiring installation or relocation of DSL jack/outlet, please check box under WIRING REQUIRED below')" value="Digital Subscriber Lines (Dept)"> </B></FONT></TD> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <B> </B> <A href="http://www.otc.fsu.edu/Department/Offer/InternetOffer.html#dsl">FS U@Home</A> (DSL)</FONT></TD> </TR> <TR valign="top" bgcolor="#F0F0F0"> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <INPUT name="Cable_Internet" tabindex="38" onClick="alert('If you will be requiring installation or relocation of Cable Internet jack/outlet, please check box under WIRING REQUIRED below')" type="checkbox" id="Cable_Internet" value="Cable Internet"> </FONT></TD> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><A href="http://www.otc.fsu.edu/Department/Offer/InternetOffer.html#cable"> Cable Internet </A></FONT></TD> </TR> </TABLE> <TABLE width="100%" border="0" cellspacing="0" cellpadding="3"> <TR valign="middle" bgcolor="#990000"> <TD height="20" colspan="2" bgcolor="#CCCCCC"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>BUILDING ACCESS/SECURITY</B></FONT></TD> </TR> <TR valign="top" bgcolor="#FFFFFF"> <TD width="8%"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <INPUT name="Access_System" type="checkbox" id="Access_System" tabindex="39" onClick="alert('If you will be requiring installation or relocation of alarm and/or card reader, please check box under WIRING REQUIRED below')" value="Access Security System"> </FONT></TD> <TD width="92%"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><A href="http://www.otc.fsu.edu/Department/Offer/ACSSOffer.html">Access (Card)</A>, <A href="http://www.otc.fsu.edu/Department/Offer/CCTVOffer.html">CCTV</A>, Alarms & Monitoring</FONT></TD> </TR> </TABLE> <TABLE width="100%" border="0" cellpadding="4" cellspacing="0"> <TR valign="middle" bgcolor="#990000"> <TD colspan="2" bgcolor="#CCCCCC"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>BILLING & INFORMATION UPDATES </B></FONT></TD> </TR> <TR valign="middle" bgcolor="#FFFFFF"> <TD width="8%"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <B> <INPUT type=checkbox value="Budget Information Change" name="Budget_Info_Change" tabindex="40"> </B> </FONT></TD> <TD width="92%"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif">Budget Changes</FONT></TD> </TR> <TR valign="middle" bgcolor="#F0F0F0"> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <B> <INPUT name="Information_Change" type="checkbox" tabindex="41" value="Information Change"> </B> </FONT></TD> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif">Name, Location, Chart Field Changes</FONT></TD> </TR> </TABLE> </CENTER></TD> </TR> <TR bgcolor="#DECE9C"> <TD colspan="2" align="center" valign="top"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>MISCELLANEOUS OPTIONS (APPLIES TO ALL ABOVE)</B></FONT></TD> </TR> <TR> <TD align="center" valign="top"><TABLE width="100%" cellpadding="3" cellspacing="0"> <TR valign="middle" bgcolor="#CCCCCC"> <TD height="20" colspan="2"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B> WIRING REQUIRED</B></FONT></TD> </TR> <TR valign="top" bgcolor="#FFFFFF"> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <B> <INPUT name="Wiring" type="checkbox" id="Wiring" tabindex="42" value="Phone PC CATV Wiring"> </B> </FONT></TD> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif">Check if ANY part of this order requires installation or relocation of phone, computer or cable jack/outlet, alarm/card reader, etc. </FONT></TD> </TR> </TABLE> <TABLE width="100%" border="0" cellspacing="0" cellpadding="3"> <TR bgcolor="#CCCCCC"> <TD colspan="2"><FONT color="#990000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>TO CANCEL/DISCONNECT SERVICES</B></FONT></TD> </TR> <TR valign="top"> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B><IMG src="images/starred.gif" alt="Access Help Files" width=18 height=18></B></FONT></TD> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif">Check service box above & explain under "Details of Work" below, including disconnect date.</FONT></TD> </TR> </TABLE></TD> <TD align="center" valign="top"><TABLE width="100%" cellpadding="3" cellspacing="0"> <TR valign="middle" bgcolor="#CCCCCC"> <TD height="20" colspan="2"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>ESTIMATE ONLY</B></FONT></TD> </TR> <TR valign="top" bgcolor="#FFFFFF"> <TD height="40"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <B> <INPUT name="Estimate" type="checkbox" id="Estimate-checked" tabindex="43" value="ESTIMATE ONLY"> </B> </FONT></TD> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> Check if an estimate is required BEFORE processing order </FONT></TD> </TR> </TABLE> <TABLE width="100%" border="0" cellspacing="0" cellpadding="3"> <TR bgcolor="#CCCCCC"> <TD colspan="2"><FONT color="#990000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>TO VOID AN ENTIRE ORDER</B></FONT></TD> </TR> <TR valign="top"> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B><IMG src="images/starred.gif" alt="Access Help Files" width=18 height=18></B></FONT></TD> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><I> Email <A href="mailto:orders@xxxxxxxxxxx" target="_blank">orders@xxxxxxxxxxx</A> & provide TSR Order Number</I></FONT></TD> </TR> </TABLE> </TR> <TR bgcolor="#DECE9C"> <TD colspan="2" align="center" valign="top" id="t_Customer_Description"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B>DETAILS OF WORK <IMG src="images/stargreens.gif" alt="Required Field!"></B><B><BR> </B>(Please try to be as specific as possible) </FONT></TD> </TR> <TR> <TD colspan="2" align="center" valign="top"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> ** If <B><FONT color="#990000">special due date needed</FONT></B> other than the 10-business-day standard turnaround, explain here **<FONT size="2"><BR> </FONT> <TEXTAREA name="Customer_Description" cols=100 rows=10 tabindex="44"></TEXTAREA> </FONT></TD> </TR> </TABLE> <TABLE border="0" cellpadding="4" cellspacing="0"> <TR> <TD><TABLE width="100%" border="0" cellpadding="6" cellspacing="0"> <TR align="center" bgcolor="#FFFFCC"> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><B><FONT color="#CC0000">Click the Send button only ONCE!</FONT><BR> </B>It may take several moments to process information.<BR> <INPUT name="new_record" type="submit" id="new_record" tabindex="45" value="Send Form to OTC"> </FONT></TD> </TR> <TR align="center"> <TD align="center"><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <INPUT type="reset" value="Reset" tabindex="46" name="reset"> </FONT></TD> </TR> <TR align="center"> <TD><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"> <IMG src="images/tipblue.gif" alt="Access Help Files" border="0"> <A href="http://www.otc.fsu.edu/Department/OrderInfo.html" target="_blank">What happens after I place my Order</A>?</FONT></TD> </TR> </TABLE></TD> </TR> </TABLE> <P><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><I>For questions, comments or technical difficulties on this form, email <A href="mailto:help@xxxxxxxxxxx">help@xxxxxxxxxxx</A></I></FONT></P> </TD> </TR> </TBODY> </TABLE> </CENTER> </FORM> <CENTER> <SCRIPT> // form fields description structure var a_fields = { 'Contact_Name':{'l':'Contact Name','r':true,'t':'t_Contact_Name'}, 'Contact_Phone':{'l':'Contact Phone Number','r':true,'f':'phone','t':'t_Contact_Phone'}, 'Contact_Email':{'l':'Contact E-mail','r':true,'f':'email','t':'t_Contact_Email'}, 'Contact_Room':{'l':'Contact Room','r':true,'f':'alphanum','t':'t_Contact_Room'}, 'Budget_Auth_Signature':{'l':'Budget Authorized Signature','r':true,'t':'t_Budget_Auth_Signature'}, 'Budget_Phone':{'l':'Budget Manager Phone','r':true,'f':'phone','t':'t_Budget_Phone'}, 'Budget_Email_Address':{'l':'Budget Manager E-mail','r':true,'f':'email','t':'t_Budget_Email_Address'}, 'Budget_Rec_DeptID':{'l':'OMNI Dept ID','r':true,'f':'integer','t':'t_Budget_Rec_DeptID'}, 'Budget_Rec_FundCode':{'l':'OMNI Fund Code','r':true,'f':'integer','t':'t_Budget_Rec_FundCode'}, 'Budget_Rec_Project':{'l':'OMNI Project','r':true,'f':'alphanum','t':'t_Budget_Rec_Project'}, 'Service_Location_Rm':{'l':'Service Location Room','r':true,'t':'t_Service_Location_Rm'}, 'Customer_Description':{'l':'Details of Work','r':true,'t':'t_Customer_Description'} }, o_config = { 'to_disable' : ['Submit', 'Reset'], 'alert' : 1 } // validator constructor call var v = new validator('form', a_fields, o_config); </SCRIPT> </CENTER> </BODY> </HTML> PROCESS PAGE: <?php require_once('../FX/FX.php'); $newRecordArray = array('Contact_Name' => $_POST['Contact_Name'], 'Contact_Phone' => $_POST['Contact_Phone'],'Contact_Email' => $_POST['Contact_Email'],'Contact_Room' => $_POST['Contact_Room'],'Contact_Bldg_Unlisted' => $_POST['Contact_Bldg_Unlisted'],'Department_Unlisted' => $_POST['Department_Unlisted'],'Budget_Auth_Signature' => $_POST['Budget_Auth_Signature'],'Budget_Phone' => $_POST['Budget_Phone'],'Budget_Email_Address' => $_POST['Budget_Email_Address'],'Budget_Rec_DeptID' => $_POST['Budget_Rec_DeptID'],'Budget_Rec_FundCode' => $_POST['Budget_Rec_FundCode'],'Budget_Rec_Project' => $_POST['Budget_Rec_Project'],'Budget_NR_DeptID' => $_POST['Budget_NR_DeptID'],'Budget_NR_FundCode' => $_POST['Budget_NR_FundCode'],'Budget_NR_Project' => $_POST['Budget_NR_Project'],'Service_Bldg_Unlisted' => $_POST['Service_Bldg_Unlisted'],'Service_Location_Rm' => $_POST['Service_Location_Rm'],'Customer_Description' => $_POST['Customer_Description']); // configure a connection to FileMaker Server Advanced $ordersQuery = new FX('www2.otc.fsu.edu', '80', 'FMPro7'); // set database and layout information $ordersQuery->SetDBData('WEB_Forms.fp7', 'Orders_FormView'); // set database username and password $ordersQuery->SetDBUserPass('***', '***'); // retrieve all records in this database available to the current user // add parameter array for new record $ordersQuery->AddDBParamArray($newRecordArray); // Add pararameters for the checkboxes. This allows some to be not checked without an error. $checkBoxes = array('BasicSvc_Features','Instrument','Number_800','Calling_Card','COS' ,'Auth_Code','Voice Mail','VM_Passcode_Reset','Meet_Me','Cellular_Service','SCV','Video_Conf erence','Networking','DSL','Cable_Internet','Access_System','Budget_Info _Change','Information_Change','Wiring', 'Estimate'); foreach($checkBoxes as $checkBox) { if(isset($_POST[$checkBox])) { $ordersQuery->AddDBParam($checkBox, $_POST[$checkBox]); } } // Add pararameters for the drop-down lists. This allows some to be empty without an error. $dropBoxes = array('Contact_Bldg','Department_Name','Service_Location_Bldg','ChartFie ld_1','ChartField_2','ChartField_3'); foreach($dropBoxes as $dropBox) { if(isset($_POST[$dropBox])) { $ordersQuery->AddDBParam($dropBox, $_POST[$dropBox]); } } $orders = $ordersQuery->DoFXAction(FX_ACTION_NEW); foreach ($orders as $order); ?> <!--THIS IS WHERE THE EMAIL HTML BEGINS--> <?php //define the receiver of the email $to = ($order['BudgetMgrEmail_OMNI_REC'].', '.$_POST['Contact_Email'].', '.$_POST['Budget_Email_Address'].', CustomerCare@xxxxxxxxxxx'); //define the subject of the email $subject = 'Online TSR Order Number '.$order['Order_Number']; //create a boundary string. It must be unique //so we use the MD5 algorithm to generate a random hash $random_hash = md5(date('r', time())); //define the headers we want passed. Note that they are separated with \r\n $headers = "From: Orders@xxxxxxxxxxx\r\nReply-To: Customer_Care@xxxxxxxxxxx\r\nbcc: otconlineorders@xxxxxxxxxxx"; //add boundary string and mime type specification $headers .= "\r\nContent-Type: multipart/alternative; boundary=\"PHP-alt-".$random_hash."\""; //define the body of the message. ob_start(); //Turn on output buffering ?> --PHP-alt-<?php echo $random_hash; ?> Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit <PRE> Hello! IMPORTANT: Do not reply to this email, it is not monitored. Direct inquires to Customer_Care@xxxxxxxxxxx This is an auto-generated confirmation to the email addresses submitted as either the budget authority and/or contact for the following Office of Telecommunications Online Order. IF APPROVED, NO ACTION IS REQUIRED!! If not approved, send an email to Customer_Care@xxxxxxxxxxx to deny this request within 3 business days. **** Construction projects cannot be used for recurring charges. Completion of this request will be coordinated through you by your consultant (10 business day average turnaround; some exceptions apply.) Additional information should be sent to Customer_Care@xxxxxxxxxxxx -------------------- Need Assistance? Online: - Getting Started: http://www.otc.fsu.edu/GS.html - Department Menu: http://www.otc.fsu.edu/Department/DeptMenu.html (Look for the link to Instructions) - OTC Home: http://www.otc.fsu.edu/ In Person: 105 Rod K. Shaw Building (On the corner of Call and Dewey) By Phone: 644-HELP Email: Customer_Care@xxxxxxxxxxx Thank you again for the opportunity to be of service. </PRE> --PHP-alt-<?php echo $random_hash; ?> Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: 7bit <!--THIS IS WHERE THE EMAIL HTML BEGINS--> <TABLE width="625" border="0" align="center" cellpadding="4" cellspacing="0"> <TR bgcolor="#FFFFFF"> <TD height="29" colspan="2" bgcolor="#FFFFFF"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>IMPORTANT</B>: Do not reply to this email, it is not monitored. Direct inquires to <A href="maito:Customer_Care@xxxxxxxxxxx">Customer_Care@xxxxxxxxxxx</A></FO NT>.<BR> <BR> <FONT size="2" face="Verdana, Arial, Helvetica, sans-serif">This is an auto-generated confirmation to the email addresses submitted as either the budget authority and/or contact for the following Office of Telecommunications Online Order.</FONT><BR> <BR> <P><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>BUDGET AUTHORITY APPROVAL</B>: </FONT></P> <UL> <LI><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif">Budget Authorized Signature <u>Submitted</u>: <?php echo ($_POST['Budget_Auth_Signature']); ?></FONT></LI> <LI><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><u>OMNI Specified</u> Budget Manager(s):</FONT> <UL> <LI><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif">Monthly - <?php echo ($order['BudgetManager_OMNI_REC']); ?></FONT></LI> <LI><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif">One-Time - <?php echo ($order['BudgetManager_OMNI_NR']); ?></FONT></LI> </UL> </LI> </UL> <P><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif">IF APPROVED, NO ACTION IS REQUIRED!! If not approved, send an email to <A href="maito:Customer_Care@xxxxxxxxxxx">Customer_Care@xxxxxxxxxxx</A> to deny this request within 3 business days. </FONT></P> <P><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif">*NOTE: Construction projects <u>cannot</u> be used for recurring (monthly) charges!</FONT></P></TD> </TR> <TR bgcolor="#CCCC99"> <TD colspan="2"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>ORDER INFORMATION: <FONT color="#990000"> <?php if(isset($_POST['Estimate'])){ echo ($_POST['Estimate']); } ?> </FONT> </B></FONT></TD> </TR> <TR> <TD align="right" nowrap><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Order Number: </B></FONT></TD> <TD width="397"><FONT color="#990000" size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><?php echo ($order['Order_Number']); ?></B></FONT></TD> </TR> <TR> <TD align="right" valign="top" nowrap><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Your Consultant: <BR> <IMG src="images/clearpixel.gif" alt="spacer" width="200" height="1"></B></FONT></TD> <TD width="397" valign="top"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><?php echo ($order['Consultant_Name']); ?></B></FONT></TD> </TR> <TR bgcolor="#CCCC99"> <TD colspan="2" bgcolor="#CCCC99"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>CONTACT INFORMATION: </B></FONT></TD> </TR> <TR> <TD colspan="2" align="left"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif">Completion of this request will be coordinated through you by your consultant (10 business day average turnaround; some exceptions apply.) Additional information should be sent to <A href="maito:Customer_Care@xxxxxxxxxxx">Customer_Care@xxxxxxxxxxx</A>.</F ONT></TD> </TR> <TR> <TD align="right" nowrap><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Contact Name: </B></FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo ($_POST['Contact_Name']); ?></FONT></TD> </TR> <TR> <TD align="right" nowrap><FONT face="Verdana, Arial, Helvetica, sans-serif"> </FONT><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Contact E-mail: </B></FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo ($_POST['Contact_Email']); ?></FONT></TD> </TR> <TR> <TD align="right" nowrap><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Contact Room: </B></FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo ($_POST['Contact_Room']); ?></FONT></TD> </TR> <TR> <TD align="right" nowrap><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Contact Bldg/Location: </B></FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"> <?php if (isset($_POST['Contact_Bldg'])) { echo ($_POST['Contact_Bldg']); } if (isset($_POST['Contact_Bldg_Unlisted'])) { echo ('<BR>'.$_POST['Contact_Bldg_Unlisted']); } ?> </FONT></TD> </TR> <TR> <TD align="right" nowrap><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Contact Phone: <BR> <IMG src="images/clearpixel.gif" alt="spacer" width="200" height="1"></B></FONT></TD> <TD width="397" valign="top"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo ($_POST['Contact_Phone']); ?></FONT></TD> </TR> </TABLE> <TABLE width="625" border="0" align="center" cellpadding="4" cellspacing="0"> <TR bgcolor="#CCCC99"> <TD colspan="2"><B><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif">DEPARTMENT BILLING INFORMATION:</FONT></B></TD> </TR> <TR> <TD align="right" valign="top" nowrap><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Department Name: </B> </FONT></TD> <TD width="397" valign="middle"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"> <?php if (isset($_POST['Department_Name'])) { echo ($_POST['Department_Name']); } if (isset($_POST['Department_Unlisted'])) { echo ('<BR>'.$_POST['Department_Unlisted']); } ?> </FONT></TD> </TR> <TR> <TD align="right" valign="top"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Budget Manager/<BR /> Authorized Signature: </B></FONT></TD> <TD width="397" valign="bottom"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo ($_POST['Budget_Auth_Signature']); ?></FONT></TD> </TR> <TR> <TD align="right" valign="top" nowrap><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Budget Mgr Phone No: </B></FONT></TD> <TD width="397" valign="middle"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo ($_POST['Budget_Phone']); ?></FONT></TD> </TR> <TR> <TD align="right" valign="top" nowrap><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Budget Mgr E-Mail: <BR> <IMG src="images/clearpixel.gif" alt="spacer" width="200" height="1"></B></FONT></TD> <TD width="397" valign="top"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo ($_POST['Budget_Email_Address']); ?></FONT></TD> </TR> <TR> <TD colspan="2" bgcolor="#E5E5E5"><P><FONT size="1" face="Verdana, Arial, Helvetica, sans-serif"><I>The following information was pulled from FSU's OMNI System. The Budget Manager listed below will be informed via email of this order. If this information is incorrect, please report it to your Budget Manager immediately.</I></FONT></P></TD> </TR> <TR> <TD align="right" bgcolor="#F2F2F2"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Budget Manager in OMNI--<BR /> MONTHLY: </B></FONT></TD> <TD width="397" align="left" valign="bottom" bgcolor="#F2F2F2"><I><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo ($order['BudgetManager_OMNI_REC']); ?> - <?php echo ($order['BudgetMgrEmail_OMNI_REC']); ?></FONT></I></TD> </TR> <TR> <TD align="right" nowrap bgcolor="#F2F2F2"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>ONE-TIME</B><I> (if applicable)</I><B>: </B></FONT><BR> <IMG src="images/clearpixel.gif" alt="spacer" width="220" height="1"></TD> <TD width="397" align="left" valign="middle" bgcolor="#F2F2F2"><I><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo ($order['BudgetManager_OMNI_NR']); ?> - <?php echo ($order['BudgetMgrEmail_OMNI_NR']); ?></FONT></I></TD> </TR> </TABLE> <TABLE width="625" border="0" align="center" cellpadding="4" cellspacing="0"> <TR> <TD colspan="2" bgcolor="#FFFFCC"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"> <B>MONTHLY CHARGE INFORMATION</B> </FONT></TD> </TR> <TR> <TD align="right"><FONT face="Verdana, Arial, Helvetica, sans-serif" size="2"><B>OMNI Fund Code: </B></FONT></TD> <TD width="397"><FONT face="Verdana, Arial, Helvetica, sans-serif" size="2"><?php echo ($_POST['Budget_Rec_FundCode']); ?></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Department ID: </B></FONT></TD> <TD width="397"><FONT face="Verdana, Arial, Helvetica, sans-serif" size="2"><?php echo ($_POST['Budget_Rec_DeptID']); ?></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Project Code</B><B>: </B> </FONT></TD> <TD width="397"><FONT face="Verdana, Arial, Helvetica, sans-serif" size="2"><?php echo ($_POST['Budget_Rec_Project']); ?></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif">Chartfield 1: </FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"> <?php if(isset($_POST['ChartField_1'])){ echo ($_POST['ChartField_1']); } ?> </FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif">Chartfield 2: </FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"> <?php if(isset($_POST['ChartField_2'])){ echo ($_POST['ChartField_2']); } ?> </FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif">Chartfield 3: </FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"> <?php if(isset($_POST['ChartField_3'])){ echo ($_POST['ChartField_3']); } ?> </FONT></TD> </TR> </TABLE> <TABLE width="625" border="0" align="center" cellpadding="4" cellspacing="0"> <TR> <TD colspan="2" bgcolor="#FFFFCC"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"> <B>ONE-TIME CHARGE INFORMATION</B> </FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>OMNI Fund Code: </B></FONT></TD> <TD width="397"><FONT face="Verdana, Arial, Helvetica, sans-serif" size="2"><?php echo ($_POST['Budget_NR_FundCode']); ?></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Department ID: </B></FONT></TD> <TD width="397"><FONT face="Verdana, Arial, Helvetica, sans-serif" size="2"><?php echo ($_POST['Budget_NR_DeptID']); ?></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Project Code</B><B>: </B></FONT></TD> <TD width="397"><FONT face="Verdana, Arial, Helvetica, sans-serif" size="2"><?php echo ($_POST['Budget_NR_Project']); ?></FONT></TD> </TR> </TABLE> <TABLE width="625" border="0" align="center" cellpadding="4" cellspacing="0"> <TR bgcolor="#CCCC99"> <TD colspan="2"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>SERVICE INFORMATION: </B></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Service Building Address: </B></FONT></TD> <TD width="399"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"> <?php if (isset($_POST['Service_Location_Bldg'])) { echo ($_POST['Service_Location_Bldg']); } if (isset($_POST['Service_Location_Unlisted'])) { echo ('<BR>'.$_POST['Service_Location_Unlisted']); } ?> </FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Service Room Number:<BR> <IMG src="images/clearpixel.gif" alt="spacer" width="200" height="1"> </B></FONT></TD> <TD valign="top"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo ($_POST['Service_Location_Rm']); ?></FONT></TD> </TR> <TR bgcolor="#FFFFCC"> <TD colspan="2"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>DETAILS OF WORK: </B></FONT></TD> </TR> <TR> <TD colspan="2"><BLOCKQUOTE> <P><B><FONT size="2" face="Georgia, Times New Roman, Times, serif"><?php echo ($_POST['Customer_Description']); ?></FONT></B></P> </BLOCKQUOTE></TD> </TR> <TR> <TD colspan="2"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><EM> Service(s) selected:</EM></B></FONT> <BLOCKQUOTE> <?php foreach($checkBoxes as $checkBox) { if(isset($_POST[$checkBox])) { echo "<FONT size='2' face='Verdana, Arial, Helvetica, sans-serif'><li>$checkBox</li></font>"; } } ?> </BLOCKQUOTE> <HR /> </TD> </TR> <TR> <TD colspan="2"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Need Assistance?</B></FONT> <P><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif">Online:</FONT></P> <UL> <LI><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"> Getting Started: <A href="http://www.otc.fsu.edu/GS.html" target="_blank">http://www.otc.fsu.edu/GS.html</A></FONT></LI> <LI><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"> Department Menu: <A href="http://www.otc.fsu.edu/Department/DeptMenu.html" target="_blank">http://www.otc.fsu.edu/Department/DeptMenu.html</A> (Look for the link to Instructions)</FONT></LI> <LI><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"> OTC Home: <A href="http://www.otc.fsu.edu/" target="_blank">http://www.otc.fsu.edu/</A></FONT></LI> </UL> <P><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif">In Person: </FONT><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif">105 Rod K. Shaw Building (On the corner of Call and Dewey) </FONT></P> <P><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif">By Phone: 644-HELP</FONT></P> <FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"> Email: <A href="maito:Customer_Care@xxxxxxxxxxx">Customer_Care@xxxxxxxxxxx</A></FO NT><BR> <BR> <P><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif">Thank you again for the opportunity to be of service.</FONT></P></TD> </TR> </TABLE> </B></FONT> </DIV></TD> </TR> </TABLE> <!--THIS IS WHERE THE ON-SCREEN CONFIRMATION INFO BEGINS--> <HTML> <HEAD> <TITLE>OTC Online Order Confirmation</TITLE> <LINK href="tsr.css" rel="stylesheet" type="text/css"> </HEAD> <BODY text=#000000 vLink=#666666 aLink=#cc0000 link=#990000 bgColor=#ffffff> <DIV align="center"> <TABLE width="625" border="0" cellpadding="4" cellspacing="0"> <TR bgcolor="#CCCC99"> <TD height="29" colspan="2" bgcolor="#FFFFFF"> <CENTER> <? //copy current buffer contents into $message variable and delete current output buffer $message = ob_get_clean(); //send the email $mail_sent = @mail( $to, $subject, $message, $headers ); //if the message is sent successfully print "Mail sent". Otherwise print "Mail failed" echo $mail_sent ? "<CENTER><FONT face='Verdana' size='2'><b>Please print for your records. An email has been sent to OTC, the contact email,<br>the budget manager email and the email of the OMNI-specified Budget Manager.</b></font><br>" : "<FONT face='Verdana' color='red' size='2'><b>Please print for your records and call 644-HELP. Confirmation e-mail FAILED!</b></font></center><br>"; ?> <FONT color="#990000" face="Verdana, Arial, Helvetica, sans-serif"><B><IMG src="images/tsr_confbanner.jpg" alt="confirmation banner" width="625" height="65"><BR> <FONT size="3"> Confirmation Information</FONT></B></FONT> <TABLE width="625" border="0" align="center" cellpadding="4" cellspacing="0"> <TR bgcolor="#CCCC99"> <TD colspan="2"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>ORDER INFORMATION: <FONT color="#990000"> <?php if(isset($_POST['Estimate'])){ echo ($_POST['Estimate']); } ?> </FONT> </B></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Order Number: </B></FONT></TD> <TD width="397"><FONT color="#990000" size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><?php echo ($order['Order_Number']); ?></B></FONT></TD> </TR> <TR> <TD align="right" valign="top"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Your Consultant: <BR> <IMG src="images/clearpixel.gif" alt="spacer" width="200" height="1"></B></FONT></TD> <TD width="397" valign="top"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><?php echo ($order['Consultant_Name']); ?></B></FONT></TD> </TR> <TR bgcolor="#CCCC99"> <TD colspan="2" bgcolor="#CCCC99"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>CONTACT INFORMATION: </B></FONT></TD> </TR> <TR> <TD colspan="2" align="left"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif">Completion of this request will be coordinated through you by your consultant (10 business day average turnaround; some exceptions apply.) Additional information should be sent to <A href="maito:Customer_Care@xxxxxxxxxxx">Customer_Care@xxxxxxxxxxx</A>.</F ONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Contact Name: </B></FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo ($_POST['Contact_Name']); ?></FONT></TD> </TR> <TR> <TD align="right"><FONT face="Verdana, Arial, Helvetica, sans-serif"> </FONT><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Contact E-mail: </B></FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo ($_POST['Contact_Email']); ?></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Contact Room: </B></FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo ($_POST['Contact_Room']); ?></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Contact Bldg/Location: </B></FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"> <?php if (isset($_POST['Contact_Bldg'])) { echo ($_POST['Contact_Bldg']); } if (isset($_POST['Contact_Bldg_Unlisted'])) { echo ('<BR>'.$_POST['Contact_Bldg_Unlisted']); } ?> </FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Contact Phone: <BR> <IMG src="images/clearpixel.gif" alt="spacer" width="200" height="1"></B></FONT></TD> <TD width="397" valign="top"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo ($_POST['Contact_Phone']); ?></FONT></TD> </TR> </TABLE> </CENTER> <TABLE width="625" border="0" align="center" cellpadding="4" cellspacing="0"> <TR bgcolor="#CCCC99"> <TD colspan="2"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>DEPARTMENT BILLING INFORMATION:</B></FONT></TD> </TR> <TR> <TD align="right" valign="top"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Department Name: </B></FONT></TD> <TD width="397" valign="middle"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B> <?php if (isset($_POST['Department_Name'])) { echo ($_POST['Department_Name']); } if (isset($_POST['Department_Unlisted'])) { echo ('<BR>'.$_POST['Department_Unlisted']); } ?> </B></FONT></TD> </TR> <TR> <TD align="right" valign="top"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Budget Manager/<BR /> Authorized Signature: </B></FONT></TD> <TD width="397" valign="bottom"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><?php echo ($_POST['Budget_Auth_Signature']); ?></B></FONT></TD> </TR> <TR> <TD align="right" valign="top"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Budget Mgr Phone No: </B></FONT></TD> <TD width="397" valign="middle"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><?php echo ($_POST['Budget_Phone']); ?></B></FONT></TD> </TR> <TR> <TD align="right" valign="top"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Budget Mgr E-Mail: <BR> <IMG src="images/clearpixel.gif" alt="spacer" width="200" height="1"></B></FONT></TD> <TD width="397" valign="top"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><?php echo ($_POST['Budget_Email_Address']); ?></B></FONT></TD> </TR> <TR> <TD colspan="2" bgcolor="#E5E5E5"><P><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><I>The following information was pulled from FSU's OMNI System. The Budget Manager listed below will be informed via email of this order. If this information is incorrect, please report it to your Budget Manager immediately.</I></B></FONT></P></TD> </TR> <TR> <TD align="right" bgcolor="#F2F2F2"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Budget Manager in OMNI--<BR /> MONTHLY: </B></FONT></TD> <TD width="397" align="left" valign="bottom" bgcolor="#F2F2F2"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><I><?php echo ($order['BudgetManager_OMNI_REC']); ?> - <?php echo ($order['BudgetMgrEmail_OMNI_REC']); ?></I></B></FONT></TD> </TR> <TR> <TD align="right" bgcolor="#F2F2F2"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>ONE-TIME<I> (if applicable)</I>: <BR> <IMG src="images/clearpixel.gif" alt="spacer" width="200" height="1"></B></FONT></TD> <TD width="397" align="left" valign="middle" bgcolor="#F2F2F2"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><I><?php echo ($order['BudgetManager_OMNI_NR']); ?> - <?php echo ($order['BudgetMgrEmail_OMNI_NR']); ?></I></B></FONT></TD> </TR> </TABLE> <TABLE width="625" border="0" align="center" cellpadding="4" cellspacing="0"> <TR> <TD colspan="2" bgcolor="#FFFFCC"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B> MONTHLY CHARGE INFORMATION </B></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>OMNI Fund Code: </B></FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><?php echo ($_POST['Budget_Rec_FundCode']); ?></B></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Department ID: </B></FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><?php echo ($_POST['Budget_Rec_DeptID']); ?></B></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Project Code: </B></FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><?php echo ($_POST['Budget_Rec_Project']); ?></B></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Chartfield 1: </B></FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B> <?php if(isset($_POST['ChartField_1'])){ echo ($_POST['ChartField_1']); } ?> </B></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Chartfield 2: </B></FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B> <?php if(isset($_POST['ChartField_2'])){ echo ($_POST['ChartField_2']); } ?> </B></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Chartfield 3: </B></FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B> <?php if(isset($_POST['ChartField_3'])){ echo ($_POST['ChartField_3']); } ?> </B></FONT></TD> </TR> </TABLE> <TABLE width="625" border="0" align="center" cellpadding="4" cellspacing="0"> <TR> <TD colspan="2" bgcolor="#FFFFCC"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B> ONE-TIME CHARGE INFORMATION </B></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>OMNI Fund Code: </B></FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><?php echo ($_POST['Budget_NR_FundCode']); ?></B></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Department ID: </B></FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><?php echo ($_POST['Budget_NR_DeptID']); ?></B></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Project Code: </B></FONT></TD> <TD width="397"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><?php echo ($_POST['Budget_NR_Project']); ?></B></FONT></TD> </TR> </TABLE> <TABLE width="625" border="0" align="center" cellpadding="4" cellspacing="0"> <TR bgcolor="#CCCC99"> <TD colspan="2"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>SERVICE INFORMATION: </B></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Service Building Address: </B></FONT></TD> <TD width="399"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B> <?php if (isset($_POST['Service_Location_Bldg'])) { echo ($_POST['Service_Location_Bldg']); } if (isset($_POST['Service_Location_Unlisted'])) { echo ('<BR>'.$_POST['Service_Location_Unlisted']); } ?> </B></FONT></TD> </TR> <TR> <TD align="right"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Service Room Number:<BR> <IMG src="images/clearpixel.gif" alt="spacer" width="200" height="1"> </B></FONT></TD> <TD valign="top"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><?php echo ($_POST['Service_Location_Rm']); ?></B></FONT></TD> </TR> <TR bgcolor="#FFFFCC"> <TD colspan="2"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>DETAILS OF WORK: </B></FONT></TD> </TR> <TR> <TD colspan="2"><BLOCKQUOTE> <P><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><?php echo ($_POST['Customer_Description']); ?></B></FONT></P> </BLOCKQUOTE></TD> </TR> <TR> <TD colspan="2"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B><EM> Service(s) selected:</EM> </B></FONT> <BLOCKQUOTE> <FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B> <?php foreach($checkBoxes as $checkBox) { if(isset($_POST[$checkBox])) { echo "<FONT size='2' face='Verdana, Arial, Helvetica, sans-serif'><li>$checkBox</li></font>"; } } ?> </B></FONT></BLOCKQUOTE> <HR /> </TD> </TR> <TR> <TD colspan="2"><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Need Assistance? </B></FONT><FONT size="2"> <P><FONT face="Verdana, Arial, Helvetica, sans-serif"><B>Online:</B></FONT></P> </FONT> <UL> <LI><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B> Getting Started: <A href="http://www.otc.fsu.edu/GS.html" target="_blank">http://www.otc.fsu.edu/GS.html</A></B></FONT></LI> <LI><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B> Department Menu: <A href="http://www.otc.fsu.edu/Department/DeptMenu.html" target="_blank">http://www.otc.fsu.edu/Department/DeptMenu.html</A> (Look for the link to Instructions)</B></FONT></LI> <LI><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B> OTC Home: <A href="http://www.otc.fsu.edu/" target="_blank">http://www.otc.fsu.edu/</A></B></FONT></LI> </UL> <P><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>In Person: 105 Rod K. Shaw Building (On the corner of Call and Dewey) </B></FONT></P> <P><FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>By Phone: 644-HELP</B></FONT></P> <FONT size="2" face="Verdana, Arial, Helvetica, sans-serif"><B> Email: <A href="maito:Customer_Care@xxxxxxxxxxx">Customer_Care@xxxxxxxxxxx</A><BR> <BR> </B></FONT><FONT size="2"> <P><FONT face="Verdana, Arial, Helvetica, sans-serif"><B>Thank you again for the opportunity to be of service.</B></FONT></P> </FONT></TD> </TR> </TABLE> </BODY> </HTML> -----Original Message----- From: OKi98 [mailto:oki98@xxxxxxxxxx] Sent: Monday, October 15, 2007 2:06 PM To: VanBuskirk, Patricia Cc: Instruct ICC; php-db@xxxxxxxxxxxxx Subject: Re: php maximum characters in text field VanBuskirk, Patricia napsal(a): > It isn't sending to MySql, we use FileMaker Pro 9. A new record did not get made in the d'base... the confirmation email went out, but wherever info was supposed to kick back from the d'base (ie. Order number), it showed an "undefined variable" error. > > -----Original Message----- > From: Instruct ICC [mailto:instructicc@xxxxxxxxxxx] > Sent: Monday, October 15, 2007 1:05 PM > To: php-db@xxxxxxxxxxxxx > Subject: RE: php maximum characters in text field > > > >> I am starting to believe it is NOT the character length that is causing the problem. We have received other orders with more in it than that, and they came in ok. I think there may be something in the input that php does not like. I've been searching for code that will "clean up" input, possibly preg_replace? >> > > Was the order received, but the text was shorter than expected? > Or was the order not "received" at all? > > Check your mysql query log. It may show failed queries where bad characters made the query fail, perhaps using ' or "? > Use mysql_real_escape_string. > _________________________________________________________________ > Climb to the top of the charts! Play Star Shuffle: the word scramble challenge with star power. > http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_o ct > post the code (form + script that proccesses passed variables + print_r($_POST) ), it'll make the things much quicker. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php