spip / SPIP

ecrire/req/sqlite_fonctions.php

Indentation +229 added lines, -229 removed lines

@@ -17,7 +17,7 @@ 
  */
  
 if (!defined('_ECRIRE_INC_VERSION')) {
-	return;
+    return;
 }
 
 /**
@@ -38,93 +38,93 @@ 
  */
 function _sqlite_init_functions(&$sqlite) {
 
-	if (!$sqlite) {
-		return false;
-	}
+    if (!$sqlite) {
+        return false;
+    }
 
 
-	$fonctions = array(
-		// A
-		'ACOS'  => array('acos', 1),
-		'ASIN'  => array('asin', 1),
-		'ATAN'  => array('atan', 1), // mysql accepte 2 params comme atan2… hum ?
-		'ATAN2' => array('atan2', 2),
+    $fonctions = array(
+        // A
+        'ACOS'  => array('acos', 1),
+        'ASIN'  => array('asin', 1),
+        'ATAN'  => array('atan', 1), // mysql accepte 2 params comme atan2… hum ?
+        'ATAN2' => array('atan2', 2),
 
-		// C
-		'CEIL'   => array('_sqlite_func_ceil', 1),
-		'CONCAT' => array('_sqlite_func_concat', -1),
-		'COS'    => array('cos', 1),
+        // C
+        'CEIL'   => array('_sqlite_func_ceil', 1),
+        'CONCAT' => array('_sqlite_func_concat', -1),
+        'COS'    => array('cos', 1),
 
-		// D
-		'DATE_FORMAT' => array('_sqlite_func_strftime', 2),
-		'DAYOFMONTH'  => array('_sqlite_func_dayofmonth', 1),
-		'DEGREES'     => array('rad2deg', 1),
+        // D
+        'DATE_FORMAT' => array('_sqlite_func_strftime', 2),
+        'DAYOFMONTH'  => array('_sqlite_func_dayofmonth', 1),
+        'DEGREES'     => array('rad2deg', 1),
 
-		// E
-		'EXTRAIRE_MULTI' => array('_sqlite_func_extraire_multi', 2), // specifique a SPIP/sql_multi()
-		'EXP'            => array('exp', 1),
+        // E
+        'EXTRAIRE_MULTI' => array('_sqlite_func_extraire_multi', 2), // specifique a SPIP/sql_multi()
+        'EXP'            => array('exp', 1),
 
-		// F
-		'FIND_IN_SET' => array('_sqlite_func_find_in_set', 2),
-		'FLOOR'       => array('_sqlite_func_floor', 1),
+        // F
+        'FIND_IN_SET' => array('_sqlite_func_find_in_set', 2),
+        'FLOOR'       => array('_sqlite_func_floor', 1),
 
-		// I
-		'IF'     => array('_sqlite_func_if', 3),
-		'INSERT' => array('_sqlite_func_insert', 4),
-		'INSTR'  => array('_sqlite_func_instr', 2),
+        // I
+        'IF'     => array('_sqlite_func_if', 3),
+        'INSERT' => array('_sqlite_func_insert', 4),
+        'INSTR'  => array('_sqlite_func_instr', 2),
 
-		// L
-		'LEAST'  => array('_sqlite_func_least', 3),
-		'_LEFT'  => array('_sqlite_func_left', 2),
+        // L
+        'LEAST'  => array('_sqlite_func_least', 3),
+        '_LEFT'  => array('_sqlite_func_left', 2),
 #		'LENGTH' => array('strlen', 1), // present v1.0.4
 #		'LOWER'  => array('strtolower', 1), // present v2.4
 #		'LTRIM'  => array('ltrim', 1), // present
 
-		// N
-		'NOW' => array('_sqlite_func_now', 0),
+        // N
+        'NOW' => array('_sqlite_func_now', 0),
 
-		// M
-		'MD5'   => array('md5', 1),
-		'MONTH' => array('_sqlite_func_month', 1),
+        // M
+        'MD5'   => array('md5', 1),
+        'MONTH' => array('_sqlite_func_month', 1),
 
-		// P
-		'PREG_REPLACE' => array('_sqlite_func_preg_replace', 3),
+        // P
+        'PREG_REPLACE' => array('_sqlite_func_preg_replace', 3),
 
-		// R
-		'RADIANS' => array('deg2rad', 1),
-		'RAND'    => array('_sqlite_func_rand', 0), // sinon random() v2.4
-		'REGEXP'  => array('_sqlite_func_regexp_match', 2), // critere REGEXP supporte a partir de v3.3.2
-		'RIGHT'   => array('_sqlite_func_right', 2),
+        // R
+        'RADIANS' => array('deg2rad', 1),
+        'RAND'    => array('_sqlite_func_rand', 0), // sinon random() v2.4
+        'REGEXP'  => array('_sqlite_func_regexp_match', 2), // critere REGEXP supporte a partir de v3.3.2
+        'RIGHT'   => array('_sqlite_func_right', 2),
 #		'RTRIM'   => array('rtrim', 1), // present
 
-		// S
-		'SETTYPE'   => array('settype', 2), // CAST present en v3.2.3
-		'SIN'       => array('sin', 1),
-		'SQRT'      => array('sqrt', 1),
-		'SUBSTRING' => array('_sqlite_func_substring' /*, 3*/), // peut etre appelee avec 2 ou 3 arguments, index base 1 et non 0
+        // S
+        'SETTYPE'   => array('settype', 2), // CAST present en v3.2.3
+        'SIN'       => array('sin', 1),
+        'SQRT'      => array('sqrt', 1),
+        'SUBSTRING' => array('_sqlite_func_substring' /*, 3*/), // peut etre appelee avec 2 ou 3 arguments, index base 1 et non 0
 
-		// T
-		'TAN'           => array('tan', 1),
-		'TIMESTAMPDIFF' => array('_sqlite_timestampdiff'    /*, 3*/),
-		'TO_DAYS'       => array('_sqlite_func_to_days', 1),
+        // T
+        'TAN'           => array('tan', 1),
+        'TIMESTAMPDIFF' => array('_sqlite_timestampdiff'    /*, 3*/),
+        'TO_DAYS'       => array('_sqlite_func_to_days', 1),
 #		'TRIM'          => array('trim', 1), // present
 
-		// U
-		'UNIX_TIMESTAMP' => array('_sqlite_func_unix_timestamp', 1),
+        // U
+        'UNIX_TIMESTAMP' => array('_sqlite_func_unix_timestamp', 1),
 #		'UPPER'          => array('strtoupper', 1), // present v2.4
 
-		// V
-		'VIDE' => array('_sqlite_func_vide', 0), // du vide pour SELECT 0 as x ... ORDER BY x -> ORDER BY vide()
+        // V
+        'VIDE' => array('_sqlite_func_vide', 0), // du vide pour SELECT 0 as x ... ORDER BY x -> ORDER BY vide()
 
-		// Y
-		'YEAR' => array('_sqlite_func_year', 1)
-	);
+        // Y
+        'YEAR' => array('_sqlite_func_year', 1)
+    );
 
-	foreach ($fonctions as $f => $r) {
-		_sqlite_add_function($sqlite, $f, $r);
-	}
+    foreach ($fonctions as $f => $r) {
+        _sqlite_add_function($sqlite, $f, $r);
+    }
 
-	#spip_log('functions sqlite chargees ','sqlite.'._LOG_DEBUG);
+    #spip_log('functions sqlite chargees ','sqlite.'._LOG_DEBUG);
 }
 
 
@@ -145,9 +145,9 @@ 
  * 
 **/
 function _sqlite_add_function(&$sqlite, &$f, &$r) {
-	isset($r[1])
-		? $sqlite->sqliteCreateFunction($f, $r[0], $r[1])
-		: $sqlite->sqliteCreateFunction($f, $r[0]);
+    isset($r[1])
+        ? $sqlite->sqliteCreateFunction($f, $r[0], $r[1])
+        : $sqlite->sqliteCreateFunction($f, $r[0]);
 }
 
 //
@@ -156,41 +156,41 @@ 
 //
 
 function _sqlite_func_ceil($a) {
-	return ceil($a);
+    return ceil($a);
 }
 
 // https://code.spip.net/@_sqlite_func_concat
 function _sqlite_func_concat(...$args) {
-	return join('', $args);
+    return join('', $args);
 }
 
 
 // https://code.spip.net/@_sqlite_func_dayofmonth
 function _sqlite_func_dayofmonth($d) {
-	return _sqlite_func_date("d", $d);
+    return _sqlite_func_date("d", $d);
 }
 
 
 // https://code.spip.net/@_sqlite_func_find_in_set
 function _sqlite_func_find_in_set($num, $set) {
-	$rank = 0;
-	foreach (explode(",", $set) as $v) {
-		if ($v == $num) {
-			return (++$rank);
-		}
-		$rank++;
-	}
-
-	return 0;
+    $rank = 0;
+    foreach (explode(",", $set) as $v) {
+        if ($v == $num) {
+            return (++$rank);
+        }
+        $rank++;
+    }
+
+    return 0;
 }
 
 function _sqlite_func_floor($a) {
-	return floor($a);
+    return floor($a);
 }
 
 // https://code.spip.net/@_sqlite_func_if
 function _sqlite_func_if($bool, $oui, $non) {
-	return ($bool) ? $oui : $non;
+    return ($bool) ? $oui : $non;
 }
 
 
@@ -201,59 +201,59 @@ 
  */
 // https://code.spip.net/@_sqlite_func_insert
 function _sqlite_func_insert($s, $index, $longueur, $chaine) {
-	return
-		substr($s, 0, $index)
-		. $chaine
-		. substr(substr($s, $index), $longueur);
+    return
+        substr($s, 0, $index)
+        . $chaine
+        . substr(substr($s, $index), $longueur);
 }
 
 
 // https://code.spip.net/@_sqlite_func_instr
 function _sqlite_func_instr($s, $search) {
-	return strpos($s, $search);
+    return strpos($s, $search);
 }
 
 
 // https://code.spip.net/@_sqlite_func_least
 function _sqlite_func_least() {
-	$arg_list = func_get_args();
-	$least = min($arg_list);
+    $arg_list = func_get_args();
+    $least = min($arg_list);
 
-	#spip_log("Passage avec LEAST : $least",'sqlite.'._LOG_DEBUG);
-	return $least;
+    #spip_log("Passage avec LEAST : $least",'sqlite.'._LOG_DEBUG);
+    return $least;
 }
 
 
 // https://code.spip.net/@_sqlite_func_left
 function _sqlite_func_left($s, $lenght) {
-	return substr($s, $lenght);
+    return substr($s, $lenght);
 }
 
 
 // https://code.spip.net/@_sqlite_func_now
 function _sqlite_func_now() {
-	static $now = null;
-	if (is_null($now)) {
-		$now = date("Y-m-d H:i:s");
-	}
+    static $now = null;
+    if (is_null($now)) {
+        $now = date("Y-m-d H:i:s");
+    }
 
-	#spip_log("Passage avec NOW : $now",'sqlite.'._LOG_DEBUG);
-	return $now;
+    #spip_log("Passage avec NOW : $now",'sqlite.'._LOG_DEBUG);
+    return $now;
 }
 
 
 // https://code.spip.net/@_sqlite_func_month
 function _sqlite_func_month($d) {
-	return _sqlite_func_date("m", $d);
+    return _sqlite_func_date("m", $d);
 }
 
 
 // https://code.spip.net/@_sqlite_func_preg_replace
 function _sqlite_func_preg_replace($quoi, $cherche, $remplace) {
-	$return = preg_replace('%' . $cherche . '%', $remplace, $quoi);
+    $return = preg_replace('%' . $cherche . '%', $remplace, $quoi);
 
-	#spip_log("preg_replace : $quoi, $cherche, $remplace, $return",'sqlite.'._LOG_DEBUG);
-	return $return;
+    #spip_log("preg_replace : $quoi, $cherche, $remplace, $return",'sqlite.'._LOG_DEBUG);
+    return $return;
 }
 
 /**
@@ -264,54 +264,54 @@ 
  * @return string, l'extrait trouve.
  **/
 function _sqlite_func_extraire_multi($quoi, $lang) {
-	if (!defined('_EXTRAIRE_MULTI')) {
-		include_spip('inc/filtres');
-	}
-	if (!function_exists('approcher_langue')) {
-		include_spip('inc/lang');
-	}
-	if (preg_match_all(_EXTRAIRE_MULTI, $quoi, $regs, PREG_SET_ORDER)) {
-		foreach ($regs as $reg) {
-			// chercher la version de la langue courante
-			$trads = extraire_trads($reg[1]);
-			if ($l = approcher_langue($trads, $lang)) {
-				$trad = $trads[$l];
-			} else {
-				$trad = reset($trads);
-			}
-			$quoi = str_replace($reg[0], $trad, $quoi);
-		}
-	}
-
-	return $quoi;
+    if (!defined('_EXTRAIRE_MULTI')) {
+        include_spip('inc/filtres');
+    }
+    if (!function_exists('approcher_langue')) {
+        include_spip('inc/lang');
+    }
+    if (preg_match_all(_EXTRAIRE_MULTI, $quoi, $regs, PREG_SET_ORDER)) {
+        foreach ($regs as $reg) {
+            // chercher la version de la langue courante
+            $trads = extraire_trads($reg[1]);
+            if ($l = approcher_langue($trads, $lang)) {
+                $trad = $trads[$l];
+            } else {
+                $trad = reset($trads);
+            }
+            $quoi = str_replace($reg[0], $trad, $quoi);
+        }
+    }
+
+    return $quoi;
 }
 
 
 // https://code.spip.net/@_sqlite_func_rand
 function _sqlite_func_rand() {
-	return rand();
+    return rand();
 }
 
 
 // https://code.spip.net/@_sqlite_func_right
 function _sqlite_func_right($s, $length) {
-	return substr($s, 0 - $length);
+    return substr($s, 0 - $length);
 }
 
 
 // https://code.spip.net/@_sqlite_func_regexp_match
 function _sqlite_func_regexp_match($cherche, $quoi) {
-	// optimiser un cas tres courant avec les requetes en base
-	if (!$quoi and !strlen($quoi)) {
-		return false;
-	}
-	// il faut enlever un niveau d'echappement pour être homogène à mysql
-	$cherche = str_replace('\\\\', '\\', $cherche);
-	$u = isset($GLOBALS['meta']['pcre_u']) ? $GLOBALS['meta']['pcre_u'] : 'u';
-	$return = preg_match('%' . $cherche . '%imsS' . $u, $quoi);
-
-	#spip_log("regexp_replace : $quoi, $cherche, $remplace, $return",'sqlite.'._LOG_DEBUG);
-	return $return;
+    // optimiser un cas tres courant avec les requetes en base
+    if (!$quoi and !strlen($quoi)) {
+        return false;
+    }
+    // il faut enlever un niveau d'echappement pour être homogène à mysql
+    $cherche = str_replace('\\\\', '\\', $cherche);
+    $u = isset($GLOBALS['meta']['pcre_u']) ? $GLOBALS['meta']['pcre_u'] : 'u';
+    $return = preg_match('%' . $cherche . '%imsS' . $u, $quoi);
+
+    #spip_log("regexp_replace : $quoi, $cherche, $remplace, $return",'sqlite.'._LOG_DEBUG);
+    return $return;
 }
 
 
@@ -323,8 +323,8 @@ 
  * @return string
  */
 function _sqlite_func_strftime($date, $conv) {
-	$conv = _sqlite_func_strftime_format_converter($conv);
-	return strftime($conv, is_int($date) ? $date : strtotime($date));
+    $conv = _sqlite_func_strftime_format_converter($conv);
+    return strftime($conv, is_int($date) ? $date : strtotime($date));
 }
 
 /**
@@ -340,28 +340,28 @@ 
  * @return void
  */
 function _sqlite_func_strftime_format_converter(string $conv) : string {
-	// ok : %a %b %d %e %H %I %l %j %k %m %p %r %S %T %w %y %Y
-	// on ne sait pas en gérer certains...
-	static $mysql_to_strftime_not_ok = ['%c', '%D', '%f', '%U', '%V', '%W', '%X'];
-	static $mysql_to_strftime = [
-		'%h' => '%I',
-		'%i' => '%M',
-		'%M' => '%B',
-		'%s' => '%S',
-		'%u' => '%U',
-		'%v' => '%V',
-		'%x' => '%G',
-	];
-	static $to_strftime = [];
-	if (!isset($to_strftime[$conv])) {
-		$count = 0;
-		str_replace($mysql_to_strftime_not_ok, '', $conv, $count);
-		if ($count > 0) {
-			spip_log("DATE_FORMAT : At least one parameter can't be parsed by strftime with format '$conv'", 'sqlite.' . _LOG_ERREUR);
-		}
-		$to_strftime[$conv] = str_replace(array_keys($mysql_to_strftime), $mysql_to_strftime, $conv);
-	}
-	return $to_strftime[$conv];
+    // ok : %a %b %d %e %H %I %l %j %k %m %p %r %S %T %w %y %Y
+    // on ne sait pas en gérer certains...
+    static $mysql_to_strftime_not_ok = ['%c', '%D', '%f', '%U', '%V', '%W', '%X'];
+    static $mysql_to_strftime = [
+        '%h' => '%I',
+        '%i' => '%M',
+        '%M' => '%B',
+        '%s' => '%S',
+        '%u' => '%U',
+        '%v' => '%V',
+        '%x' => '%G',
+    ];
+    static $to_strftime = [];
+    if (!isset($to_strftime[$conv])) {
+        $count = 0;
+        str_replace($mysql_to_strftime_not_ok, '', $conv, $count);
+        if ($count > 0) {
+            spip_log("DATE_FORMAT : At least one parameter can't be parsed by strftime with format '$conv'", 'sqlite.' . _LOG_ERREUR);
+        }
+        $to_strftime[$conv] = str_replace(array_keys($mysql_to_strftime), $mysql_to_strftime, $conv);
+    }
+    return $to_strftime[$conv];
 }
 
 /**
@@ -373,21 +373,21 @@ 
  * @return int
  */
 function _sqlite_func_to_days($d) {
-	static $offset = 719528; // nb de jour entre 0000-00-00 et timestamp 0=1970-01-01
-	$result = $offset + (int)ceil(_sqlite_func_unix_timestamp($d) / (24 * 3600));
+    static $offset = 719528; // nb de jour entre 0000-00-00 et timestamp 0=1970-01-01
+    $result = $offset + (int)ceil(_sqlite_func_unix_timestamp($d) / (24 * 3600));
 
-	#spip_log("Passage avec TO_DAYS : $d, $result",'sqlite.'._LOG_DEBUG);
-	return $result;
+    #spip_log("Passage avec TO_DAYS : $d, $result",'sqlite.'._LOG_DEBUG);
+    return $result;
 }
 
 function _sqlite_func_substring($string, $start, $len = null) {
-	// SQL compte a partir de 1, php a partir de 0
-	$start = ($start > 0) ? $start - 1 : $start;
-	if (is_null($len)) {
-		return substr($string, $start);
-	} else {
-		return substr($string, $start, $len);
-	}
+    // SQL compte a partir de 1, php a partir de 0
+    $start = ($start > 0) ? $start - 1 : $start;
+    if (is_null($len)) {
+        return substr($string, $start);
+    } else {
+        return substr($string, $start, $len);
+    }
 }
 
 /**
@@ -401,61 +401,61 @@ 
  * @return int
  */
 function _sqlite_timestampdiff($unit, $date1, $date2) {
-	$d1 = date_create($date1);
-	$d2 = date_create($date2);
-	$diff = date_diff($d1, $d2);
-	$inv = $diff->invert ? -1 : 1;
-	switch ($unit) {
-		case "YEAR":
-			return $inv * $diff->y;
-		case "QUARTER":
-			return $inv * (4 * $diff->y + intval(floor($diff->m / 3)));
-		case "MONTH":
-			return $inv * (12 * $diff->y + $diff->m);
-		case "WEEK":
-			return $inv * intval(floor($diff->days / 7));
-		case "DAY":
-			#var_dump($inv*$diff->days);
-			return $inv * $diff->days;
-		case "HOUR":
-			return $inv * (24 * $diff->days + $diff->h);
-		case "MINUTE":
-			return $inv * ((24 * $diff->days + $diff->h) * 60 + $diff->i);
-		case "SECOND":
-			return $inv * (((24 * $diff->days + $diff->h) * 60 + $diff->i) * 60 + $diff->s);
-		case "MICROSECOND":
-			return $inv * (((24 * $diff->days + $diff->h) * 60 + $diff->i) * 60 + $diff->s) * 1000000;
-	}
-
-	return 0;
+    $d1 = date_create($date1);
+    $d2 = date_create($date2);
+    $diff = date_diff($d1, $d2);
+    $inv = $diff->invert ? -1 : 1;
+    switch ($unit) {
+        case "YEAR":
+            return $inv * $diff->y;
+        case "QUARTER":
+            return $inv * (4 * $diff->y + intval(floor($diff->m / 3)));
+        case "MONTH":
+            return $inv * (12 * $diff->y + $diff->m);
+        case "WEEK":
+            return $inv * intval(floor($diff->days / 7));
+        case "DAY":
+            #var_dump($inv*$diff->days);
+            return $inv * $diff->days;
+        case "HOUR":
+            return $inv * (24 * $diff->days + $diff->h);
+        case "MINUTE":
+            return $inv * ((24 * $diff->days + $diff->h) * 60 + $diff->i);
+        case "SECOND":
+            return $inv * (((24 * $diff->days + $diff->h) * 60 + $diff->i) * 60 + $diff->s);
+        case "MICROSECOND":
+            return $inv * (((24 * $diff->days + $diff->h) * 60 + $diff->i) * 60 + $diff->s) * 1000000;
+    }
+
+    return 0;
 }
 
 // https://code.spip.net/@_sqlite_func_unix_timestamp
 function _sqlite_func_unix_timestamp($d) {
-	static $mem = array();
-	static $n = 0;
-	if (isset($mem[$d])) {
-		return $mem[$d];
-	}
-	if ($n++ > 100) {
-		$mem = array();
-		$n = 0;
-	}
-
-	//2005-12-02 20:53:53
-	#spip_log("Passage avec UNIX_TIMESTAMP : $d",'sqlite.'._LOG_DEBUG);
-	if (!$d) {
-		return $mem[$d] = mktime();
-	}
-
-	// une pile plus grosse n'accelere pas le calcul
-	return $mem[$d] = strtotime($d);
+    static $mem = array();
+    static $n = 0;
+    if (isset($mem[$d])) {
+        return $mem[$d];
+    }
+    if ($n++ > 100) {
+        $mem = array();
+        $n = 0;
+    }
+
+    //2005-12-02 20:53:53
+    #spip_log("Passage avec UNIX_TIMESTAMP : $d",'sqlite.'._LOG_DEBUG);
+    if (!$d) {
+        return $mem[$d] = mktime();
+    }
+
+    // une pile plus grosse n'accelere pas le calcul
+    return $mem[$d] = strtotime($d);
 }
 
 
 // https://code.spip.net/@_sqlite_func_year
 function _sqlite_func_year($d) {
-	return _sqlite_func_date("Y", $d);
+    return _sqlite_func_date("Y", $d);
 }
 
 /**
@@ -469,23 +469,23 @@ 
  * @return int
  */
 function _sqlite_func_date($quoi, $d) {
-	static $mem = array();
-	static $n = 0;
-	if (isset($mem[$d])) {
-		return $mem[$d][$quoi];
-	}
-	if ($n++ > 100) {
-		$mem = array();
-		$n = 0;
-	}
-
-	$dec = date("Y-m-d", _sqlite_func_unix_timestamp($d));
-	$mem[$d] = array("Y" => substr($dec, 0, 4), "m" => substr($dec, 5, 2), "d" => substr($dec, 8, 2));
-
-	return $mem[$d][$quoi];
+    static $mem = array();
+    static $n = 0;
+    if (isset($mem[$d])) {
+        return $mem[$d][$quoi];
+    }
+    if ($n++ > 100) {
+        $mem = array();
+        $n = 0;
+    }
+
+    $dec = date("Y-m-d", _sqlite_func_unix_timestamp($d));
+    $mem[$d] = array("Y" => substr($dec, 0, 4), "m" => substr($dec, 5, 2), "d" => substr($dec, 8, 2));
+
+    return $mem[$d][$quoi];
 }
 
 // https://code.spip.net/@_sqlite_func_vide
 function _sqlite_func_vide() {
-	return;
+    return;
 }