Stephen Walker stphnwlkr
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| component { | |
| url.returnformat="json"; | |
| remote function getEvents(any start, any end) { | |
| var realStart = epochTimeToDate(start); | |
| var realEnd = epochTimeToDate(end); | |
| writelog(file="application", text="Asked for #realstart# to #realend#, orig start=#start#"); | |
| var q = new com.adobe.coldfusion.query(); | |
| q.setDatasource("blogdev"); |
stphnwlkr
/ fullCalendar Script
Created
September 10, 2013 00:31
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <script> | |
| $(document).ready(function() { | |
| $("#cal").fullCalendar({ | |
| //Formating | |
| header: { | |
| right: 'prev,next today', | |
| left: 'title', | |
| center: 'month,agendaWeek,agendaDay' | |
| }, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <div id="map_canvas" style="width: 100%; height: 350px;"></div> | |
| <script src="https://maps.googleapis.com/maps/api/js?key=your_api_key_goes_here&sensor=false&callback=initialize"></script> | |
| <script> | |
| function initialize() { var mapOptions = { center: new google.maps.LatLng(#pd.lat#, #pd.lon#), zoom: 14, mapTypeId: google.maps.MapTypeId.ROADMAP }; var map = new google.maps.Map(document.getElementById("map_canvas"), mapOptions); }> | |
| </script> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "graphset":[ | |
| { | |
| "background-color":"#ffffff", | |
| "background-color-2":"#ffffff", | |
| "tooltip":{"visible":true, "color":"#101010"}, | |
| "scale-y":{"zooming":true}, | |
| "scale-x":{"format":"%v", | |
| "zooming":true, | |
| "max-labels":18, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"graphset":[ | |
| { | |
| animate-type":"always" | |
| "background-color":"#ffffff", | |
| "background-color-2":"#ffffff", | |
| "tooltip":{ | |
| "visible":true, | |
| "thousands-separator":"," | |
| ,"color":"#101010" | |
| }, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <cfoutput query="list1" group="groupname"> | |
| <tr> | |
| <cfset rowcount = 0> | |
| <th> | |
| #groupname# | |
| </th> | |
| <th></th></tr></thead> | |
| <tbody><cfoutput > | |
| <tr> | |
| <cfset rowcount = rowcount+1> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <cffunction name="getMfgCount" returntype="Numeric"> | |
| <cfset var mfgc = ''> | |
| <cfquery name="mfgc"> | |
| Select Count(*) as qty | |
| From mydata_table | |
| </cfquery> | |
| <cfreturn mfgc.qty > | |
| </cffunction> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <div class="col-xs-4"> | |
| <a href="##"> | |
| <div class="info-tiles tiles-midnightblue"> | |
| <div class="tiles-heading"> | |
| <div class="pull-left">Number of Manufacturers</div> | |
| </div> | |
| <div class="tiles-body"> | |
| <div class="pull-left"> <i class="gl gl-building"></i> </div> | |
| <!--- Retrieve Count from Function ---> | |
| <div class="pull-right">#NumberFormat(application.demo.getMfgCount(),",")#</div> |
stphnwlkr
/ ReturnStruct
Last active
August 29, 2015 14:01
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| public struct function getCompanyDetails(required string cc){ | |
| var cd = queryExecute("Select mfgCode,name,nameAlt,street,address2,city,state,county,postalCode, | |
| country,phone,phoneTollFree,fax,url,corpEmail,manufacturer,distributor,calibrates_test_eq,specialist, | |
| reconditioner,last_verified,servicer,exporter,importer,leases | |
| From mfgDetails_tbl | |
| Where mfgCode = :ccp",{ | |
| ccp={value="#cc#", cfsqltype="CF_SQL_VARCHAR", maxlength=6} | |
| } | |
| ); |
stphnwlkr
/ Query with Subquery
Last active
August 29, 2015 14:01
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| public query function getEqMfg(required string dc){ | |
| var ml = queryExecute("Select name, mfgCode, country | |
| From mfgdetails_tbl | |
| Where mfgcode in ( | |
| Select mfgCode | |
| From mfg2devices_tbl | |
| Where deviceCode = :dcp | |
| ) | |
| Order By country, name", |