fluent-cart / app / Models / BatchQuery / Common.php

Common.php in FluentCart A New Era of eCommerce – Faster, Lighter, and Simpler 1.6.4, at app/Models/BatchQuery/Common.php

88 lines 2.2 KB

Raw Download Zip

1	<?php
2
3	namespace FluentCart\App\Models\BatchQuery;
4
5	class Common
6	{
7	/**
8	* Escape values according to mysql.
9	*
10	* @param $fieldValue
11	* @return array\|string\|string[]
12	*/
13	public static function mysqlEscape($fieldValue)
14	{
15	if (is_array($fieldValue)) {
16	return array_map(__METHOD__, $fieldValue);
17	}
18
19	if (is_bool($fieldValue)) {
20	return (int)$fieldValue;
21	}
22
23	if (self::is_json($fieldValue)) {
24	return self::safeJson($fieldValue);
25	}
26
27	if (!empty($fieldValue) && is_string($fieldValue)) {
28	return str_replace(
29	['\\', "\0", "\n", "\r", "'", '"', "\x1a"],
30	['\\\\', '\\0', '\\n', '\\r', "\\'", '\\"', '\\Z'],
31	$fieldValue
32	);
33	}
34
35	return $fieldValue;
36	}
37
38	/**
39	* Disable Backtick.
40	*
41	* @param $drive
42	* @return boolean
43	*/
44	public static function disableBacktick($drive)
45	{
46	return in_array($drive, ['pgsql', 'sqlsrv']);
47	}
48
49	protected static function safeJsonString($fieldValue)
50	{
51	return str_replace(
52	["'"],
53	["''"],
54	$fieldValue
55	);
56	}
57
58	protected static function is_json($str): bool
59	{
60	if (!is_string($str) \|\| is_numeric($str)) {
61	return false;
62	}
63	$json = json_decode($str);
64	return $json && $str != $json;
65	}
66
67	protected static function safeJson($jsonData, $asArray = false)
68	{
69	$jsonData = json_decode($jsonData, true);
70	$safeJsonData = [];
71	if (!is_array($jsonData)) {
72	return $jsonData;
73	}
74	foreach ($jsonData as $key => $value) {
75	if (self::is_json($value)) {
76	$safeJsonData[$key] = self::safeJson($value, true);
77	} elseif (is_string($value)) {
78	$safeJsonData[$key] = self::safeJsonString($value);
79	} elseif (is_array($value)) {
80	$safeJsonData[$key] = self::safeJson(json_encode($value), true);
81	} else {
82	$safeJsonData[$key] = $value;
83	}
84	}
85	return $asArray ? $safeJsonData : json_encode($safeJsonData, JSON_UNESCAPED_UNICODE);
86	}
87
88	}