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; ?>