private static function makeOrderPart(umiSelection $vef5714e0519bfaa645cdff7d28843b70) { $vc7f62b660bf9e56e6df63ef3d2540a77 = $vef5714e0519bfaa645cdff7d28843b70->getOrderConds(); if ($vc7f62b660bf9e56e6df63ef3d2540a77) { $v865c0c0b4ab0e063e5caa3387c1a8741 = 0; $vef5714e0519bfaa645cdff7d28843b70->sql_order_by = " ORDER BY "; $v7dabf5c198b0bab2eaa42bb03a113e55 = sizeof($vc7f62b660bf9e56e6df63ef3d2540a77); for ($v865c0c0b4ab0e063e5caa3387c1a8741 = 0; $v865c0c0b4ab0e063e5caa3387c1a8741 < $v7dabf5c198b0bab2eaa42bb03a113e55; $v865c0c0b4ab0e063e5caa3387c1a8741++) { if ($v11537f7c46ecc6ae45e5497ea0aec6bf = $vc7f62b660bf9e56e6df63ef3d2540a77[$v865c0c0b4ab0e063e5caa3387c1a8741]['native_field']) { switch ($v11537f7c46ecc6ae45e5497ea0aec6bf) { case "name": $vef5714e0519bfaa645cdff7d28843b70->sql_order_by .= "o.name " . ($vc7f62b660bf9e56e6df63ef3d2540a77[$v865c0c0b4ab0e063e5caa3387c1a8741]['asc'] ? "ASC" : "DESC"); $vef5714e0519bfaa645cdff7d28843b70->sql_need_object_table = true; $vef5714e0519bfaa645cdff7d28843b70->objectTableIsRequired = true; break; case "object_id": $vef5714e0519bfaa645cdff7d28843b70->sql_order_by .= "o.id " . ($vc7f62b660bf9e56e6df63ef3d2540a77[$v865c0c0b4ab0e063e5caa3387c1a8741]['asc'] ? "ASC" : "DESC"); $vef5714e0519bfaa645cdff7d28843b70->objectTableIsRequired = true; break; case "rand": $vef5714e0519bfaa645cdff7d28843b70->sql_order_by .= "RAND()"; break; case "ord": if ($vef5714e0519bfaa645cdff7d28843b70->objectTableIsRequired && !$vef5714e0519bfaa645cdff7d28843b70->sql_cond__need_hierarchy) { $vef5714e0519bfaa645cdff7d28843b70->sql_order_by .= "o.ord " . ($vc7f62b660bf9e56e6df63ef3d2540a77[$v865c0c0b4ab0e063e5caa3387c1a8741]['asc'] ? "ASC" : "DESC"); } else { $vef5714e0519bfaa645cdff7d28843b70->sql_order_by .= "h.ord " . ($vc7f62b660bf9e56e6df63ef3d2540a77[$v865c0c0b4ab0e063e5caa3387c1a8741]['asc'] ? "ASC" : "DESC"); } break; } if ($v865c0c0b4ab0e063e5caa3387c1a8741 !== $v7dabf5c198b0bab2eaa42bb03a113e55 - 1) { $vef5714e0519bfaa645cdff7d28843b70->sql_order_by .= ", "; } } else { $vef5714e0519bfaa645cdff7d28843b70->sql_cond__need_content = true; $v056301054c43f8bbea2090debfec16b1 = "c" . ++$vef5714e0519bfaa645cdff7d28843b70->sql_cond__content_tables_loaded; $v80071f37861c360a27b7327e132c911a = self::chooseContentTableName($vef5714e0519bfaa645cdff7d28843b70, $vc7f62b660bf9e56e6df63ef3d2540a77[$v865c0c0b4ab0e063e5caa3387c1a8741]['field_id']); $vef5714e0519bfaa645cdff7d28843b70->sql_part__content_tables .= ", {$v80071f37861c360a27b7327e132c911a} {$v056301054c43f8bbea2090debfec16b1}"; $vef5714e0519bfaa645cdff7d28843b70->usedContentTables[] = $v056301054c43f8bbea2090debfec16b1; $vef5714e0519bfaa645cdff7d28843b70->sql_arr_for_and_or_part['order'][] = "{$v056301054c43f8bbea2090debfec16b1}.obj_id = o.id AND {$v056301054c43f8bbea2090debfec16b1}.field_id = '{$vc7f62b660bf9e56e6df63ef3d2540a77[$v865c0c0b4ab0e063e5caa3387c1a8741]['field_id']}'"; $vef5714e0519bfaa645cdff7d28843b70->sql_order_by .= "{$v056301054c43f8bbea2090debfec16b1}.{$vc7f62b660bf9e56e6df63ef3d2540a77[$v865c0c0b4ab0e063e5caa3387c1a8741]['type']} " . ($vc7f62b660bf9e56e6df63ef3d2540a77[$v865c0c0b4ab0e063e5caa3387c1a8741]['asc'] ? "ASC" : "DESC"); if ($v865c0c0b4ab0e063e5caa3387c1a8741 == $v7dabf5c198b0bab2eaa42bb03a113e55 - 1) { } else { $vef5714e0519bfaa645cdff7d28843b70->sql_order_by .= ", "; } } } if ($vef5714e0519bfaa645cdff7d28843b70->sql_order_by == " ORDER BY ") { $vef5714e0519bfaa645cdff7d28843b70->sql_order_by = ""; } $vef5714e0519bfaa645cdff7d28843b70->sql_cond__total_joins += $v865c0c0b4ab0e063e5caa3387c1a8741; } elseif ($vef5714e0519bfaa645cdff7d28843b70->sql_cond__need_hierarchy == true) { $vef5714e0519bfaa645cdff7d28843b70->sql_order_by = " ORDER BY h.ord"; } }