64 $sourcetable = $sourcetype;
65 $targettable = $targettype;
67 if ($sourcetype ==
'shipping') {
68 $sourcetable =
'expedition';
69 } elseif ($targettype ==
'shipping') {
70 $targettable =
'expedition';
72 if ($sourcetype ==
'delivery') {
73 $sourcetable =
'livraison';
74 } elseif ($targettype ==
'delivery') {
75 $targettable =
'livraison';
77 if ($sourcetype ==
'order_supplier') {
78 $sourcetable =
'commande_fournisseur';
79 } elseif ($targettype ==
'order_supplier') {
80 $targettable =
'commande_fournisseur';
82 if ($sourcetype ==
'invoice_supplier') {
83 $sourcetable =
'facture_fourn';
84 } elseif ($targettype ==
'invoice_supplier') {
85 $targettable =
'facture_fourn';
88 $out = $langs->trans(
'SourceType').
': '.$sourcetype.
' => '.$langs->trans(
'TargetType').
': '.$targettype.
' ';
90 $sql =
"SELECT rowid, fk_source, fk_target FROM ".MAIN_DB_PREFIX.
"element_element";
91 $sql .=
" WHERE sourcetype = '".$db->escape($sourcetype).
"' AND targettype = '".$db->escape($targettype).
"'";
92 $resql = $db->query($sql);
94 $num = $db->num_rows($resql);
98 $obj = $db->fetch_object($resql);
99 $elements[$obj->rowid] = array($sourcetype => $obj->fk_source, $targettype => $obj->fk_target);
105 if (!empty($elements)) {
106 foreach ($elements as $key => $element) {
108 $sql =
'DELETE FROM '.MAIN_DB_PREFIX.
'element_element';
109 $sql .=
" WHERE rowid = ".((int) $key);
110 $resql = $db->query($sql);
117 $out .=
'('.$langs->trans(
'LinkedElementsInvalidDeleted', $deleted).
')<br>';
119 $out .=
'('.$langs->trans(
'NothingToDelete').
')<br>';
171function repairEcmFiles($db, $entity, $documentroot, $confirmed =
false, $maxdelete = 100)
173 $report = array(
'processed' => 0,
'missing' => 0,
'deleted' => 0,
'skipped' => 0,
'limitreached' =>
false,
'entries' => array(),
'error' =>
'');
174 if ($entity <= 0 || $maxdelete <= 0) {
175 $report[
'error'] =
'ErrorWrongParameters';
180 $report[
'error'] =
'RepairEcmDirectoryUnavailable';
183 $rootprefix = rtrim(str_replace(
'\\',
'/', $realroot),
'/').
'/';
184 $sql =
"SELECT rowid, filename, filepath FROM ".$db->prefix().
"ecm_files";
185 $sql .=
" WHERE entity = ".((int) $entity).
" ORDER BY rowid ASC";
186 $resql = $db->query($sql);
188 $report[
'error'] =
'RepairEcmDatabaseError';
191 $candidates = array();
192 while (is_object($obj = $db->fetch_object($resql))) {
193 $report[
'processed']++;
194 $relativepath = str_replace(
'\\',
'/', (
string) $obj->filepath);
195 $filename = (string) $obj->filename;
197 if ($relativepath ===
'' || preg_match(
'~^/|(^|/)\.\.?(/|$)|[\x00-\x1f:]~', $relativepath)
198 || $filename ===
'' || $filename ===
'.' || $filename ===
'..' || preg_match(
'~[\\\\/\x00-\x1f:]~', $filename)) {
199 $report[
'skipped']++;
202 $directory = $documentroot.
'/'.$relativepath;
204 if ($realdirectory ===
false || !is_readable(
dol_osencode($directory))
205 || strpos(rtrim(str_replace(
'\\',
'/', $realdirectory),
'/').
'/', $rootprefix) !== 0) {
206 $report[
'skipped']++;
209 $filetocheck = $directory.
'/'.$filename;
214 $report[
'skipped']++;
217 $report[
'missing']++;
218 if (count($candidates) >= $maxdelete) {
219 $report[
'limitreached'] =
true;
222 $candidates[] = $obj;
223 $report[
'entries'][] = array(
'id' => (
int) $obj->rowid,
'path' => $relativepath.
'/'.$filename);
226 if (!$confirmed || !$candidates) {
230 $report[
'error'] =
'RepairEcmDatabaseError';
233 foreach ($candidates as $candidate) {
235 $filetocheck = $documentroot.
'/'.$candidate->filepath.
'/'.$candidate->filename;
236 $directory = dirname($filetocheck);
238 if ($realdirectory ===
false || !is_readable(
dol_osencode($directory))
239 || strpos(rtrim(str_replace(
'\\',
'/', $realdirectory),
'/').
'/', $rootprefix) !== 0
241 $report[
'skipped']++;
247 $sql =
"DELETE FROM ".$db->prefix().
"ecm_files WHERE rowid = ".((int) $candidate->rowid);
248 $sql .=
" AND entity = ".((int) $entity);
249 $sql .=
" AND filepath = '".$db->escape($candidate->filepath).
"' AND filename = '".$db->escape($candidate->filename).
"'";
250 $result = $db->query($sql);
253 $report[
'deleted'] = 0;
254 $report[
'error'] =
'RepairEcmDatabaseError';
257 $report[
'deleted'] += $db->affected_rows($result);
259 if (!$db->commit()) {
261 $report[
'deleted'] = 0;
262 $report[
'error'] =
'RepairEcmDatabaseError';
277 $path = rtrim(str_replace(
'\\',
'/', $path),
'/');
278 $directory = rtrim(str_replace(
'\\',
'/', $directory),
'/');
279 $documentroot = rtrim(str_replace(
'\\',
'/', $documentroot),
'/');
280 $windows = stripos(PHP_OS,
'WIN') === 0;
281 $documentrootlength =
dol_strlen($documentroot,
'UTF-8', 1);
282 $directorylength =
dol_strlen($directory,
'UTF-8', 1);
283 if ($path ===
'' || $directory ===
'' || $documentroot ===
'' || preg_match(
'~(?:^|/)\.\.?(?:/|$)~', $path)) {
286 if (($windows ? strncasecmp($directory.
'/', $documentroot.
'/', $documentrootlength + 1) : strncmp($directory.
'/', $documentroot.
'/', $documentrootlength + 1)) !== 0
287 || ($windows ? strncasecmp($path.
'/', $directory.
'/', $directorylength + 1) : strncmp($path.
'/', $directory.
'/', $directorylength + 1)) !== 0) {
292 if ($realroot ===
false || $realdirectory ===
false || !
dol_is_dir($directory)) {
295 $realroot = rtrim(str_replace(
'\\',
'/', $realroot),
'/');
296 $expected = $realroot.dol_substr($directory, $documentrootlength,
null,
'UTF-8', 1);
297 $realdirectory = str_replace(
'\\',
'/', $realdirectory);
298 if (($windows ? strcasecmp($realdirectory, $expected) : strcmp($realdirectory, $expected)) !== 0) {
304 $nextparent = dirname($parent);
305 if ($nextparent === $parent) {
308 $parent = $nextparent;
311 if ($realparent ===
false) {
314 $expected = $realroot.dol_substr($parent, $documentrootlength,
null,
'UTF-8', 1);
315 $realparent = str_replace(
'\\',
'/', $realparent);
316 return ($windows ? strcasecmp($realparent, $expected) : strcmp($realparent, $expected)) === 0;
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
repairEcmFiles($db, $entity, $documentroot, $confirmed=false, $maxdelete=100)
Check an entity's ECM index against the filesystem, optionally removing missing-file entries.
repairImagePathIsSafe($path, $directory, $documentroot)
Check an image repair path, including a missing destination, against its owner's directory.