private static function makePropPart(umiSelection $vef5714e0519bfaa645cdff7d28843b70) { if ($v23182694bce9f52758fbab174a0b3607 = $vef5714e0519bfaa645cdff7d28843b70->getSearchStrings()) { $v80071f37861c360a27b7327e132c911a = "cms3_object_content"; $v6a7f245843454cf4f28ad7c5e2572aa2 = $vef5714e0519bfaa645cdff7d28843b70->getHierarchyConds(); $v6a7f245843454cf4f28ad7c5e2572aa2 = array_extract_values($v6a7f245843454cf4f28ad7c5e2572aa2); if (sizeof($v6a7f245843454cf4f28ad7c5e2572aa2)) { $v6301cee35ea764a1e241978f93f01069 = umiHierarchy::getInstance()->getDominantTypeId(array_pop($v6a7f245843454cf4f28ad7c5e2572aa2)); $v80071f37861c360a27b7327e132c911a = umiBranch::getBranchedTableByTypeId($v6301cee35ea764a1e241978f93f01069); } else { $vd14a8022b085f9ef19d479cbdd581127 = $vef5714e0519bfaa645cdff7d28843b70->getElementTypeConds(); if (is_array($vd14a8022b085f9ef19d479cbdd581127) && sizeof($vd14a8022b085f9ef19d479cbdd581127)) { $vacf567c9c3d6cf7c6e2cc0ce108e0631 = array_pop($vd14a8022b085f9ef19d479cbdd581127); if ($vacf567c9c3d6cf7c6e2cc0ce108e0631 == 21 && sizeof($vd14a8022b085f9ef19d479cbdd581127)) { $vacf567c9c3d6cf7c6e2cc0ce108e0631 = array_pop($vd14a8022b085f9ef19d479cbdd581127); } if (umiBranch::checkIfBranchedByHierarchyTypeId($vacf567c9c3d6cf7c6e2cc0ce108e0631)) { $v80071f37861c360a27b7327e132c911a .= "_" . $vacf567c9c3d6cf7c6e2cc0ce108e0631; } } } $v056301054c43f8bbea2090debfec16b1 = "ct"; $vef5714e0519bfaa645cdff7d28843b70->sql_part__content_tables .= ", {$v80071f37861c360a27b7327e132c911a} {$v056301054c43f8bbea2090debfec16b1}"; $vef5714e0519bfaa645cdff7d28843b70->usedContentTables[] = $v056301054c43f8bbea2090debfec16b1; $ve1043d63313a1b59f16fe608277bc9a7 = self::getFileFields(); if (sizeof($ve1043d63313a1b59f16fe608277bc9a7) > 0) { $vd60fb1b18e68fb7029b3ef48c9a18834 = " AND ct.field_id NOT IN (" . implode(", ", $ve1043d63313a1b59f16fe608277bc9a7) . ")"; } else { $vd60fb1b18e68fb7029b3ef48c9a18834 = ""; } $v4ab5dfe1c68b36d1aa7d5f8d9cde73bc = array(); foreach ($v23182694bce9f52758fbab174a0b3607 as $v597a51f04d341eba4ca965899acc10b3) { $v597a51f04d341eba4ca965899acc10b3 = l_mysql_real_escape_string($v597a51f04d341eba4ca965899acc10b3); $v4439237446062bd0268640161c6a6bc3 = is_numeric($v597a51f04d341eba4ca965899acc10b3) ? " OR ct.float_val = '{$v597a51f04d341eba4ca965899acc10b3}' OR ct.int_val = '{$v597a51f04d341eba4ca965899acc10b3}'" : ""; $v4ab5dfe1c68b36d1aa7d5f8d9cde73bc[] = "o.name LIKE '%{$v597a51f04d341eba4ca965899acc10b3}%' OR ct.varchar_val LIKE '%{$v597a51f04d341eba4ca965899acc10b3}%' OR ct.text_val LIKE '%{$v597a51f04d341eba4ca965899acc10b3}%' {$v4439237446062bd0268640161c6a6bc3}" . $vd60fb1b18e68fb7029b3ef48c9a18834; } $vef5714e0519bfaa645cdff7d28843b70->sql_arr_for_and_or_part['where'][] = "ct.obj_id = o.id AND (" . implode(" OR ", $v4ab5dfe1c68b36d1aa7d5f8d9cde73bc) . ")"; $vef5714e0519bfaa645cdff7d28843b70->sql_cond__need_content = true; } if ($vc25b09274ac632224f348e21022a7106 = $vef5714e0519bfaa645cdff7d28843b70->getPropertyConds()) { $v47ec37bbecbabe9f73c2d0056e5cb796 = array(); foreach ($vc25b09274ac632224f348e21022a7106 as $v7f8b41bdd7c22fc431a0314de4595025) { if ($v7f8b41bdd7c22fc431a0314de4595025['type'] !== false) { $v47ec37bbecbabe9f73c2d0056e5cb796[] = $v7f8b41bdd7c22fc431a0314de4595025; } } unset($vc25b09274ac632224f348e21022a7106); if ($v7dabf5c198b0bab2eaa42bb03a113e55 = sizeof($v47ec37bbecbabe9f73c2d0056e5cb796)) { $v865c0c0b4ab0e063e5caa3387c1a8741 = 0; for ($v865c0c0b4ab0e063e5caa3387c1a8741 = 0; $v865c0c0b4ab0e063e5caa3387c1a8741 < $v7dabf5c198b0bab2eaa42bb03a113e55; $v865c0c0b4ab0e063e5caa3387c1a8741++) { $v5cba202deaa7e9f47bd0317cf014c64b = $v47ec37bbecbabe9f73c2d0056e5cb796[$v865c0c0b4ab0e063e5caa3387c1a8741]; $vf642bf0e4102797f994548b9f4ee9e4a = isset($v5cba202deaa7e9f47bd0317cf014c64b['filter_type']) ? $v5cba202deaa7e9f47bd0317cf014c64b['filter_type'] : ''; $v01aaeba75d696598feafcb0226fdb7e9 = isset($v5cba202deaa7e9f47bd0317cf014c64b['value']) ? $v5cba202deaa7e9f47bd0317cf014c64b['value'] : null; $v0f728ec6147eaec54f5f45e37bce8ddd = isset($v5cba202deaa7e9f47bd0317cf014c64b['field_id']) ? $v5cba202deaa7e9f47bd0317cf014c64b['field_id'] : 0; $v1abd88b57ac7e290b6c91d26b0909006 = isset($v5cba202deaa7e9f47bd0317cf014c64b['type']) ? $v5cba202deaa7e9f47bd0317cf014c64b['type'] : ''; if ($v1abd88b57ac7e290b6c91d26b0909006 == 'optioned') { if (!is_array($v01aaeba75d696598feafcb0226fdb7e9)) { continue; } $v14f802e1fba977727845e8872c1743a7 = array_keys($v01aaeba75d696598feafcb0226fdb7e9); if (sizeof($v14f802e1fba977727845e8872c1743a7) == 0) { continue; } list($v1abd88b57ac7e290b6c91d26b0909006) = $v14f802e1fba977727845e8872c1743a7; if (in_array($v1abd88b57ac7e290b6c91d26b0909006, array('int', 'float', 'varchar', 'tree', 'rel')) == false) { continue; } $v1abd88b57ac7e290b6c91d26b0909006 .= "_val"; } if (!$vef5714e0519bfaa645cdff7d28843b70->getConditionModeOr() || $vef5714e0519bfaa645cdff7d28843b70->sql_cond__content_tables_loaded == 0) { $v056301054c43f8bbea2090debfec16b1 = "c" . ++$vef5714e0519bfaa645cdff7d28843b70->sql_cond__content_tables_loaded; $v80071f37861c360a27b7327e132c911a = self::chooseContentTableName($vef5714e0519bfaa645cdff7d28843b70, $v47ec37bbecbabe9f73c2d0056e5cb796[$v865c0c0b4ab0e063e5caa3387c1a8741]['field_id']); $vef5714e0519bfaa645cdff7d28843b70->sql_part__content_tables .= ", {$v80071f37861c360a27b7327e132c911a} {$v056301054c43f8bbea2090debfec16b1}"; $vef5714e0519bfaa645cdff7d28843b70->usedContentTables[] = $v056301054c43f8bbea2090debfec16b1; } $v64df937f321ebd648bc77b99cf76cb38 = $v056301054c43f8bbea2090debfec16b1 . ".obj_id = o.id AND " . $v056301054c43f8bbea2090debfec16b1 . ".field_id = '" . $v0f728ec6147eaec54f5f45e37bce8ddd . "'"; if ($v1abd88b57ac7e290b6c91d26b0909006 != 'optioned') { $v4cdef984848c418ea8a3c646e5852e32 = $v056301054c43f8bbea2090debfec16b1 . "." . $v1abd88b57ac7e290b6c91d26b0909006; } switch ($vf642bf0e4102797f994548b9f4ee9e4a) { case 'equal': if ($v01aaeba75d696598feafcb0226fdb7e9) { if (!is_array($v01aaeba75d696598feafcb0226fdb7e9)) { $v01aaeba75d696598feafcb0226fdb7e9 = array($v01aaeba75d696598feafcb0226fdb7e9); } $v3a0317e07571e01889f5f6982960cc2a = "'" . implode("', '", array_map('l_mysql_real_escape_string', $v01aaeba75d696598feafcb0226fdb7e9)) . "'"; $vf92fcd26dc4ba92f75934707ad0917d9 = "(" . $v64df937f321ebd648bc77b99cf76cb38 . " AND (" . $v4cdef984848c418ea8a3c646e5852e32 . " IN (" . $v3a0317e07571e01889f5f6982960cc2a . ")))"; } else { $v01aaeba75d696598feafcb0226fdb7e9 = l_mysql_real_escape_string($v01aaeba75d696598feafcb0226fdb7e9); $vf92fcd26dc4ba92f75934707ad0917d9 = "({$v64df937f321ebd648bc77b99cf76cb38} AND ({$v4cdef984848c418ea8a3c646e5852e32} = '{$v01aaeba75d696598feafcb0226fdb7e9}' OR {$v4cdef984848c418ea8a3c646e5852e32} IS NULL))"; } break; case 'not_equal': if (!is_array($v01aaeba75d696598feafcb0226fdb7e9)) { $v01aaeba75d696598feafcb0226fdb7e9 = array($v01aaeba75d696598feafcb0226fdb7e9); } $v3a0317e07571e01889f5f6982960cc2a = "'" . implode("', '", array_map('l_mysql_real_escape_string', $v01aaeba75d696598feafcb0226fdb7e9)) . "'"; $vf92fcd26dc4ba92f75934707ad0917d9 = "(" . $v64df937f321ebd648bc77b99cf76cb38 . " AND ((" . $v4cdef984848c418ea8a3c646e5852e32 . " IS NULL) OR (" . $v4cdef984848c418ea8a3c646e5852e32 . " NOT IN (" . $v3a0317e07571e01889f5f6982960cc2a . "))))"; break; case 'like': $vb6c8416e95a754076b10d65d1afd3fa9 = true; if (substr($v01aaeba75d696598feafcb0226fdb7e9, 0, 1) === '%' || substr($v01aaeba75d696598feafcb0226fdb7e9, -1) === '%') { $vb6c8416e95a754076b10d65d1afd3fa9 = false; } $vf578b860df8544c8f826f66977b6e908 = l_mysql_real_escape_string($v01aaeba75d696598feafcb0226fdb7e9); $vf92fcd26dc4ba92f75934707ad0917d9 = "(" . $v64df937f321ebd648bc77b99cf76cb38 . " AND " . $v4cdef984848c418ea8a3c646e5852e32 . " LIKE '" . ($vb6c8416e95a754076b10d65d1afd3fa9 ? "%" : "") . $vf578b860df8544c8f826f66977b6e908 . ($vb6c8416e95a754076b10d65d1afd3fa9 ? "%" : "") . "')"; break; case 'between': $v17fdfd1db155ff501f9553066c50cdab = isset($v5cba202deaa7e9f47bd0317cf014c64b['min']) ? floatval($v5cba202deaa7e9f47bd0317cf014c64b['min']) : 0; $v3a86ffe4f7adcc1fe1457ada5ec034b0 = isset($v5cba202deaa7e9f47bd0317cf014c64b['max']) ? floatval($v5cba202deaa7e9f47bd0317cf014c64b['max']) : 0; $vf92fcd26dc4ba92f75934707ad0917d9 = "(" . $v64df937f321ebd648bc77b99cf76cb38 . " AND " . $v4cdef984848c418ea8a3c646e5852e32 . " BETWEEN '" . $v17fdfd1db155ff501f9553066c50cdab . "' AND '" . $v3a86ffe4f7adcc1fe1457ada5ec034b0 . "')"; break; case 'more': $v6ec037ff2ad4d8e71e8a10efa0ba90ba = floatval($v01aaeba75d696598feafcb0226fdb7e9); $vf92fcd26dc4ba92f75934707ad0917d9 = "(" . $v64df937f321ebd648bc77b99cf76cb38 . " AND " . $v4cdef984848c418ea8a3c646e5852e32 . " >= '" . $v6ec037ff2ad4d8e71e8a10efa0ba90ba . "')"; break; case 'less': $v6ec037ff2ad4d8e71e8a10efa0ba90ba = floatval($v01aaeba75d696598feafcb0226fdb7e9); $vf92fcd26dc4ba92f75934707ad0917d9 = "(" . $v64df937f321ebd648bc77b99cf76cb38 . " AND " . $v4cdef984848c418ea8a3c646e5852e32 . " <= '" . $v6ec037ff2ad4d8e71e8a10efa0ba90ba . "')"; break; case 'null': $vf92fcd26dc4ba92f75934707ad0917d9 = "(" . $v64df937f321ebd648bc77b99cf76cb38 . " AND " . $v4cdef984848c418ea8a3c646e5852e32 . " IS NULL)"; break; case 'notnull': $vf92fcd26dc4ba92f75934707ad0917d9 = "(" . $v64df937f321ebd648bc77b99cf76cb38 . " AND " . $v4cdef984848c418ea8a3c646e5852e32 . " IS NOT NULL)"; break; default: $vf92fcd26dc4ba92f75934707ad0917d9 = ""; break; } if (strlen($vf92fcd26dc4ba92f75934707ad0917d9)) { $vef5714e0519bfaa645cdff7d28843b70->sql_arr_for_and_or_part['where'][] = $vf92fcd26dc4ba92f75934707ad0917d9; } } if (count($vef5714e0519bfaa645cdff7d28843b70->sql_arr_for_and_or_part)) { $vef5714e0519bfaa645cdff7d28843b70->sql_cond__need_content = true; $vef5714e0519bfaa645cdff7d28843b70->sql_cond__total_joins += $v865c0c0b4ab0e063e5caa3387c1a8741; } } } }