1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
|
<% ' CALCUL + SCRIPT CAMEMBERT
' ci dessous mettre les valeurs brut. Le pourcentage se calcul tt seul
s1="select count(*) from commande where solde='0'"
set rs1=conntemp.execute(s1)
s2="select count(*) from commande where solde='-1'"
set rs2=conntemp.execute(s2)
s3="select count(*) from commande where solde='-2'"
set rs3=conntemp.execute(s3)
%>
<script class="code" type="text/javascript">
$(document).ready(function(){
plot2 = jQuery.jqplot('chart2',
[[['VALIDEE', <%=rs3(0)%>],['EN ATTENTE DE VALIDATION', <%=rs2(0)%> ], ['EN COURS', <%=rs1(0)%>]]],
{
title: ' ',
seriesDefaults: {
shadow: true,
renderer: jQuery.jqplot.PieRenderer,
rendererOptions: {
startAngle: 360,
sliceMargin: 4,
showDataLabels: true }
},
legend: { show:true, location: 'w' }
}
);
});
</script>
<%
' FIN CAMEMBERT
%>
<%
' DEBUT GRAPH BARRE
%>
<script class="code" type="text/javascript">
$(document).ready(function(){
var line1 = [['Pantalon', 700], ['Polo', 900], ['T-shirt', 1500],
[' Chemise homme', 300], ['Chemise femme', 198]];
var plot1 = $.jqplot('chart1', [line1], {
title: 'TOP 5 Articles',
series:[{renderer:$.jqplot.BarRenderer}],
axesDefaults: {
tickRenderer: $.jqplot.CanvasAxisTickRenderer ,
tickOptions: {
angle: -30,
fontSize: '10pt'
}
},
axes: {
xaxis: {
renderer: $.jqplot.CategoryAxisRenderer
}
}
});
});
</script>
<%
' FIN BARRE
%> |