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_cate_title_no("arr_select",$zd1); $zd_title2=get_main_value($sys_color_zd,$zd2); //取得选项 $arr_zd1=array(); $q="select * from ".$table_pre."keyword where cate='".$zd1."' order by no"; $r=$db->query($q); while($m=$db->fetch_array($r)){ $arr_zd1[$m["no"]]=$m["title"]; } $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"]; //取得小计设计款色数 $arr_design_data=array(); $q1="select b.".$zd1.",count(a.color) as num from ".$table_pre."kh b,".$table_pre."kh_color a where b.ka<>'y' and b.id=a.iid group by b.".$zd1; $r1=$db->query($q1); $arr_design_data=array(); while($m1=$db->fetch_array($r1)){ $arr_design_data[$m1[$zd1]]=$m1["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"]; //取得小计订单数据 $arr_order_data=array(); $q3="select sum(num) 'js', sum(je) 'je',count(distinct iid,color) 'kss',".$zd1." from ".$table_pre."order where ka<>'y' ".$con." group by ".$zd1; $r3=$db->query($q3); $arr_order_ksdata=array(); while($m3=$db->fetch_array($r3)){ $arr_order_data[$m3[$zd1]]=array($m3["kss"],$m3["js"],$m3["je"]); } //--------------------输出报表----------------------------------------------- $content_data.=""; foreach($arr_zd1 as $k1 => $v1){ $q1="select a.".$zd2.",count(*) 'ks',a.iid,a.color from ".$table_pre."kh_color a,".$table_pre."kh b where a.iid=b.id and b.".$zd1."='".$k1."' group by a.".$zd2." order by a.".$zd2; //echo $q1."
"; $r1=$db->query($q1); 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 b.".$zd1."='".$k1."' and a.".$zd2."='".$m1[$zd2]."') ".$con); $content_data.=""; $content_data.=""; $content_data.=""; } //小计 $content_data.=""; $content_data.=""; $content_data.=""; } $content_data.=""; $content_data.=""; $content_data.="
".$zd_title1."".$zd_title2."设计款数已订款数已订件数已订金额
款数占比款数占比件数占比金额占比
".$v1."".$m1[$zd2]."".deel_td(deel_0($m1["ks"]))."".deel_bfb($m1["ks"],$arr_design_data[$k1])."".deel_td(deel_0($m2["kss"]))."".deel_bfb($m2["kss"],$arr_order_data[$k1][0])."".deel_td(deel_0($m2["js"]))."".deel_bfb($m2["js"],$arr_order_data[$k1][1])."".deel_td(deel_0(deel_num($m2["je"])))."".deel_bfb($m2["je"],$arr_order_data[$k1][2])."
".$v1."小计".deel_td(deel_0($arr_design_data[$k1]))."".deel_bfb($arr_design_data[$k1],$total_sj_kss)."".deel_td(deel_0($arr_order_data[$k1][0]))."".deel_bfb($arr_order_data[$k1][0],$total_yd_kss)."".deel_td(deel_0($arr_order_data[$k1][1]))."".deel_bfb($arr_order_data[$k1][1],$total_yd_js)."".deel_td(deel_0(deel_num($arr_order_data[$k1][2])))."".deel_bfb($arr_order_data[$k1][2],$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."\","; ?>