Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <CFELSEif i EQ x>
- <CFQUERY NAME="GrabData" datasource="admi-prod">
- sql
- </CFQUERY>
- <cfset gwidth = 450>
- <cfset gheight = 320>
- <cfset min = int(arrayMin(grabData["closing_inventory_total"])) - 1>
- <cfif int(arrayMin(grabData["idle_capital_total"])) LT min>
- <cfset min = int(arrayMin(grabData["idle_capital_total"])) - 1>
- </cfif>
- <cfset max = ceiling(arrayMax(grabData["closing_inventory_total"])) + 1>
- <cfchart name="graph_#dealer_id#_#graphNum#" scalefrom="#min#" scaleto="#max#" title="Total Closing Inventory & Total Idle Capital" format="jpg" chartheight="#gheight#" chartwidth="#gwidth#">
- <cfchartseries type="line" query="grabData" valuecolumn="closing_inventory_total" itemcolumn="xlabel"/>
- <cfchartseries type="line" query="grabData" valuecolumn="idle_capital_total" itemcolumn="xlabel"/>
- </cfchart>
- </CFIF>
- <cfcontent type="image/jpeg" variable="#evaluate("graph_#dealer_id#_#graphNum#")#">
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement