Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <cfparam name="Prospect_ID" default="0">
- <cfquery name="getProspect" datasource="#application.dsn#">
- SELECT *
- FROM Prospects
- WHERE Prospect_ID = <cfqueryparam value="#attributes.Prospect_id#" cfsqltype="CF_SQL_INTEGER">
- </cfquery>
- <cfquery name="getProspectContacts" datasource="#application.dsn#">
- SELECT PC.*
- FROM Prospects P INNER JOIN Prospect_Contacts PC ON P.Prospect_ID = PC.Prospect_ID
- WHERE P.Prospect_ID = <cfqueryparam value="#attributes.Prospect_id#" cfsqltype="CF_SQL_INTEGER">
- </cfquery>
- <cfquery name="getProdCats" datasource="#application.dsn#">
- SELECT Cat_ID AS Option_Value, Cat_Name AS Option_Text
- FROM Exhib_ProdCats
- WHERE Event_ID = <cfqueryparam value="#attributes.Event_id#" cfsqltype="CF_SQL_INTEGER">
- ORDER BY Cat_Name
- </cfquery>
- <cfquery name="getProspectProdCats" datasource="#application.dsn#">
- SELECT *
- FROM XR_Prospect_Cats
- WHERE Prospect_ID = <cfqueryparam value="#attributes.Prospect_id#" cfsqltype="CF_SQL_INTEGER">
- </cfquery>
- <cfquery name="getEvents" datasource="#application.dsn#">
- SELECT Event_ID AS Option_Value, Event_Name AS Option_Text
- FROM Events
- WHERE Status <> <cfqueryparam value="Deleted" cfsqltype="CF_SQL_VARCHAR">
- </cfquery>
- <cfscript>
- getProspectTypes = app.options("Prospect_Types");
- getProspectContactTypes = app.options("Prospect_Contact_Types");
- getProspectSalesStages = app.options("Prospect_Sales_Stages");
- getSponsorTypes = app.options("Sponsor_Types");
- getStates = app.options("State");
- forms.setValidation(name="page_name",prompt="Page Name",type="text");
- forms.setValidation(name="page_title",prompt="Page Title",type="text");
- </cfscript>
- <cfoutput>
- <script language="JavaScript" type="text/javascript">
- $(document).ready(function(){
- $(".prospectForm").colorbox();
- $('##modDiv').hide();
- $('##mod-toggle').click(function() {
- $('##modDiv').slideToggle('slow');
- return false;
- });
- });
- </script>
- <cfimport prefix="controls" taglib="/Common/customtags" />
- <style type="text/css">
- h3 { margin: 2em 0 0 0; }
- </style>
- <link href="docs/css/selectSwap.css" rel="stylesheet" type="text/css" />
- <style>
- div.SelectSwap_horizontal div.Selector select {
- /* change this to adjust selection box width */
- width: 22em;
- height: 30em;
- }
- </style>
- #forms.getValidation()#
- <table cellpadding="5" cellspacing="0" border="0" width="100%">
- <tr><td class="form_title">#getProspect.Company#</td></tr>
- <form action="#app.enc('index.cfm?fuseaction=exhib.ProspectEditAction')#" method="post">
- <tr>
- <td>
- <table cellpadding="4" cellspacing="0" width="100%" style="border: 1px solid black">
- <tr><td class="result_item" colspan="2"><strong>Prospect Info</strong></td></tr>
- <tr>
- <td width="50%" class="result_item" valign="top">
- <table width="100%" border="0" cellspacing="0" cellpadding="4">
- <tr>
- <td class="result_item" valign="top" width="25%">*Company:</td>
- <td class="result_item" width="75%">
- #forms.text(name="Company",value=getProspect.company,size=50,maxlength=255,class="text")#
- </td>
- </tr>
- <tr>
- <td class="result_item" valign="top" width="25%">Address:</td>
- <td class="result_item" width="75%">
- #forms.text(name="Address",value=getProspect.Address,size=50,maxlength=255,class="text")#
- </td>
- </tr>
- <tr>
- <td class="result_item" valign="top" width="25%">Address Cont.:</td>
- <td class="result_item" width="75%">
- #forms.text(name="Address2",value=getProspect.Address2,size=50,maxlength=255,class="text")#
- </td>
- </tr>
- <tr>
- <td class="result_item" valign="top" width="25%">City:</td>
- <td class="result_item" width="75%">
- #forms.text(name="City",value=getProspect.City,size=50,maxlength=255,class="text")#
- </td>
- </tr>
- <tr>
- <td class="result_item" valign="top" width="25%">State:</td>
- <td class="result_item" width="75%">
- #forms.select(name="State",value="#getProspect.State#",query=getStates,null_prompt="Select...",null_value="")#
- </td>
- </tr>
- <tr>
- <td class="result_item" valign="top" width="25%">Zip:</td>
- <td class="result_item" width="75%">
- #forms.text(name="Zip",value=getProspect.Zip,size=50,maxlength=12,class="text")#
- </td>
- </tr>
- <tr>
- <td class="result_item" valign="top" width="25%">Main Phone:</td>
- <td class="result_item" width="75%">
- #forms.text(name="Phone",value=getProspect.Phone,size=50,maxlength=50,class="text")#
- </td>
- </tr>
- <tr>
- <td class="result_item" valign="top" width="25%">Website:</td>
- <td class="result_item" width="75%">
- #forms.text(name="Web_URL",value=getProspect.Web_URL,size=50,maxlength=255,class="text")#
- </td>
- </tr>
- <tr>
- <td class="result_item" valign="top" width="25%">Priority Points:</td>
- <td class="result_item" width="75%">
- #forms.text(name="Priority_Points",value=getProspect.Priority_Points,size=50,maxlength=255,class="text")#
- </td>
- </tr>
- <tr>
- <td class="result_item" valign="top" width="25%">Years Exhibited:</td>
- <td class="result_item" width="75%">
- <select name="Years_Exhibited" id="Years_Exhibited" size="6" multiple style="width: 320px;">
- <cfloop query="getEvents">
- <option value="#option_value#"<cfif listContains(getProspect.Years_Exhibited, option_value)> selected</cfif>>#Option_Text#</option>
- </cfloop>
- </select>
- </td>
- </tr>
- </table>
- </td>
- <td width="50%" class="result_item" valign="top">
- <table width="100%" border="0" cellspacing="0" cellpadding="4">
- <tr>
- <td class="result_item" valign="top" width="25%">*Prospect Type:</td>
- <td class="result_item" width="75%">
- #forms.select(name="Prospect_Type",value="#getProspect.Prospect_Type#",query=getProspectTypes,null_prompt="Select...",null_value="",class="required")#
- </td>
- </tr>
- <tr>
- <td class="result_item" valign="top" colspan="2">Product Categories:</td>
- </tr>
- <tr>
- <td class="result_item" colspan="2">
- <controls:selectSwap selectlimit="50" id="Product_Categories" querySource="#getProdCats#" listSelected="#valueList(getProspectProdCats.Cat_ID)#" DisplayMode="horizontal" ValueField="Option_Value" DisplayField="Option_Text" SourceHeader="Available Product Categories" SelectedHeader="Selected Product Categories"/>
- </td>
- </tr>
- <tr>
- <td class="result_item" valign="top" width="25%">Sponsor Type:</td>
- <td class="result_item" width="75%">
- <select name="Sponsor_Type" id="Sponsor_Type" size="6" multiple style="width: 320px;">
- <cfloop query="getSponsorTypes">
- <option value="#option_value#"<cfif listContains(getProspect.Sponsor_Type, option_value)> selected</cfif>>#Option_Text#</option>
- </cfloop>
- </select>
- </td>
- </tr>
- <tr>
- <td class="result_item" valign="top" width="25%">Sales Stage:</td>
- <td class="result_item" width="75%">
- #forms.select(name="Sales_Stage",value="#getProspect.Sales_Stage#",query=getProspectSalesStages,null_prompt="Select...",null_value="")#
- </td>
- </tr>
- </table>
- </td>
- </tr>
- </tr>
- </table>
- <table cellpadding="0" cellspacing="0" width="100%">
- <tr><td colspan="2"> </td></tr>
- </table>
- <table cellpadding="0" cellspacing="0" width="100%" style="border: 1px solid black">
- <tr>
- <td colspan="2" class="result_item" style="padding: 4px;"><strong>Contacts</strong></td>
- </tr>
- <tr>
- <td colspan="2">
- <div id="result" style="width: 100%;<!--- border: 1px solid red; --->">
- <cfinclude template="/docs/divs/div_prospectContacts.cfm">
- </div>
- <div id="addForm" data-action="/docs/divs/div_prospectContacts.cfm">
- <!--- <div id="searchform" data-action="/search.cfm"> --->
- <!--- <input type="text" id="s" placeholder="Search..."> --->
- <table width="100%" border="0" cellspacing="0" cellpadding="4">
- <tr>
- <input type="hidden" id="prospect_id" value="#attributes.prospect_id#">
- <td valign="top" width="17%"><input type="text" id="first_name" value="" size="25" maxlength="100" class="small"></td>
- <td valign="top" width="17%"><input type="text" id="last_name" value="" size="25" maxlength="100" class="small"></td>
- <td valign="top" width="17%"><input type="text" id="title" value="" size="25" maxlength="100" class="small"></td>
- <td valign="top" width="17%"><input type="text" id="phone" value="" size="25" maxlength="100" class="small"></td>
- <td valign="top" width="17%"><input type="text" id="email" value="" size="25" maxlength="100" class="small"></td>
- <cfif getProspectContactTypes.recordcount GT 1>
- <td valign="top" width="17%">
- <select id="prospect_contact_type" class="required" class="small" style="margin-top: -10px;">
- <option value="" Selected>Select...</option>
- <cfloop query="getProspectContactTypes">
- <option value="#getProspectContactTypes.option_value#">#getProspectContactTypes.option_text#</option>
- </cfloop>
- </select>
- </td>
- <cfelse>
- <td valign="top" width="17%"> </td>
- <input type="hidden" id="prospect_contact_type_edit" value="#getProspectContactTypes.Option_value#">
- </cfif>
- <td valign="top">
- <!--- <input type="submit" name="contactAdd" value="Add" style="height: 22px; vertical-align: bottom; padding: 0px;"> --->
- <button type="button" id="contactAdd" style="height: 22px; vertical-align: bottom; padding: 0px;">Add</button>
- <!--- <button type="button" id="search-button">Search</button> --->
- </td>
- </tr>
- </table>
- </div>
- <script>
- $(document).ready(function(){
- // Attach a submit handler to the form
- //$( "##contactAdd" ).click(function( event ) {
- $("##contactAdd").on("click", function( event ) {
- var url = $("##addForm").data("action");
- var posting = $.post( url, {
- prospect_id: $("##prospect_id").val(),
- first_name: $("##first_name").val(),
- last_name: $("##last_name").val(),
- title: $("##title").val(),
- phone: $("##phone").val(),
- email: $("##email").val(),
- prospect_contact_type: $("##prospect_contact_type").val()
- }
- );
- document.getElementById('first_name').value = '';
- document.getElementById('last_name').value = '';
- document.getElementById('title').value = '';
- document.getElementById('phone').value = '';
- document.getElementById('email').value = '';
- document.getElementById('prospect_contact_type').selectedIndex = 0;
- posting.done(function( data ) {
- var content = $( data ).filter( "##content" );
- $( "##result" ).empty().append( content.html() );
- });
- });
- });
- </script>
- </td>
- </tr>
- </table>
- </td>
- </tr>
- </form>
- </table>
- </cfoutput>
- <!--- div_prospectContacts.cfm --->
- <cfsetting enablecfoutputonly="No" showdebugoutput="No">
- <div id="content">
- <cfdump var="#url#">
- <cfdump var="#form#">
- <cfparam name="attributes.prospect_id" default="0">
- <!--- Delete called --->
- <cfif isDefined('url.del')>
- <cfset attributes.prospect_id = url.prospect_id>
- <cfquery name="delProspectContact" datasource="#application.dsn#">
- DELETE FROM Prospect_Contacts
- WHERE Contact_ID = <cfqueryparam value="#form.contact_id#" cfsqltype="CF_SQL_INTEGER">
- </cfquery>
- </cfif>
- <!--- Edit called --->
- <cfif isDefined('form.contact_id') AND NOT isDefined('url.del')>
- <cfset attributes.editID = form.contact_id>
- <cfset attributes.edit = 1>
- <cfset attributes.prospect_id = url.prospect_id>
- <cfelse>
- <cfset attributes.edit = 0>
- </cfif>
- <cfif isDefined('form.prospect_id')>
- <cfset attributes.prospect_id = form.prospect_id>
- <cfquery name="addProspectContact" datasource="#application.dsn#">
- INSERT INTO Prospect_Contacts (Prospect_ID, First_Name, Last_Name, Title, Phone, Email, Contact_Type)
- VALUES (<cfqueryparam value="#form.Prospect_ID#" cfsqltype="CF_SQL_INTEGER">,
- <cfqueryparam value="#form.first_name#" cfsqltype="CF_SQL_VARCHAR">,
- <cfqueryparam value="#form.last_name#" cfsqltype="CF_SQL_VARCHAR">,
- <cfqueryparam value="#form.title#" cfsqltype="CF_SQL_VARCHAR">,
- <cfqueryparam value="#form.phone#" cfsqltype="CF_SQL_VARCHAR">,
- <cfqueryparam value="#form.email#" cfsqltype="CF_SQL_VARCHAR">,
- <cfqueryparam value="#form.first_name#" cfsqltype="CF_SQL_VARCHAR">)
- </cfquery>
- </cfif>
- <cfquery name="getProspectContacts" datasource="#application.dsn#">
- SELECT PC.*
- FROM Prospects P INNER JOIN Prospect_Contacts PC ON P.Prospect_ID = PC.Prospect_ID
- WHERE P.Prospect_ID = <cfqueryparam value="#attributes.Prospect_id#" cfsqltype="CF_SQL_INTEGER">
- </cfquery>
- <cfscript>
- getProspectContactTypes = app.options("Prospect_Contact_Types");
- </cfscript>
- <cfoutput>
- <table width="100%" border="0" cellspacing="0" cellpadding="4">
- <tr>
- <td class="result_item" valign="top" width="17%">First Name</td>
- <td class="result_item" valign="top" width="17%">Last Name</td>
- <td class="result_item" valign="top" width="17%">Title</td>
- <td class="result_item" valign="top" width="17%">Phone</td>
- <td class="result_item" valign="top" width="17%">Email</td>
- <td class="result_item" valign="top" width="17%">Contact Type</td>
- <td class="result_item"> </td>
- </tr>
- <cfloop query="getProspectContacts">
- <div id="grid#currentrow#" data-action="/docs/divs/div_prospectContacts.cfm?prospect_id=#attributes.prospect_id#">
- <input type="hidden" id="contact_id#currentrow#" value="#getProspectContacts.contact_id#">
- <!--- <input type="hidden" id="delcontact_id#currentrow#" value="#getProspectContacts.contact_id#"> --->
- </div>
- <div id="delgrid#currentrow#" data-action="/docs/divs/div_prospectContacts.cfm?prospect_id=#attributes.prospect_id#&del=1">
- <input type="hidden" id="contact_id#currentrow#" value="#getProspectContacts.contact_id#">
- </div>
- <cfif attributes.edit EQ 1 AND attributes.editID EQ getProspectContacts.contact_id>
- <tr class="<cfif currentrow MOD 2 EQ 0>grid_row<cfelse>grid_row_alt</cfif>">
- <td valign="top" colspan="7">
- <div id="editGrid" data-action="/docs/divs/div_prospectContacts.cfm?prospect_id=#attributes.prospect_id#">
- <table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr>
- <td valign="top" width="17%"><input type="text" id="first_name" value="#getProspectContacts.First_Name#" size="25" maxlength="100" class="small"></td>
- <td valign="top" width="17%"><input type="text" id="last_name" value="#getProspectContacts.Last_Name#" size="25" maxlength="100" class="small"></td>
- <td valign="top" width="17%"><input type="text" id="title" value="#getProspectContacts.Title#" size="25" maxlength="100" class="small"></td>
- <td valign="top" width="17%"><input type="text" id="phone" value="#getProspectContacts.Phone#" size="25" maxlength="100" class="small"></td>
- <td valign="top" width="17%"><input type="text" id="email" value="#getProspectContacts.Email#" size="25" maxlength="100" class="small"></td>
- <cfif getProspectContactTypes.recordcount GT 1>
- <td valign="top" width="17%">
- <select id="prospect_contact_type" class="required" class="small" style="margin-top: -10px;">
- <cfloop query="getProspectContactTypes">
- <option value="#getProspectContactTypes.option_value#"<cfif getProspectContacts.Contact_Type EQ getProspectContactTypes.option_value> selected</cfif>>#getProspectContactTypes.option_text#</option>
- </cfloop>
- </select>
- </td>
- <cfelse>
- <td valign="top" width="17%"> </td>
- <input type="hidden" id="prospect_contact_type" value="#getProspectContacts.Contact_Type#">
- </cfif>
- <td valign="top">
- <button type="button" id="contactEdit" style="height: 22px; vertical-align: bottom; padding: 0px;">Edit</button>
- <!--- <button type="button" id="search-button">Search</button> --->
- </td>
- </tr>
- </table>
- </div>
- </td>
- </tr>
- <script>
- $(document).ready(function(){
- // Attach a submit handler to the edit form when in edit mode
- //$( "##contactEdit" ).click(function( event ) {
- $('##contactEdit').on("click", function( event ) {
- alert('EDIT'); return false;
- var url = $("##editGrid").data("action");
- var posting = $.post( url, {
- first_name: $("##first_name").val(),
- last_name: $("##last_name").val(),
- title: $("##title").val(),
- phone: $("##phone").val(),
- email: $("##email").val(),
- prospect_contact_type: $("##prospect_contact_type").val()
- }
- );
- posting.done(function( data ) {
- var content = $( data ).filter( "##content" );
- $( "##result" ).empty().append( content.html() );
- });
- });
- });
- </script>
- <cfelse>
- <tr class="<cfif currentrow MOD 2 EQ 0>grid_row<cfelse>grid_row_alt</cfif>">
- <td valign="top" width="17%">#getProspectContacts.First_Name#</td>
- <td class="<cfif currentrow MOD 2 EQ 0>grid_row<cfelse>grid_row_alt</cfif>" valign="top" width="17%">#getProspectContacts.Last_Name#</td>
- <td valign="top" width="17%">#getProspectContacts.Title#</td>
- <td valign="top" width="17%">#getProspectContacts.Phone#</td>
- <td valign="top" width="17%">#getProspectContacts.Email#</td>
- <td valign="top" width="17%">#getProspectContacts.Contact_Type#</td>
- <td nowrap>
- <img src="/common/images/menu/edit.png" alt="Edit" id="editContact#currentrow#" border="0" style="cursor: pointer;">
- <img src="/common/images/menu/delete.png" alt="Delete" id="delContact#currentrow#" border="0" style="cursor: pointer;">
- </td>
- </tr>
- </cfif>
- <script>
- $(document).ready(function(){
- // Edit handler
- // $( "##editContact#currentrow#" ).click(function( event ) {
- $("##editContact#currentrow#").on("click", function( event ) {
- //$('##editContact').on('click', function( event ) {
- var url = $("##grid#currentrow#").data("action");
- var posting = $.post( url, {
- contact_id: $("##contact_id#currentrow#").val()//,
- }
- );
- posting.done(function( data ) {
- var content = $( data ).filter( "##content" );
- $( "##result" ).empty().append( content.html() );
- });
- });
- // Delete handler
- //$( "##delContact#currentrow#" ).click(function( event ) {
- $("##delContact#currentrow#").on("click", function( event ) {
- confirm('Are you sure you want to delete this contact?');
- var url = $("##delgrid#currentrow#").data("action");
- var posting = $.post( url, {
- contact_id: $("##contact_id#currentrow#").val()
- }
- );
- posting.done(function( data ) {
- var content = $( data ).filter( "##content" );
- $( "##result" ).empty().append( content.html() );
- });
- });
- });
- </script>
- </cfloop>
- </table>
- </cfoutput>
- </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement