Skip to content

Instantly share code, notes, and snippets.

View stphnwlkr's full-sized avatar

Stephen Walker stphnwlkr

View GitHub Profile
<div class="input-group input-group-lg">
<label for="cts" class="sr-only"><i class='fa fa-signal'></i> Chart Type</label>
<span class="input-group-addon sr-hidden"><i class='fa fa-signal'></i> Chart Type</span>
<select id="cts" class="form-control" >
<option value="bar">Bar</option>
<option value="hbar">Horizontal Bar</option>
<option value="pie">Pie</option>
<option value="bar3d">3D Bar</option>
<option value="hbar3d">3D Horizontal Bar</option>
</select>
<!--Retrieve the feed -->
<cffeed action="read" source="http://blogs.coldfusion.com/feed" name="feeder" query="feederq">
<!-- Output the results -->
<cfoutput query="feederq">
<h2><a href="#rsslink#">#title.ucase()#</a></h2>
#content#
<p>#publisheddate.dateFormat('long')#</p>
</cfoutput>
remote any function getClosedICount() returnformat="plain" {
var cic = queryExecute("SELECT COUNT(*) as qty
FROM dbo.View_Request WITH (nolock)
Where left(ref_num,1) ='I' AND close_date IS NOT NULL",{},{});
return NumberFormat(cic.qty,',');
}
remote any function getAverageAgeClosedI() returnformat="plain" {
var ai = queryExecute("SELECT AVG(DATEDIFF(d, CONVERT(VARCHAR(12), DATEADD(s, open_date, '19700101'), 107),
remote any function getClosedICount() {
var cic = queryExecute("SELECT COUNT(*) as qty
FROM dbo.View_Request WITH (nolock)
Where left(ref_num,1) ='I' AND close_date IS NOT NULL",{},{});
return NumberFormat(cic.qty,',');
}
remote any function getAverageAgeClosedI() {
var ai = queryExecute("SELECT AVG(DATEDIFF(d, CONVERT(VARCHAR(12), DATEADD(s, open_date, '19700101'), 107),
remote any function getAllServerInfoJSON() returnformat="JSON"    {
s = queryExecute("SELECT ResourceID, Name0 AS ServerName, operatingSystem0 AS OperatingSystem, CASE WHEN Is_Virtual_Machine0 = 1 THEN 'Virtual' ELSE 'Physical' END as isvm, Resource_Domain_OR_Workgr0 AS Domain,
(SELECT        ROUND((TotalPhysicalMemory0 / 1024.0) / 1024.0, 0) AS t
FROM            SCCM_Ext.vex_GS_X86_PC_MEMORY
WHERE        (ResourceID = v_R_System.ResourceID)) AS memory,
(SELECT        COUNT(*) AS pq
FROM            SCCM_Ext.vex_GS_PROCESSOR
WHERE        (ResourceID = v_R_System.ResourceID)) AS CPU
FROM            v_R_System
WHERE        (Is_Virtual_Machine0 IS NOT NULL)",{},{datasource='hyperv'});
@stphnwlkr
stphnwlkr / Random Image
Last active February 24, 2017 17:37
Random Image for CSS using ColdFusion
<cfoutput>
<cfscript>
imglist = 'bg4.jpg,bg3.jpg,telehealth_hero_1.jpg';
randImg=ArrayNew(1);
randImg = listtoarray(imglist,',');
bgImg=randImg[RandRange(1,ArrayLen(randImg))];
</cfscript>
<style>
.hero {
padding-top: 3rem;
public void function genDCJSON(){
/* Get the Data */
var data = queryExecute("Select deviceCode, deviceNomenclature from mybase_devicecodes_tbl",{},{});
/* Set base file path */
var strPath = expandPath('/');
function pdfprint() {
return '<a class="fasc-button fasc-size-medium fasc-type-flat ico-fa fasc-ico-before fa-file-pdf-o no-print" style="background-color: #981b1e; color: #ffffff;" href="https://[mywebsiturl]/utilities/wpPrint.cfm?ds=[datasource]&post='. get_the_ID() .'" target="_blank" data-fasc-style="background-color:#981b1e;color:#ffffff;">Save Article as PDF</a>';
}
add_shortcode('printer', 'pdfprint');
<cfoutput >
<cfparam name="url.ds" default="" maxlength="50" type="string" >
<cfparam name="url.post" default="0" type="numeric" >
<cfif not isNumeric(url.post)>
<cflocation url="/" addtoken="false">
</cfif>
<cfset p = application.utils.getWPPost(url.ds, url.post)>
<cfif p.recordcount neq 1>
<cflocation url="/" addtoken="false">
</cfif>
remote query function getWPPost(required string ds, required numeric id){
var p = queryExecute("Select post_title, post_name, post_content, post_date from wp_posts where post_status = 'publish' and
id= :id",{id={value='#arguments.id#', cfsqltype='cf_sql_int'}},{datasource = '#arguments.ds#'} );
return p;
}