query($q);
$total_num=$total_money=$total_zb=$count=$total_wc=0;
$tmp_sql="";
if($is_spk=="y")
$tmp_sql=" and is_sp<>'y'";
while($m=$db->fetch_array($r)){
$sty1=($count%2)?"td2":"td1";
$list=$count+1;
$m_yd=get_db_msg("select sum(jsje) 'jsje',sum(num) 'num' from ".$table_pre."order where uid='".$uid."' and ka<>'y' and brand='".$m["brand"]."' and _key='".$_key."'".$tmp_sql);
$total_num+=$m_yd["num"];
$total_money+=$m_yd["jsje"];
if(in_array("je",$arr_zb_type)){
$zb=$m["zb"]*10000;
$wc_yd=$m_yd["jsje"];
}else{
$zb=$m["zb_js"];
$wc_yd=$m_yd["num"];
}
$total_rw+=$zb;
$total_wc+=$wc_yd;
if($m["is_checked"]!="y" && $m["is_jd"]!="y" && $show_jd=="y"){
$button_jd="&jd2=y&s_brand=".$m["brand"]."";
}
else
$button_jd="";
$count++;
$json_data1.="[\"".get_cate_title_no("brand",$m["brand"])."|||".$button_jd."\",\"".$m_yd["num"]."\",\"".deel_num($m_yd["jsje"])."\",\"".$zb."\",\"".deel_bfb1($wc_yd,$zb,1)."\",\"".get_client_state($m["is_jd"],$m["is_checked"])."\"],";
}
//合计
$json_data.="\"table_mid\":[".substr($json_data1,0,-1)."],";
$json_data.="\"table_hj\":[\"合计\",\"".$total_num."\",\"".deel_num($total_money)."\",\"".$total_rw."\",\"".deel_bfb1($total_wc,$total_rw,1)."\",\" \"],";
//$json_data.="\"code\":1";
break;
}
$json_data=substr($json_data,0,-1)."}";
echo $json_data;
?>