SonataAdminBundle with charts and statistics blocks
Here's a quick overview of how we built the chart blocks for the [Hilenium] (http://hilenium.com) admin backend dashboard.
Requirements
| <?php | |
| namespace Acme\DemoBundle\Admin; | |
| use Sonata\AdminBundle\Admin\Admin; | |
| class FooAdmin extends Admin | |
| { | |
| public function getTemplate($name) | |
| { |
| <?php | |
| namespace Liip\AcmeBundle\Filter; | |
| use Sonata\AdminBundle\Form\Type\Filter\ChoiceType; | |
| use Sonata\AdminBundle\Datagrid\ProxyQueryInterface; | |
| use Sonata\DoctrineORMAdminBundle\Filter\StringFilter; | |
| class CaseInsensitiveStringFilter extends StringFilter | |
| { |
| /** | |
| * I converted the SCSS mixin to LESS for the awesome coders like myself in response to a blog post on 37Signals - http://37signals.com/svn/posts/3271-easy-retina-ready-images-using-scss | |
| * | |
| * Update: 2014-08-04 - Updated a long-standing bug where retina images were shown no matter what in the first background-image property. | |
| * - Updated retina media query to be more reliable () | |
| * Update: 2013-11-13 - Picked up another technique thanks to reading this post from Tyler Tate, auto-fill in the second filename for the retina image, http://tylertate.com/blog/2013/06/11/retina-images-using-media-queries-and-LESS-CSS.html | |
| * Update: 2013-04-16 - Have recently found a few use cases when using a retina pattern from Subtle Patterns on the <body>, this has come in handy | |
| * Update: 2013-04-05 - Some research in the Wordpress Core(http://core.trac.wordpress.org/ticket/22238#comment:5) was pointed out that some tests may be redundant (Thanks @kbav) so I've cleaned these up | |
| * Update: 2012-12-29 - U |
| # dump all databases once every 24 hours | |
| 45 4 * * * root nice -n 19 su - postgres -c "pg_dumpall --clean" | gzip -9 > /var/local/backup/postgres/postgres_all.sql.gz | |
| # vacuum all databases every night (full vacuum on Sunday night, lazy vacuum every other night) | |
| 45 3 * * 0 root nice -n 19 su - postgres -c "vacuumdb --all --full --analyze" | |
| 45 3 * * 1-6 root nice -n 19 su - postgres -c "vacuumdb --all --analyze --quiet" | |
| # re-index all databases once a week | |
| 0 3 * * 0 root nice -n 19 su - postgres -c 'psql -t -c "select datname from pg_database order by datname;" | xargs -n 1 -I"{}" -- psql -U postgres {} -c "reindex database {};"' |
