[Vtigercrm-developers] 回复： How to support the chinese sort

[sunny]

because chinese use hieroglyphic，for example '李' ，which can spell 'Li','陈' spell 'chen',chinese use character 
GBK,not utf-8,here have a code get the first getFirstCharter,
 /**
     * 取汉字的第一个字的首字母
     * @param type $str
     * @return string|null
     */
    public function _getFirstCharter($str){
	if(empty($str)){return '';}
	$fchar=ord($str{0});
	if($fchar>=ord('A')&&$fchar<=ord('z')) return strtoupper($str{0});
	$s1=iconv('UTF-8','gb2312',$str);
	$s2=iconv('gb2312','UTF-8',$s1);
	$s=$s2==$str?$s1:$str;
	$asc=ord($s{0})*256+ord($s{1})-65536;
	if($asc>=-20319&&$asc<=-20284) return 'A';
	if($asc>=-20283&&$asc<=-19776) return 'B';
	if($asc>=-19775&&$asc<=-19219) return 'C';
	if($asc>=-19218&&$asc<=-18711) return 'D';
	if($asc>=-18710&&$asc<=-18527) return 'E';
	if($asc>=-18526&&$asc<=-18240) return 'F';
	if($asc>=-18239&&$asc<=-17923) return 'G';
	if($asc>=-17922&&$asc<=-17418) return 'H';
	if($asc>=-17417&&$asc<=-16475) return 'J';
	if($asc>=-16474&&$asc<=-16213) return 'K';
	if($asc>=-16212&&$asc<=-15641) return 'L';
	if($asc>=-15640&&$asc<=-15166) return 'M';
	if($asc>=-15165&&$asc<=-14923) return 'N';
	if($asc>=-14922&&$asc<=-14915) return 'O';
	if($asc>=-14914&&$asc<=-14631) return 'P';
	if($asc>=-14630&&$asc<=-14150) return 'Q';
	if($asc>=-14149&&$asc<=-14091) return 'R';
	if($asc>=-14090&&$asc<=-13319) return 'S';
	if($asc>=-13318&&$asc<=-12839) return 'T';
	if($asc>=-12838&&$asc<=-12557) return 'W';
	if($asc>=-12556&&$asc<=-11848) return 'X';
	if($asc>=-11847&&$asc<=-11056) return 'Y';
	if($asc>=-11055&&$asc<=-10247) return 'Z';
	return null;
    }


and how to use


 //门店名称
            $shopData = $this->_shopNamesArray;  
            
            //根据门店名称第一个汉字的首字母正序排序
            $settles = $result['data'];
       
            $settlesRes = array();
            foreach ($settles as $sett) {
                $sname = $shopData[$sett['sid']];
                $sett['sname'] = $sname;  
                $snameFirstChar = $this->_getFirstCharter($sname); //取出门店的第一个汉字的首字母
                $settlesRes[$snameFirstChar] = $sett;//以这个首字母作为key
            }            
            ksort($settlesRes); //对数据进行ksort排序，以key的值升序排序
                


_shopNamesArray


Array
(
    [0] => Array
        (
            [sid] => 2885842
            [recetcstoredpay] => 24000
            [recetclprinciple] => 23465
            [paytcstoredpay] => 5455
            [paytclprinciple] => 34900
            [sname] => 百宴餐饮---便宜坊烤鸭店
        )


    [1] => Array
        (
            [sid] => 3644191
            [recetcstoredpay] => 89200
            [recetclprinciple] => 406930
            [paytcstoredpay] => 4090
            [paytclprinciple] => 97800
            [sname] => 大长秋餐饮中心
        )


    [2] => Array
        (
            [sid] => 5229673
            [recetcstoredpay] => 26000
            [recetclprinciple] => 45930
            [paytcstoredpay] => 24795
            [paytclprinciple] => 121800
            [sname] => 大众点评网
        )


    [3] => Array
        (
            [sid] => 3715927
            [recetcstoredpay] => 13600
            [recetclprinciple] => 56930
            [paytcstoredpay] => 5710
            [paytclprinciple] => 37800
            [sname] => 江东北路店
        )


    [4] => Array
        (
            [sid] => 3671092
            [recetcstoredpay] => 1280
            [recetclprinciple] => 46930
            [paytcstoredpay] => 128090
            [paytclprinciple] => 149800
            [sname] => 金凤区新馆
        )


    [5] => Array
        (
            [sid] => 1858783
            [recetcstoredpay] => 2040
            [recetclprinciple] => 4465
            [paytcstoredpay] => 245
            [paytclprinciple] => 4900
            [sname] => 浙江西子宾馆
        )


    [6] => Array
        (
            [sid] => 16832117
            [recetcstoredpay] => 81600
            [recetclprinciple] => 470930
            [paytcstoredpay] => 506090
            [paytclprinciple] => 8000
            [sname] => 欢乐谷店
        )


)





------------------ 原始邮件 ------------------
发件人: "Uma S";<uma.s at vtiger.com>;
发送时间: 2015年6月1日(星期一) 中午1:21
收件人: "vtigercrm-developers"<vtigercrm-developers at lists.vtigercrm.com>; 

主题: Re: [Vtigercrm-developers] How to support the chinese sort



Hi,

Sorting in list-view should work irrespective of language translations right? Can you please let us know what's the issue you are facing with chinese characters?


On Mon, Jun 1, 2015 at 7:55 AM, sunny <1250572980 at qq.com> wrote:


We want to support the chinese sort in the list view,following:
when click the red Letter，the CRM system can sort by alphabet.
because our chinese use the same letters for the chinese ，or we can translate the chinese to the english letters,but I do not know this sort how to set up,or where to set up ,or which php file control the sort?


_______________________________________________
 http://www.vtiger.com/





-- 
With
Best Regards
Uma.S
Vtiger Team
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150601/ee148de6/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 09096252 at 4050D10D.D5096C55
Type: application/octet-stream
Size: 55521 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150601/ee148de6/attachment-0001.obj>