Skip to content

Instantly share code, notes, and snippets.

View rileyrg's full-sized avatar
💭
Emacs can replace PHPStorm

RichieHH rileyrg

💭
Emacs can replace PHPStorm
15 followers · 9 following
  • Hamburg, Germany
View GitHub Profile
@rileyrg
rileyrg / PersonController.php
Created June 1, 2017 09:54
if ($request->query->has($personForm->getName())) {
$personForm->submit($request->query->get($personForm->getName()));
if ($personForm->get('reset')->isClicked()) {
$request->query->remove("person_filter");
$this->redirect($resetLink);
}
@rileyrg
rileyrg / NameFilterType.php
Created May 31, 2017 13:48
class NameFilterType extends AbstractType
{
//todo NOT USED as wont map to the person object
public function buildForm(FormBuilderInterface $builder, array $options)
{
$builder
->add('firstName', TextFilterType::class, [
@rileyrg
rileyrg / person.filter.html.twig
Created May 30, 2017 12:31
<div class="shrink30 container">
<a href="#search" data-toggle="collapse">
<h3>
{{ m.trans('filter.search') }}{% include ":fragments/glyphs:search.html.twig" %}
</h3>
</a>
<div id="search" class="row collapse">
<div class="col-xs-12">
<form method="get" action={{ filterlink }}>
{{ form_start(personForm) }}
@rileyrg
rileyrg / PersonFilterType.php
Created May 29, 2017 13:59
->add("eyeColor", EntityType::class, [
'required' => false,
'class' => 'AppBundle\Entity\EyeColor',
'placeholder' => 'Choose an eye color',
"label" => "person.eyecolour",
'query_builder' => function (EyeColourRepository $repo) {
return $repo->createAlphaEyeColours();
},
])
@rileyrg
rileyrg / PersonController.php
Created May 29, 2017 12:12
// parameters to template
return $this->render(
'person/list.html.twig',
array(
'filterlink' => $filterlink,
'personForm' => $personForm->createView(),
'pagination' => $pagination
)
);
@rileyrg
rileyrg / PersonRepository.php
Created May 25, 2017 12:50
if (sizeof($eyeColours) == 1) {
$queryBuilder->where("e.name = ?0");
} else {
/***
foreach ($eyeColours as $key => $value) {
}
***/
$queryBuilder->where($queryBuilder->expr()->orX(
@rileyrg
rileyrg / list.html.twig
Created May 23, 2017 14:39
{# @controller AppBundle:Person:list #}
{% extends 'base.html.twig' %}
{% set paginationIcon = pagination.direction == "asc" ? "fa-sort-asc" : pagination.direction == "desc" ? "fa-sort-desc" : "fa-sort" %}
{% block body %}
{{ parent() }}
{% if form is not null %}
<form method="get" action="{{ path('actors_list') }}">
{{ form_rest(form) }}
@rileyrg
rileyrg / gist:3ea11c37a13d2fc860025cad1903b5e3
Created May 9, 2017 17:50
SELECT id
FROM table_one
WHERE id NOT IN ( SELECT id FROM table_two )
@rileyrg
rileyrg / gist:2d56465c7cd5ad5bf16e7d92c25399e7
Created February 14, 2017 13:44
2017-02-14 14:31:13 139778226750016 [ERROR] Plugin 'innodb' already installed
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: The InnoDB memory heap is disabled
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: Using Linux native AIO
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: Using SSE crc32 instructions
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: Completed initialization of buffer pool
@rileyrg
rileyrg / error.log
Created February 14, 2017 13:35
2017-02-14 14:31:13 139778226750016 [ERROR] Plugin 'innodb' already installed
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: The InnoDB memory heap is disabled
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: Using Linux native AIO
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: Using SSE crc32 instructions
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-02-14 14:31:13 139778226750016 [Note] InnoDB: Completed initialization of buffer pool