0){ //店铺查询条件 $con=""; if($msg_client["face"]=="4"){ $s_username=$msg_client["username"]; $con=" and uid='".$msg_client["id"]."'"; }else{ if($s_username){ $m2=get_db_msg("select id,face,path from ".$table_pre."client where username='".$s_username."'"); if($m2["face"]=="4"){ $con=" and uid='".$m2["id"]."'"; }else{ $con=" and (upath='".$m2["path"]."-".$m2["id"]."' or upath like '".$m2["path"]."-".$m2["id"]."-%')"; } }else if($msg_client["face"]=="2"){ //区经角色所有客户 $con=get_qj_ucon_all($msg_client["charge_path_real"]); }else{ //代理角色所有客户 $con=" and (upath='".$msg_client["path"]."-".$msg_client["id"]."' or upath like '".$msg_client["path"]."-".$msg_client["id"]."-%')"; } } $zd_title1=get_main_value($sys_color_zd,$zd1); $content_data.=""; //表头第一行 $content_data.=""; $content_data.=""; $content_data.=""; //表头第二行 $content_data.=""; $content_data.=""; $content_data.=""; $content_data.=""; //-----------取得报表数据 //取得总设计款色数 $tmp=get_db_msg("select count(*) 'num' from ".$table_pre."kh_color where ka<>'y'"); $total_sj_kss=$tmp["num"]; //取得订单总数 $tmp=get_db_msg("select sum(num) 'js',sum(je) 'je',count(distinct iid,color) 'kss' from ".$table_pre."order where ka<>'y' ".$con); $total_yd_kss=$tmp["kss"]; $total_yd_js=$tmp["js"]; $total_yd_je=$tmp["je"]; //--------------------输出报表----------------------------------------------- $content_data.=""; $q1="select a.".$zd1.",count(*) 'ks',a.iid,a.color from ".$table_pre."kh_color a,".$table_pre."kh b where a.iid=b.id group by a.".$zd1." order by a.".$zd1; //echo $q1."
"; $r1=$db->query($q1); $tb_data=""; while($m1=$db->fetch_array($r1)){ //取得订单数据 $m2=get_db_msg("select sum(num) 'js', sum(je) 'je',count(distinct iid,color) 'kss' from ".$table_pre."order where concat(iid,'-',color) in (select concat(a.iid,'-',a.color) from ".$table_pre."kh_color a,".$table_pre."kh b where a.iid=b.id and a.".$zd1."='".$m1[$zd1]."') ".$con); $content_data.=""; $content_data.=""; $content_data.=""; //记录图表数据 $tb_data.=$m1[$zd1]."|".str_replace("%","",deel_bfb($m2["js"],$total_yd_js)).","; } $content_data.=""; $content_data.=""; $content_data.="
".$zd_title1."设计款数已订款数已订件数已订金额
款数占比款数占比件数占比金额占比
".$m1[$zd1]."".deel_td(deel_0($m1["ks"]))."".deel_bfb($m1["ks"],$total_sj_kss)."".deel_td(deel_0($m2["kss"]))."".deel_bfb($m2["kss"],$total_yd_kss)."".deel_td(deel_0($m2["js"]))."".deel_bfb($m2["js"],$total_yd_js)."".deel_td(deel_0(deel_num($m2["je"])))."".deel_bfb($m2["je"],$total_yd_je)."
合计".deel_td(deel_0($total_sj_kss))."100%".deel_td(deel_0($total_yd_kss))."100%".deel_td(deel_0($total_yd_js))."100%".deel_td(deel_0(deel_num($total_yd_je)))."100%
"; }else{ $content_data="
请先配置tmpl/config.php中的sys_color_zd参数!
"; } $json_data.="\"table_html\":\"".$content_data."\","; ?>