打印报价格，如何按货号进行排序

2016-07-07 14:55 来源：www.chinab4c.com 作者：ecshop专家

我在打印报价格页增加了产品图片和货号，但排序很乱。qutoation.php的查询语名中哪里修改排序的。

回答：
有知道的吗？在线等。不知道修改哪里是排序的。
  1. $sql = "SELECT g.goods_sn, g.goods_id, g.goods_thumb, g.goods_name,g.shop_price, g.goods_number, c.cat_name AS goods_category,p.product_sn,p.product_number,p.goods_attr".

  3. " FROM " . $ecs->table('goods') . " AS g LEFT JOIN " . $ecs->table('category') . " AS c ON g.cat_id = c.cat_id LEFT JOIN ".$ecs->table('products')."as pOn g.goods_id=p.goods_id" . $where . " AND is_on_sale = 1 AND is_alone_sale = 1 ";

  5. $goods_list = $db->getAll($sql);



  9. foreach($goods_list as $key=>$val)

  11. {

  13. if(!empty($val['product_id']))

  15. {
  16. $goods_list[$key]['goods_thumb']=$val['product_thumb'];
  17. $goods_list[$key]['goods_sn']=$val['product_sn'];
  18. $goods_list[$key]['goods_number']=$val['product_number'];

  20. $product_info=product_info($val['goods_attr'],$val['goods_id']);

  22. $goods_list[$key]['members_price']= $val['shop_price'];

  24. $goods_list[$key]['shop_price'] += $product_info['attr_price'];

  26. $goods_list[$key]['product_name']=$product_info['attr_value'];

  28. $goods_list[$key]['attr_price']=$product_info['attr_price'];

  30. }

  32. else

  34. {

  36. $goods_list[$key]['members_price']= $val['shop_price'];

  38. $goods_list[$key]['product_name']=' ';

  40. $goods_list[$key]['product_price']=0;

  42. }

  44. $goods_list[$key]['goods_key']=$key;

  46. }

  48. $user_rank = $db->getAll("SELECT * FROM " .$ecs->table('user_rank') . "WHERE show_price = 1 OR rank_id = '$_SESSION[user_rank]'");

  50. $rank_point = 0;

  52. if (!empty($_SESSION['user_id']))

  54. {

  56. $rank_point = $db->getOne("SELECT rank_points FROM " . $ecs->table('users') . " WHERE user_id = '$_SESSION[user_id]'");

  58. }

  60. $user_rank = calc_user_rank($user_rank, $rank_point);

  62. $user_men = serve_user($goods_list);

  64. $smarty->assign('extend_price', $user_rank['ext_price']);

  66. $smarty->assign('extend_rank', $user_men);

  68. $smarty->assign('goods_list', $goods_list);



  72. $html = $smarty->fetch('quotation_print.html');

  74. exit($html);

  76. }
复制代码

order by goods_sn

优品诚专业的电子商务二开供应商，解决您一切针对ecshop相关的需求，主机，模板，功能定制的问题，价格透明，质量保证。

具体可以联系我们的在线客服人员，QQ：2397358844544350711
也可通过邮件方式与我们取得联系upincheng@gmail.com
或者到我们的官网上进行留言www.upin99.com