Civi/Api4/Query/SqlString.php

   1 <?php
   2 /*
   3  +--------------------------------------------------------------------+
   4  | Copyright CiviCRM LLC. All rights reserved.                        |
   5  |                                                                    |
   6  | This work is published under the GNU AGPLv3 license with some      |
   7  | permitted exceptions and without any warranty. For full license    |
   8  | and copyright information, see https://civicrm.org/licensing       |
   9  +--------------------------------------------------------------------+
  10  */
  11
  12 namespace Civi\Api4\Query;
  13
  14 /**
  15  * String sql expression
  16  */
  17 class SqlString extends SqlExpression {
  18
  19   protected static $dataType = 'String';
  20
  21   protected function initialize() {
  22     // Remove surrounding quotes
  23     $str = substr($this->expr, 1, -1);
  24     // Unescape the outer quote character inside the string to prevent double-escaping in render()
  25     $quot = substr($this->expr, 0, 1);
  26     $backslash = chr(0) . 'backslash' . chr(0);
  27     $this->expr = str_replace(['\\\\', "\\$quot", $backslash], [$backslash, $quot, '\\\\'], $str);
  28   }
  29
  30   public function render(array $fieldList): string {
  31     return '"' . \CRM_Core_DAO::escapeString($this->expr) . '"';
  32   }
  33
  34   public static function getTitle(): string {
  35     return ts('Text');
  36   }
  37
  38 }