~grupoesoc/cubicerp-addons/7.0

<a class="reference external" href="http://linil.wordpress.com/2008/09/16/cairoplot-11/">http://linil.wordpress.com/2008/09/16/cairoplot-11/</a></blockquote>

Charts are another important thing in reports. Geraldo is compatible with every

charting library if it has a way to render the chart as a common image format,

like JPG, PNG, GIF, etc:

<div class="highlight-python"><div class="highlight"><pre>import os

cur_dir = os.path.dirname(os.path.abspath(__file__))

import Image as PILImage

from CairoPlot import pie_plot, bar_plot

from django.contrib.auth.models import User

from reportlab.lib.pagesizes import A4

from reportlab.lib.units import cm

from reportlab.lib.enums import TA_CENTER, TA_JUSTIFY, TA_RIGHT

from reportlab.lib.colors import navy, yellow, red, white

from geraldo import Report, ReportBand, Label, ObjectValue, SystemField,\

SubReport, FIELD_ACTION_COUNT, FIELD_ACTION_AVG, FIELD_ACTION_MIN,\

FIELD_ACTION_MAX, FIELD_ACTION_SUM, FIELD_ACTION_DISTINCT_COUNT,\

BAND_WIDTH, Rect, Line, Image

def get_chart_for_user(graphic):

"""Method to get chart"""

data = [dic['id'] for dic in graphic.instance.user_permissions.values('id')]

if not data:

return None

filename = os.path.join(cur_dir, 'output/user-chart-%d.png'%graphic.instance.id)

bar_plot(filename, data, 400, 300, border = 20, grid = True, rounded_corners = True)

return PILImage.open(filename)

class UsersReport(Report):

title = 'Using chart from CairoPlot'

borders = {'all': True}

default_style = {'fontName': 'Helvetica'}

class band_summary(ReportBand):

height = 5*cm

elements = [

Label(text="Users count:", top=0.1*cm, left=0.2*cm),

ObjectValue(attribute_name='username', top=0.1*cm, left=4*cm,\

action=FIELD_ACTION_COUNT, display_format='%s permissions found'),

100

101

Label(text="Users ids average:", top=0.6*cm, left=0.2*cm),

102

ObjectValue(attribute_name='id', top=0.6*cm, left=4*cm, action=FIELD_ACTION_AVG),

103

104

Label(text="Users ids minimum:", top=1.1*cm, left=0.2*cm),

105

ObjectValue(attribute_name='id', top=1.1*cm, left=4*cm, action=FIELD_ACTION_MIN),

106

107

Label(text="Users ids maximum:", top=1.6*cm, left=0.2*cm),

108

ObjectValue(attribute_name='id', top=1.6*cm, left=4*cm, action=FIELD_ACTION_MAX),

109

110

Label(text="Users ids sum:", top=2.1*cm, left=0.2*cm),

111

ObjectValue(attribute_name='id', top=2.1*cm, left=4*cm, action=FIELD_ACTION_SUM),

112

113

Label(text="Users first name distinct:", top=2.6*cm, left=0.2*cm),

114

ObjectValue(attribute_name='first_name', top=2.6*cm, left=4*cm, action=FIELD_ACTION_DISTINCT_COUNT),

115

116

Image(filename=os.path.join(cur_dir, 'output/cairoplot.png'), left=11*cm, top=0.2*cm)

117

]

118

borders = {'top': True}

119

120

class band_page_footer(ReportBand):

121

height = 1*cm

122

elements = [

123

Label(text='Created with Geraldo Reports', top=0, left=0.5*cm),

124

SystemField(expression='Printed in %(now:%Y, %b %d)s at %(now:%H:%M)s ', top=0,

125

width=BAND_WIDTH, style={'alignment': TA_RIGHT, 'rightIndent': 0.5*cm}),

126

]

127

128

class band_detail(ReportBand):

129

height = 8.5*cm

130

force_new_page = True

131

elements = [

132

# check why BAND_WIDTH doesn't work XXX

133

Rect(width=BAND_WIDTH, height=1.6*cm, left=0, top=0, fill_color=yellow, fill=True, _test_temp=True),

134

ObjectValue(attribute_name='username', width=BAND_WIDTH, left=0.4*cm, top=0.4*cm,

135

get_value=lambda instance: instance.get_full_name().strip() or instance.username,

136

style={'fontName': 'Helvetica-Bold', 'fontSize': 16, 'textColor': navy}),

137

Image(left=0.5*cm, top=2*cm,

138

get_image=lambda graphic: PILImage.open(os.path.join(cur_dir, '%d.jpg'%graphic.instance.id))),

139

140

Label(text='First name:', top=2*cm, left=5*cm),

141

ObjectValue(attribute_name='first_name', width=BAND_WIDTH, top=2*cm, left=7*cm),

142

143

Label(text='Last name:', top=2.5*cm, left=5*cm),

144

ObjectValue(attribute_name='last_name', width=BAND_WIDTH, top=2.5*cm, left=7*cm),

145

146

Label(text='Username:', top=3*cm, left=5*cm),

147

ObjectValue(attribute_name='username', width=BAND_WIDTH, top=3*cm, left=7*cm),

148

149

Image(left=10.5*cm, top=2*cm, get_image=get_chart_for_user),

150

]

151

borders = {'bottom': True}

152

child_bands = [

153

ReportBand(

154

default_style={'textColor': white, 'fontName': 'Helvetica-Bold'},

155

height = 0.6*cm,

156

elements = [

157

Rect(left=0, top=0, width=BAND_WIDTH, height=0.6*cm,

158

fill_color=navy, fill=True, _test_temp=True),

159

Label(text="ID", top=0.1*cm, left=0.5*cm),

160

Label(text="Permission", top=0.1*cm, left=4*cm),

161

],

162

borders={'bottom': True}),

163

]

164

165

subreports = [

166

SubReport(

167

queryset_string = '%(object)s.user_permissions.all()',

168

band_detail = ReportBand(

169

default_style={'fontName': 'Helvetica'},

170

height=0.5*cm,

171

elements=[

172

ObjectValue(attribute_name='id', top=0, left=0.5*cm),

173

ObjectValue(attribute_name='name', top=0, left=4*cm),

174

],

175

borders={'bottom': True},

176

),

177

),

178

]

179

</pre></div>

180

</div>

181

Instantiating the report...

182

<div class="highlight-python"><div class="highlight"><pre>>>> queryset = User.objects.all().order_by('-id')

183

>>> report = UsersReport(queryset=queryset)

184

>>> from geraldo.generators import PDFGenerator

185

</pre></div>

186

</div>

187

Building the chart

188

<div class="highlight-python"><div class="highlight"><pre>>>> data = dict([(user['username'], user['id']) for user in report.queryset.values('id', 'username')])

189

>>> pie_plot(os.path.join(cur_dir, 'output/cairoplot.png'), data, 350, 200)

190

</pre></div>

191

</div>

192

PDF generation

193

<div class="highlight-python"><div class="highlight"><pre>>>> report.generate_by(PDFGenerator, filename=os.path.join(cur_dir, 'output/charts-cairoplot-report.pdf'))

194

</pre></div>

195

</div>

196

The Result

197

198

<li><a class="reference external" href="http://geraldo.svn.sourceforge.net/viewvc/geraldo/examples/charts-cairoplot-report.pdf">http://geraldo.svn.sourceforge.net/viewvc/geraldo/examples/charts-cairoplot-report.pdf</a></li>

199

</ul>

200

</div>

201

202

203

</div>

204

</div>

205

</div>

206

207

208

<h4>Previous topic</h4>

209

<a href="composition.html"

210

title="previous chapter">Composition</a>

211

<h4>Next topic</h4>

212

<a href="matplotlib.html"

213

title="next chapter">Charts with MatPlotLib</a>

214

215

216

<li><a href="../_sources/examples/cairoplot.txt"

217

rel="nofollow">Show Source</a></li>

218

</ul>

219

220

<h3>Quick search</h3>

221

222

223

224

225

226

</form>

227

228

Enter search terms or a module, class or function name.

229

230

</div>

231

232

</div>

233

</div>

234

235

</div>

236

237

<h3>Navigation</h3>

238

<ul>

239

240

<a href="../genindex.html" title="General Index"

241

>index</a></li>

242

243

<a href="matplotlib.html" title="Charts with MatPlotLib"

244

>next</a> |</li>

245

246

<a href="composition.html" title="Composition"

247

>previous</a> |</li>

248

<li><a href="../index.html">Geraldo Reports Documentation v0.4-alpha-5 documentation</a> »</li>

249

<li><a href="index.html" >Examples</a> »</li>

250

</ul>

251

</div>

252

253

254

Created using <a href="http://sphinx.pocoo.org/">Sphinx</a> 0.6.3.

255

</div>

256

</body>

257

</html>

b'\\ No newline at end of file'

Older »