116 lines
5.2 KiB
PHP
116 lines
5.2 KiB
PHP
<?php
|
|
//1维指标分析
|
|
//可配置参数：zd1|bc|维度
|
|
//by hehe 2081211
|
|
//-----参数配置
|
|
//横向维度
|
|
$zd1=get_plugin_set("zd1","bc");
|
|
//
|
|
$select_client_type="y";//dp:允许筛选店铺
|
|
$use_layui_datatable="n";//使用标准layui datatable格式数据
|
|
if(check_table_exist($table_pre."plugin_zbxf1")=="n"){
|
|
//
|
|
$code=0;
|
|
$error_msg="请先设置指标数据!";
|
|
}else{
|
|
//店铺查询条件
|
|
$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"]."-%')";
|
|
}
|
|
}
|
|
//
|
|
$con_this=$con;
|
|
$i=1;
|
|
$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'><strong>".$zd_title1."</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>";
|
|
//-----------取得款号数据
|
|
//订单表数据
|
|
$q3="select ".$zd1.",count(*) 'ks' from ".$table_pre."kh where ka<>'y' group by ".$zd1;
|
|
$r3=$db->query($q3);
|
|
$arr_data_kh=array();
|
|
while($m3=$db->fetch_array($r3)){
|
|
$arr_data_kh[$m3[$zd1]]=array($m3["ks"]);
|
|
}
|
|
//-----------取得订单数据
|
|
$q3="select ".$zd1.",count(distinct iid) 'ks',sum(num) 'js',sum(jsje) 'je' from ".$table_pre."order where ka<>'y'".$con_other.$con_this." group by ".$zd1;
|
|
$r3=$db->query($q3);
|
|
$arr_data_order=array();
|
|
while($m3=$db->fetch_array($r3)){
|
|
$arr_data_order[$m3[$zd1]]=array($m3["je"],$m3["js"],$m3["ks"]);
|
|
}
|
|
//--------------------输出报表-----------------------------------------------
|
|
$content_data.="<tbody>";
|
|
foreach($arr_zd1 as $key1=>$value1){
|
|
$xj1=$xj2=$xj3=$xj4=$xj5=$xj6=0;
|
|
//取得指标数据
|
|
$m_zbxf=get_db_msg("select sum(js) 'js',sum(je) 'je',sum(ks) 'ks' from ".$table_pre."plugin_zbxf1 where key1='".$value1."'".$con_this);
|
|
if($arr_data_kh[$key1][0]>0){
|
|
$str_zbje=$str_jewcl=$str_zbjs=$str_jswcl=$str_zbks=$str_kswcl=" ";
|
|
if($m_zbxf["je"]>0){
|
|
$str_zbje=deel_num($m_zbxf["je"]);
|
|
$str_jewcl=deel_bfb1($arr_data_order[$key1][0],$m_zbxf["je"],1);
|
|
}
|
|
if($m_zbxf["js"]>0){
|
|
$str_zbjs=deel_num($m_zbxf["js"]);
|
|
$str_jswcl=deel_bfb1($arr_data_order[$key1][1],$m_zbxf["js"],1);
|
|
}
|
|
if($m_zbxf["ks"]>0){
|
|
$str_zbks=deel_num($m_zbxf["ks"]);
|
|
$str_kswcl=deel_bfb1($arr_data_order[$key1][2],$m_zbxf["ks"],1);
|
|
}
|
|
$content_data.="<tr>";
|
|
$content_data.="<td align='center'>".$value1."</td><td align='center'>".$str_zbje."</td><td align='center'>".deel_0(deel_num($arr_data_order[$key1][0]))."</td><td align='center'>".$str_jewcl."</td><td align='center'>".$str_zbjs."</td><td align='center'>".deel_0($arr_data_order[$key1][1])."</td><td align='center'>".$str_jswcl."</td><td align='center'>".$str_zbks."</td><td align='center'>".deel_0($arr_data_order[$key1][2])."</td><td align='center'>".$str_kswcl."</td>";
|
|
$xj1+=$m_zbxf["je"];
|
|
$xj2+=$arr_data_order[$key1][0];
|
|
$xj3+=$m_zbxf["js"];
|
|
$xj4+=$arr_data_order[$key1][1];
|
|
$xj5+=$m_zbxf["ks"];
|
|
$xj6+=$arr_data_order[$key1][2];
|
|
//
|
|
$total_1+=$m_zbxf["je"];
|
|
$total_2+=$arr_data_order[$key1][0];
|
|
$total_3+=$m_zbxf["js"];
|
|
$total_4+=$arr_data_order[$key1][1];
|
|
$total_5+=$m_zbxf["ks"];
|
|
$total_6+=$arr_data_order[$key1][2];
|
|
$content_data.="</tr>";
|
|
}
|
|
}
|
|
$content_data.="<tr><td align='center'>合计</td><td align='center'>".deel_0($total_1)."</td><td align='center'>".deel_0($total_2)."</td><td align='center'>".deel_bfb1($total_2,$total_1,1)."</td><td align='center'>".deel_0($total_3)."</td><td align='center'>".deel_0($total_4)."</td><td align='center'>".deel_bfb1($total_4,$total_3,1)."</td><td align='center'>".deel_0($total_5)."</td><td align='center'>".deel_0($total_6)."</td><td align='center'>".deel_bfb1($total_6,$total_5,1)."</td></tr>";
|
|
$content_data.="</tbody></table>";
|
|
}
|
|
$json_data.="\"table_html\":\"".$content_data."\",";
|
|
?>
|