{"id":179,"date":"2022-06-29T10:36:54","date_gmt":"2022-06-29T02:36:54","guid":{"rendered":"http:\/\/yanzhenhua.top\/?p=179"},"modified":"2022-06-29T10:36:54","modified_gmt":"2022-06-29T02:36:54","slug":"pg%e6%95%b0%e6%8d%ae%e5%ba%93%e8%81%94%e7%b3%bb%e4%ba%ba%e6%8c%89%e6%8b%bc%e9%9f%b3%e9%a6%96%e5%ad%97%e6%af%8da-z%e6%8e%92%e5%ba%8f","status":"publish","type":"post","link":"http:\/\/yanzhenhua.top\/?p=179","title":{"rendered":"pg\u6570\u636e\u5e93\u8054\u7cfb\u4eba\u6309\u62fc\u97f3\u9996\u5b57\u6bcda-z\u6392\u5e8f"},"content":{"rendered":"<div class=\"line number1 index0 alt2\">\n<p class=\"md-end-block md-p\">1.\u4e2d\u6587\u6309\u62fc\u97f3\u6392\u5e8f\u95ee\u9898<\/p>\n<div class=\"code panel pdl conf-macro output-block\" data-hasbody=\"true\" data-macro-name=\"code\">\n<div class=\"codeContent panelContent pdl\">\n<div>\n<div id=\"highlighter_443080\" class=\"syntaxhighlighter sh-confluence nogutter  ruby\">\n<table style=\"height: 185px;\" border=\"0\" width=\"948\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"code\">\n<div class=\"container\" title=\"Hint: double-click to select code\">\n<div class=\"line number1 index0 alt2\"><code class=\"ruby comments\">#\u8054\u7cfb\u4eba\u6309a-z\u6392\u5e8f<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"ruby comments\">#\u65e7\u7684\u65b9\u6cd5\u6709\u95ee\u9898 pg\u6570\u636e\u5e93\u6309gbk\u6392\u5e8f\u6709\u95ee\u9898 \u95eb\u3001\u8c2d\u7b49\u6392\u5728\u6700\u4e0b\u8fb9<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"ruby plain\">data.order(<\/code><code class=\"ruby string\">\"convert_to(crm_contacts.l_last_name,'GBK'),convert_to(crm_contacts.l_first_name,'GBK')\"<\/code><code class=\"ruby plain\">)<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"ruby comments\">#\u65b0\u7684\u65b9\u6cd5\u8fd9\u4e2a\u6bd4\u8f83\u597d\u7528 order by value collate \"zh_CN.utf8\"<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"ruby plain\">data = data.order(\"<\/code><code class=\"ruby constants\">CASE<\/code>\u00a0<code class=\"ruby constants\">WHEN<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"ruby plain\">length(concat_ws(<\/code><code class=\"ruby string\">''<\/code><code class=\"ruby plain\">,crm_contacts.l_last_name,crm_contacts.l_first_name))&gt;<\/code><code class=\"ruby constants\">0<\/code>\u00a0<code class=\"ruby constants\">THEN<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"ruby plain\">concat_ws(<\/code><code class=\"ruby string\">''<\/code><code class=\"ruby plain\">,crm_contacts.l_last_name,crm_contacts.l_first_name) collate \\<\/code><code class=\"ruby string\">\"zh_CN.utf8\\\" END\"<\/code><code class=\"ruby plain\">)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p class=\"md-end-block md-p\"><code><span class=\"c1\">2.find(id) \u5982\u679c\u627e\u4e0d\u5230\u6570\u636e\u4f1a\u62a5\u9519\uff0c find_by_id(id)\u627e\u4e0d\u5230\u6570\u636e\u8fd4\u56denil<\/span><\/code><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>1.\u4e2d\u6587\u6309\u62fc\u97f3\u6392\u5e8f\u95ee\u9898 #\u8054\u7cfb\u4eba\u6309a-z\u6392\u5e8f #\u65e7\u7684\u65b9\u6cd5\u6709\u95ee\u9898 pg\u6570\u636e\u5e93\u6309gbk\u6392\u5e8f\u6709\u95ee\u9898 \u95eb\u3001\u8c2d&hellip; <a href=\"http:\/\/yanzhenhua.top\/?p=179\" class=\"more-link read-more\" rel=\"bookmark\">\u7ee7\u7eed\u9605\u8bfb <span class=\"screen-reader-text\">pg\u6570\u636e\u5e93\u8054\u7cfb\u4eba\u6309\u62fc\u97f3\u9996\u5b57\u6bcda-z\u6392\u5e8f<\/span><i class=\"fa fa-arrow-right\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,6],"tags":[],"class_list":{"0":"post-179","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-pgsql","7":"category-ruby","8":"h-entry","10":"h-as-article"},"_links":{"self":[{"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=\/wp\/v2\/posts\/179","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=179"}],"version-history":[{"count":1,"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=\/wp\/v2\/posts\/179\/revisions"}],"predecessor-version":[{"id":180,"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=\/wp\/v2\/posts\/179\/revisions\/180"}],"wp:attachment":[{"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=179"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}