| 总排名 | 款号 | 颜色 | 单价（元） | 我的排名 | 我的件数 | 吊牌金额 | ";
$order_ph=($s_desc=="d1")?" desc":"";
//取得款号总数
$tmp=get_db_msg("select count(distinct no,color) 'num' from ".$table_pre."ph where no<>'' ".$con);
$total_kh=$tmp["num"];
//取得我的排行
$arr_my_ph_num=array();
$q1="select sum(num) 'num',sum(je) 'je' from ".$table_pre."order where uid='".$uid."' ".$con." group by no,color order by ".$s_order." desc";
$r1=$db->query($q1);
while($m1=$db->fetch_array($r1)){
$arr_my_ph_num[]=$m1["num"];
}
$arr_my_ph_num=array_unique($arr_my_ph_num);
//
$q="select iid,no,color,sum(num),sum(je) from ".$table_pre."ph where num>0 ".$con." group by no,color order by ".$s_order.$order_ph." limit 0,".$kh_ph_num;
//echo $q."
";
$r=$db->query($q);
$total_num=$total_money=$count=0;
$count_my=$count_total=0;
while($m=$db->fetch_array($r)){
$bg=($count%2)?"#333333":"#444444";
if($s_desc=="d1")
$list=$count+1;
else
$list=$total_kh+$count;
$m1=get_db_msg("select * from ".$table_pre."kh where id='".$m["iid"]."'");
$num_my=get_order_num_kh_color($m1["id"],$m["color"]);
$total_num+=$num_my;
$money_my=$m1["price"]*$num_my;
$total_money+=$money_my;
$ph_my="";
if($num_my>0){
$ph_my=get_main_key($arr_my_ph_num,$num_my);
$ph_my++;
$count_my++;
}
$content.="| ".$list." | ".get_kh_xh($m1,$m["color"])."#".$m1["no"]." | ".$m["color"]."-".get_cate_title_no("color",$m["color"])." | ".$m1["price"]." | ".$ph_my." | ".$num_my." | ".$money_my." | ";
if($s_desc=="d1")
$count++;
else
$count--;
$count_total++;
}
$content.="| 合计 | ".deel_bfb1($count_my,$count_total,1)." | ".$total_num." | ".$total_money." |
|