javascript - Google table 100 在 10 之前，8 在最后

Question

我使用 Google 表格。如 img 1 所示，当我按从 10 到 99 的数字对它进行排序时，它的顺序很好。

--- IMG 1 ----

但是当我使用一位数字 1-9 或超过 100 时，它的排序并不像您在 img 2 中看到的那样很好。

---- IMG 2 ----

我该如何解决这个问题？

我使用以下代码。

<script type='text/javascript'>
google.load('visualization', '1', {packages:['table']});
google.setOnLoadCallback(drawTable);
function drawTable() {
    var data = new google.visualization.DataTable();
    data.addColumn('string', 'ID');
    data.addColumn('string', 'Name');
    data.addColumn('string', 'Image');
    data.addColumn('string', 'Image Size');
    data.addColumn('string', 'Order');
    data.addColumn('string', 'Status');
    data.addColumn('string', 'Actions');
    data.addRows([
<?php
if (count($slideshow))
{
    foreach($slideshow as $item)
    {
        $namelink = anchor("$module/admin/edit/".$item['id'],$item['name']);
        $subject = $item['image'];
        $imagename = getImageName($subject);
        $imagepath = getImagePath($subject);
        $filepath = base_url().$imagepath;
        $imagecont = "<img width=\"70px\" src=\'".$filepath."\' />";
        $filesize = getimagesize($imagepath);
        $filesizecont = "width: ".$filesize[0]. "px<br />height: ".$filesize[1]. "px";
        $item = str_replace("'", "\'", $item);
        /* $public_icon = ($item['public']==1 ? 'tick':'cross'); */
        /* $publiclink = anchor("kaimonokago/admin/changecatBooleanStatus/$module/".$item['id']."/public",$this->bep_assets->icon($public_icon), array('class' => $item['public']. ' changestatus')); */
        $active_icon = ($item['status']=='active'?'tick':'cross');
        $statuslink = anchor("kaimonokago/admin/changeStatus/$module/".$item['id'],$this->bep_assets->icon($active_icon), array('class' => $item['status']. ' changestatus'));
        $editlink = anchor($module.'/admin/edit/'.$item['id'],$this->bep_assets->icon('pencil'));
        if ($item['status']=='inactive')
        {
            $deletelink = anchor('kaimonokago/admin/delete/'.$module.'/'.$item['id'],$this->bep_assets->icon('delete'), array("class" => "delete_link","onclick"=>"return confirmSubmit(\'".$item['name']."\')"));
        }
        else
        {
            $deletelink ='';
        }
        //$link = "testing";  
        echo "['".$item['id']."','".$namelink."','".$imagecont."','".$filesizecont."','".$item['slide_order']."','".$statuslink."','".$editlink.$deletelink."' ],\n";
    }
}
?>
]);

var table = new google.visualization.Table(document.getElementById('table_div'));
table.draw(data, {showRowNumber: true, allowHtml:true,width:'100%'});
}
</script>
 <div id='table_div'></div>
<script>
$(window).resize(function(){
    drawTable();
});
</script>

Answer 1

由于这一行，您的订单被排序为字符串:

data.addColumn('string', 'Order');

这需要更改以使订单按数字排序:

data.addColumn('number', 'Order');

More information