| @@ 777-799 (lines=23) @@ | ||
| 774 | 'uid', |
|
| 775 | $queryBuilder->createNamedParameter($oldMMs_inclUid[$oldMM_key][2], \PDO::PARAM_INT) |
|
| 776 | )); |
|
| 777 | } else { |
|
| 778 | if (is_array($mmItem)) { |
|
| 779 | $removeClauses->add( |
|
| 780 | $queryBuilder->expr()->andX( |
|
| 781 | $queryBuilder->expr()->eq( |
|
| 782 | 'tablenames', |
|
| 783 | $queryBuilder->createNamedParameter($mmItem[0], \PDO::PARAM_STR) |
|
| 784 | ), |
|
| 785 | $queryBuilder->expr()->eq( |
|
| 786 | $uidForeign_field, |
|
| 787 | $queryBuilder->createNamedParameter($mmItem[1], \PDO::PARAM_INT) |
|
| 788 | ) |
|
| 789 | ) |
|
| 790 | ); |
|
| 791 | } else { |
|
| 792 | $removeClauses->add( |
|
| 793 | $queryBuilder->expr()->eq( |
|
| 794 | $uidForeign_field, |
|
| 795 | $queryBuilder->createNamedParameter($mmItem, \PDO::PARAM_INT) |
|
| 796 | ) |
|
| 797 | ); |
|
| 798 | } |
|
| 799 | } |
|
| 800 | if ($this->MM_is_foreign) { |
|
| 801 | if (is_array($mmItem)) { |
|
| 802 | $updateRefIndex_records[] = [$mmItem[0], $mmItem[1]]; |
|
| @@ 932-950 (lines=19) @@ | ||
| 929 | ->from($foreign_table); |
|
| 930 | ||
| 931 | // Search for $uid in foreign_field, and if we have symmetric relations, do this also on symmetric_field |
|
| 932 | if ($conf['symmetric_field']) { |
|
| 933 | $queryBuilder->where( |
|
| 934 | $queryBuilder->expr()->orX( |
|
| 935 | $queryBuilder->expr()->eq( |
|
| 936 | $conf['foreign_field'], |
|
| 937 | $queryBuilder->createNamedParameter($uid, \PDO::PARAM_INT) |
|
| 938 | ), |
|
| 939 | $queryBuilder->expr()->eq( |
|
| 940 | $conf['symmetric_field'], |
|
| 941 | $queryBuilder->createNamedParameter($uid, \PDO::PARAM_INT) |
|
| 942 | ) |
|
| 943 | ) |
|
| 944 | ); |
|
| 945 | } else { |
|
| 946 | $queryBuilder->where($queryBuilder->expr()->eq( |
|
| 947 | $conf['foreign_field'], |
|
| 948 | $queryBuilder->createNamedParameter($uid, \PDO::PARAM_INT) |
|
| 949 | )); |
|
| 950 | } |
|
| 951 | // If it's requested to look for the parent uid AND the parent table, |
|
| 952 | // add an additional SQL-WHERE clause |
|
| 953 | if ($foreign_table_field && $this->currentTable) { |
|