Skip to content

Instantly share code, notes, and snippets.

GautierMichelin gautiermichelin

View GitHub Profile
View item_request.json
{
"intrinsic_fields" : {
"idno" : "TEST-123",
"type_id" : 43
},
"preferred_labels" : [
{
"locale" : "en_US",
"forename" : "Walter",
"middlename" : "H.",
View gist:c5634a65334248788035
$vs_buf .="Ajouter une nouvelle <select name='type_id' id='caAddObjectToLotForm_type_id'>
<option value='4'>&nbsp;&nbsp;&nbsp; Mesure</option>
</select> à la session";
@gautiermichelin
gautiermichelin / detection-images-being-processed.php
Created Apr 16, 2015
CollectiveAccess : detection & reprocessing of media not treated by queue (either for access permission or format error)
View detection-images-being-processed.php
<?php
require_once('setup.php');
require_once('app/models/ca_object_representations.php');
require_once('app/lib/core/Db.php');
$o_data = new Db();
$qr_reps = $o_data->query("
SELECT *
FROM ca_object_representations
@gautiermichelin
gautiermichelin / md-toc.rb
Created Jul 7, 2015 — forked from JenniferMack/md-toc.rb
Traduction en français
View md-toc.rb
#!/usr/bin/env ruby
toc = "# Sommaire\n"
newmd = ""
ARGF.each_line do |line|
newmd << line
next if !line.start_with?("#")
heading = line.gsub("#", "").strip
@gautiermichelin
gautiermichelin / elissa.sql
Created Jul 31, 2015
E-lissa (decalog) simple db structure extraction
View elissa.sql
SELECT notices.Titre,
sup1.ISBN,
sup1.Qualif_ISBN,
stitre.Sous_Titre,
para.Titre_Para,
t_forme.Titre_Forme,
t_uni.Titre_Uniforme,
langue.Lib_Langue,
langue.Code_Langue,
langue_originale.Lib_Langue AS Lib_Langue_Originale,
@gautiermichelin
gautiermichelin / objects_list_items.sql
Created Aug 14, 2015
CollectiveAccess SQL request : used list items inside object records
View objects_list_items.sql
SELECT ca_list_labels.list_id,
ca_list_labels.`name`,
ca_attribute_values.item_id,
ca_list_item_labels.name_singular,
group_concat(distinct ca_attributes.row_id) as objets
FROM ca_list_labels LEFT OUTER JOIN ca_lists ON ca_list_labels.list_id = ca_lists.list_id
LEFT OUTER JOIN ca_list_items ON ca_lists.list_id = ca_list_items.list_id
LEFT OUTER JOIN ca_attribute_values ON ca_list_items.item_id = ca_attribute_values.item_id
LEFT OUTER JOIN ca_list_item_labels ON ca_list_item_labels.item_id = ca_attribute_values.item_id
LEFT OUTER JOIN ca_attributes ON ca_attribute_values.attribute_id = ca_attributes.attribute_id
View keybase.md

Keybase proof

I hereby claim:

  • I am gautiermichelin on github.
  • I am gautiermichelin (https://keybase.io/gautiermichelin) on keybase.
  • I have a public key whose fingerprint is E7FD B88C 31D2 1C45 8096 71FF E663 1B33 C92C 9963

To claim this, I am signing this object:

View PafiExternalDB.php
<?php
/** ---------------------------------------------------------------------
* app/lib/core/Auth/Adapters/PafiExternalDB.php : External database authentication backend using Joomla for CollectiveAccess
* ----------------------------------------------------------------------
* CollectiveAccess
* Open-source collections management software
* ----------------------------------------------------------------------
*
* Software by Whirl-i-Gig (http://www.whirl-i-gig.com)
* Copyright 2014 Whirl-i-Gig
View PafiPlatformExternalDB.php
<?php
/** ---------------------------------------------------------------------
* app/lib/core/Auth/Adapters/PafiPlatformExternalDB.php : External database authentication backend using Joomla for CollectiveAccess
* ----------------------------------------------------------------------
* CollectiveAccess
* Open-source collections management software
* ----------------------------------------------------------------------
*
* Software by Whirl-i-Gig (http://www.whirl-i-gig.com)
* Copyright 2014 Whirl-i-Gig
@gautiermichelin
gautiermichelin / toc.js
Created Jan 4, 2016
TOC jquery for CDN execution
View toc.js
/*!
* toc - jQuery Table of Contents Plugin
* v0.3.2
* http://projects.jga.me/toc/
* copyright Greg Allen 2014
* MIT License
*/
/*!
* smooth-scroller - Javascript lib to handle smooth scrolling
* v0.1.2
You can’t perform that action at this time.