121 lines
6.1 KiB
PHP
121 lines
6.1 KiB
PHP
<?php
|
|
//主推款订货完成分析
|
|
//可配置参数：zd1|sxz|横向维度,ztk_zd|brand|推荐款字段,ztk_value|11|推荐款值
|
|
//by hehe 20161211
|
|
//横向维度
|
|
$zd1=get_plugin_set("zd1","sxz");
|
|
$ztk_zd=get_plugin_set("tjk","brand");
|
|
$ztk_value=get_plugin_set("tjk_value","11");
|
|
//查询条件
|
|
$select_client_type="y";//dp:允许筛选店铺
|
|
$use_layui_datatable="n";//使用标准layui datatable格式数据
|
|
//-----推荐款条件
|
|
$con_kh_dj=" and (".$ztk_zd."='".$ztk_value."')";
|
|
//店铺查询条件
|
|
$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"]."-%')";
|
|
}
|
|
}
|
|
//
|
|
for($i=1;$i<3;$i++){
|
|
$v="zd".$i;
|
|
$v1="zd_title".$i;
|
|
$v2="arr_zd".$i;
|
|
//取得对应字段的名称
|
|
$$v1=get_cate_title_no("arr_select",$$v);
|
|
//取得字段的选项值
|
|
$q1="select no,title from ".$table_pre."keyword where cate='".$$v."' order by no";
|
|
$r1=$db->query($q1);
|
|
$arr_tmp=array();
|
|
while($m1=$db->fetch_array($r1)){
|
|
$arr_tmp[$m1["no"]]=$m1["title"];
|
|
}
|
|
$$v2=$arr_tmp;
|
|
}
|
|
$content_data.="<table border='0' cellspacing='1' cellpadding='4' class='layui-table'><thead>";
|
|
//表头第一行
|
|
$content_data.="<tr>";
|
|
$content_data.="<th align='center' rowspan='2'><strong>".$zd_title1."</strong></th><th align='center' colspan='3'><strong>设计款数</strong></th><th align='center' colspan='3'><strong>订单款数</strong></th><th align='center'><strong>主推款订货完成</strong></th><th align='center' colspan='3'><strong>已订件数</strong></th>";
|
|
$content_data.="</tr>";
|
|
//表头第二行
|
|
$content_data.="<tr>";
|
|
$content_data.="<th align='center'><strong>总款数</strong></th><th align='center'><strong>主推款数</strong></th><th align='center'><strong>占比</strong></th><th align='center'><strong>总款数</strong></th><th align='center'><strong>主推款数</strong></th><th align='center'><strong>占比</strong></th><th align='center'><strong>占比</strong></th><th align='center'><strong>总件数</strong></th><th align='center'><strong>主推款件数</strong></th><th align='center'><strong>占比</strong></th>";
|
|
$content_data.="</tr>";
|
|
$content_data.="</thead>";
|
|
|
|
//-----------取得报表数据
|
|
//款号表货品数据
|
|
$q1="select ".$zd1.",count(*) as num from ".$table_pre."kh where ka<>'y' group by ".$zd1;
|
|
$r1=$db->query($q1);
|
|
$arr_design_data=array();
|
|
while($m1=$db->fetch_array($r1)){
|
|
$arr_design_data[$m1[$zd1]]=$m1["num"];//款号表中每一大类的设计款数
|
|
}
|
|
|
|
$q2="select ".$zd1.",count(*) as num from ".$table_pre."kh where ka<>'y'".$con_kh_dj." group by ".$zd1;
|
|
$r2=$db->query($q2);
|
|
$arr_design_kh_dj_data=array();
|
|
while($m2=$db->fetch_array($r2)){
|
|
$arr_design_kh_dj_data[$m2[$zd1]]=$m2["num"];//款号表中每一大类内的SA款数
|
|
}
|
|
//订单表数据
|
|
$q3="select ".$zd1.",count(distinct iid) as num 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_ksdata[$m3[$zd1]]=$m3["num"];//订单表内每一大类的款数
|
|
}
|
|
|
|
$q4="select ".$zd1.",count(distinct iid) as num from ".$table_pre."order where ka<>'y'".$con.$con_kh_dj." group by ".$zd1;
|
|
$r4=$db->query($q4);
|
|
$arr_order_kh_dj_ksdata=array();
|
|
while($m4=$db->fetch_array($r4)){
|
|
$arr_order_kh_dj_ksdata[$m4[$zd1]]=$m4["num"];//订单表内每一大类的SA款数
|
|
}
|
|
|
|
$q5="select ".$zd1.",sum(num) as num from ".$table_pre."order where ka<>'y'".$con." group by ".$zd1;
|
|
$r5=$db->query($q5);
|
|
$arr_order_data=array();
|
|
while($m5=$db->fetch_array($r5)){
|
|
$arr_order_data[$m5[$zd1]]=$m5["num"];//订单表中每一大类的订单总数
|
|
}
|
|
$q6="select ".$zd1.",sum(num) as num from ".$table_pre."order where ka<>'y'".$con.$con_kh_dj." group by ".$zd1;
|
|
$r6=$db->query($q6);
|
|
$arr_order_kh_dj_data=array();
|
|
while($m6=$db->fetch_array($r6)){
|
|
$arr_order_kh_dj_data[$m6[$zd1]]=$m6["num"];//订单表中每一大类SA订单总数
|
|
}
|
|
//--------------------输出报表-----------------------------------------------
|
|
$content_data.="<tbody>";
|
|
foreach($arr_zd1 as $key=>$value){
|
|
$content_data.="<tr>";
|
|
$content_data.="<td align='center'>".$value."</td><td align='center'>".$arr_design_data[$key]."</td><td align='center'>".$arr_design_kh_dj_data[$key]."</td><td align='center'>".deel_bfb($arr_design_kh_dj_data[$key],$arr_design_data[$key])."</td><td align='center'>".$arr_order_ksdata[$key]."</td><td align='center'>".$arr_order_kh_dj_ksdata[$key]."</td><td align='center'>".deel_bfb($arr_order_kh_dj_ksdata[$key],$arr_order_ksdata[$key])."</td><td align='center'>".deel_bfb($arr_order_kh_dj_ksdata[$key],$arr_design_kh_dj_data[$key])."</td><td align='center'>".$arr_order_data[$key]."</td><td align='center'>".$arr_order_kh_dj_data[$key]."</td><td align='center'>".deel_bfb($arr_order_kh_dj_data[$key],$arr_order_data[$key])."</td>";
|
|
$total_1+=$arr_design_data[$key];
|
|
$total_2+=$arr_design_kh_dj_data[$key];
|
|
$total_3+=$arr_order_ksdata[$key];
|
|
$total_4+=$arr_order_kh_dj_ksdata[$key];
|
|
$total_5+=$arr_order_data[$key];
|
|
$total_6+=$arr_order_kh_dj_data[$key];
|
|
$content_data.="</tr>";
|
|
}
|
|
$content_data.="<tr><td align='center'>合计</td><td align='center'>".$total_1."</td><td align='center'>".$total_2."</td><td align='center'>".deel_bfb($total_2,$total_1)."</td><td align='center'>".$total_3."</td><td align='center'>".$total_4."</td><td align='center'>".deel_bfb($total_4,$total_3)."</td><td align='center'>".deel_bfb($total_4,$total_2)."</td><td align='center'>".$total_5."</td><td align='center'>".$total_6."</td><td align='center'>".deel_bfb($total_6,$total_5)."</td></tr>";
|
|
$content_data.="</tbody>";
|
|
$content_data.="</table>";
|
|
$json_data.="\"table_html\":\"".$content_data."\",";
|
|
?>
|