1527 lines
84 KiB
PHP
1527 lines
84 KiB
PHP
<?php
|
|
//p1
|
|
if(THIS_IN!="edt_c")
|
|
exit("错误的访问!");
|
|
$uid=check_cookie();
|
|
$db=_mysql_connect();
|
|
$msg_login_user=get_db_msg("select * from ".$table_pre."client where id='".$uid."'");
|
|
$arr_dp=array();
|
|
if($msg_login_user["face"]=="3"){
|
|
$q="select id,username,title,path from ".$table_pre."client where path='".$msg_login_user["path"]."-".$msg_login_user["id"]."'";
|
|
$r=$db->query($q);
|
|
$i=0;
|
|
while($m=$db->fetch_array($r)){
|
|
$arr_dp[$i]=array($m["id"],$m["username"],$m["path"],$m["title"]);
|
|
$i++;
|
|
}
|
|
$con_u_all="(upath like '".$msg_login_user["path"]."-".$msg_login_user["id"]."-%' or upath='".$msg_login_user["path"]."-".$msg_login_user["id"]."') and ";
|
|
}else if($msg_login_user["face"]=="2"){
|
|
$arr_upath=explode(",",$msg_login_user["charge_path"]);
|
|
$i2=0;
|
|
for($i=0;$i<count($arr_upath);$i++){
|
|
$m=get_db_msg("select face,id,title,username,path from ".$table_pre."client where id='".get_parent_id($arr_upath[$i])."'");
|
|
if($m["face"]=="4"){
|
|
$arr_dp[$i2]=array($m["id"],$m["username"],$m["path"],$m["title"]);
|
|
$i2++;
|
|
}
|
|
}
|
|
$con_u_all=get_qj_u_con_all($msg_login_user["charge_path"]);
|
|
}else{
|
|
$arr_dp[0]=array($msg_login_user["id"],$msg_login_user["username"],$msg_login_user["path"],$msg_login_user["title"]);
|
|
$con_u_all="uid='".$msg_login_user["id"]."' and";
|
|
}
|
|
$con_u_all_c=str_replace("uid","id",$con_u_all);
|
|
$con_u_all_c=str_replace("upath","path",$con_u_all_c);
|
|
$arr_report=array("gl"=>"订单概览","ph"=>"款号排行","ph_ks"=>"款色排行","ks"=>"款式分析","detail"=>"订单明细");
|
|
$_a=$_a?$_a:"gl";
|
|
$_title_=get_main_value($arr_report,$_a);
|
|
$zk_type=get_set("zk_type");
|
|
$zb_type=get_set("zb_type");
|
|
$arr_zb_type=explode(",",$zb_type);
|
|
$is_spk=get_set("is_spk");
|
|
//--------------------------------------------
|
|
//可选择字段
|
|
$arr_zd["xh"]="序号";
|
|
$arr_zd["price"]="零售价";
|
|
$arr_zd["price_zk"]="折扣价";
|
|
$arr_zd["title"]="款式名";
|
|
if(check_arr_select_show("series"))
|
|
$arr_zd["series"]=get_cate_title_no("arr_select","series");
|
|
if(check_arr_select_show("theme"))
|
|
$arr_zd["theme"]=get_cate_title_no("arr_select","theme");
|
|
if(check_arr_select_show("bc"))
|
|
$arr_zd["bc"]=get_cate_title_no("arr_select","bc");
|
|
if(check_arr_select_show("category"))
|
|
$arr_zd["category"]=get_cate_title_no("arr_select","category");
|
|
if(check_arr_select_show("category1"))
|
|
$arr_zd["category1"]=get_cate_title_no("arr_select","category1");
|
|
if(check_arr_select_show("designer"))
|
|
$arr_zd["designer"]=get_cate_title_no("arr_select","designer");
|
|
$login_by_select=get_set("login_by_select");
|
|
//杯型参数
|
|
if($bx_sizegroup_title){
|
|
$tmp=get_db_msg("select id from ".$table_pre."keyword where cate='size' and title='".$bx_sizegroup_title."' limit 0,1");
|
|
$bx_sizegroup_id=$tmp["id"];
|
|
}else{
|
|
$bx_sizegroup_id=0;
|
|
}
|
|
switch($_a){
|
|
case "view_order":
|
|
$default_group_by="4";
|
|
$arr_group_by["4"]="店铺";
|
|
$arr_group_by["1"]="明细";
|
|
$s_group_by=$s_group_by?$s_group_by:$default_group_by;
|
|
$msg=get_db_msg("select * from ".$table_pre."kh where id='".$id."'");
|
|
$pic=get_kh_picture($msg["no"],$msg["main_pic"],$msg["color"]);
|
|
$pic_big=get_kh_picture_big($msg["no"],$msg["main_pic"],$msg["color"]);
|
|
$pic1=out_good_pic($pic,200,200,'border=0');
|
|
$content="<table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"4\" cellspacing=\"1\" bgcolor=\"#ffffff\"><form name=\"form1\" action=\"".$_SERVER["PHP_SELF"]."\"><input type=\"hidden\" name=\"id\" value=\"".$id."\"><input type=\"hidden\" name=\"_cid\" value=\"".$_cid."\"><input type=\"hidden\" name=\"_m\" value=\"".$_m."\"><input type=\"hidden\" name=\"_a\" value=\"".$_a."\"><tr><td bgcolor=\"#ffffff\" align=\"center\">".$pic1."</td></tr><tr><td bgcolor=\"#ffffff\" align=\"center\">".$msg["xh"]."#".$msg["no"]."</td></tr>";
|
|
$content.="<tr><td>";
|
|
foreach($arr_group_by as $k1 => $v1){
|
|
$sty=($k1==$s_group_by)?"font-weight:bold;border:1px solid #333333;padding:6px;":"font-weight:normal;border:1px solid #cccccc;padding:4px;";
|
|
$content.="<a href=\"".$_SERVER[PHP_SELF]."?_cid=".$_cid."&_m=".$_m."&_a=".$_a."&id=".$id."&color=".$color."&s_group_by=".$k1."\"><span style=\"".$sty."\">".$v1."</span></a> ";
|
|
}
|
|
$content.="<input type=\"button\" value=\" 刷 新 \" onclick=\"window.location.reload();\"></td></tr>";
|
|
$content.="<tr><td bgcolor=\"#ffffff\"><table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"4\" cellspacing=\"1\" bgcolor=\"#cccccc\">";
|
|
$sql_con="iid='".$id."' and ";
|
|
if($color)
|
|
$sql_con.="color='".$color."' and ";
|
|
$sql_con=substr($sql_con,0,-4);
|
|
if($s_group_by=="1"){
|
|
//------------------------明细
|
|
//表头
|
|
$content.="<tr><td bgcolor=\"#f0f0f0\">客户</td><td bgcolor=\"#f0f0f0\">款号</td><td bgcolor=\"#f0f0f0\">颜色</td>";
|
|
if($bx_sizegroup_id==$msg["size_group"]){
|
|
$content.="<td bgcolor=\"#f0f0f0\" width=\"25\">杯型</td>";
|
|
//
|
|
$size_str="";
|
|
$r1=$db->query("select * from ".$table_pre."size where iid='".$msg["size_group"]."' order by no");
|
|
while($m1=$db->fetch_array($r1)){
|
|
$size_str.=$m1["no"].",";
|
|
}
|
|
if($size_str)
|
|
$size_str=substr($size_str,0,-1);
|
|
$size=explode(",",$size_str);
|
|
}else{
|
|
$size=explode(",",$msg["size"]);
|
|
}
|
|
$tmp1=explode(",",$msg["color"]);
|
|
for($l=0;$l<count($size);$l++){
|
|
$tmp3=get_db_msg("select * from ".$table_pre."size where iid='".$msg["size_group"]."' and no='".$size[$l]."' limit 0,1");
|
|
$content.="<td bgcolor=\"#f0f0f0\" width=\"25\">".$tmp3["title"]."</td>";
|
|
}
|
|
$content.="<td bgcolor=\"#f0f0f0\" width=\"30\">小计</td><td bgcolor=\"#f0f0f0\">订单时间</td></tr>";
|
|
$q="select * from ".$table_pre."order where ".$sql_con." and ".$con_u_all." id>0 order by uid,add_date";
|
|
$r=$db->query($q);
|
|
$hj=0;
|
|
while($m=$db->fetch_array($r)){
|
|
$tmp=get_db_msg("select username,title from ".$table_pre."client where id='".$m["uid"]."'");
|
|
$m_kh=get_db_msg("select no from ".$table_pre."kh where id='".$m["iid"]."'");
|
|
$content.="<tr><td bgcolor=\"#ffffff\">".$tmp["title"]."(".$tmp["username"].")</td>";
|
|
$content.="<td bgcolor=\"#ffffff\">".$m_kh["no"]."</td>";
|
|
$content.="<td bgcolor=\"#ffffff\">".$m["color"]."-".get_cate_title_no("color",$m["color"])."</td>";
|
|
if($bx_sizegroup_id==$msg["size_group"])
|
|
$content.="<td bgcolor=\"#ffffff\" align=\"center\">".$m["bx"]."</td>";
|
|
//尺码列表
|
|
$xj=0;
|
|
for($l=0;$l<count($size);$l++){
|
|
$xj+=$m["num_".$size[$l]];
|
|
$hj+=$m["num_".$size[$l]];
|
|
//尺码合计
|
|
$v1="hj_".$size[$l];
|
|
$$v1+=$m["num_".$size[$l]];
|
|
$content.="<td bgcolor=\"#ffffff\">".$m["num_".$size[$l]]."</td>";
|
|
}
|
|
$content.="<td bgcolor=\"#ffffff\">".$xj."</td><td bgcolor=\"#ffffff\">".date("d日 H点i分",$m["add_date"])."</td></tr>";
|
|
}
|
|
//合计
|
|
$hj_colspan=($bx_sizegroup_id==$msg["size_group"])?4:3;
|
|
$content.="<tr><td bgcolor=\"#ffffff\" colspan=\"".($hj_colspan)."\" align=\"right\">合计</td>";
|
|
for($l=0;$l<count($size);$l++){
|
|
$v1="hj_".$size[$l];
|
|
$content.="<td bgcolor=\"#ffffff\">".$$v1."</td>";
|
|
}
|
|
$content.="<td bgcolor=\"#ffffff\">".$hj."</td><td bgcolor=\"#ffffff\"> </td></tr>";
|
|
}else{
|
|
//------------------------客户、代理、区域
|
|
//$arr_show_log_hd=array("23"=>"加量","22"=>"减量","24"=>"删单");
|
|
$arr_show_log_hd=array();
|
|
//取得数组
|
|
$arr1=array();
|
|
$q="select * from ".$table_pre."client where ".$con_u_all_c." face='".$s_group_by."'";
|
|
$r=$db->query($q);
|
|
while($m=$db->fetch_array($r)){
|
|
if($s_group_by=="4"){
|
|
$tmp_sql=" and uid='".$m["id"]."'";
|
|
}else{
|
|
$p=$m["path"]."-".$m["id"];
|
|
$tmp_sql=" and upath like '".$p."-%'";
|
|
}
|
|
$tmp=get_db_msg("select sum(".get_size_sql("sum").") 'num' from ".$table_pre."order where ".$sql_con.$tmp_sql);
|
|
//if($tmp["num"]>0)
|
|
$arr1[$m["id"]]=$tmp["num"];
|
|
}
|
|
arsort($arr1);
|
|
if($bx_sizegroup_id==$msg["size_group"]){
|
|
//
|
|
$size_str="";
|
|
$r1=$db->query("select * from ".$table_pre."size where iid='".$msg["size_group"]."' order by no");
|
|
while($m1=$db->fetch_array($r1)){
|
|
$size_str.=$m1["no"].",";
|
|
}
|
|
if($size_str)
|
|
$size_str=substr($size_str,0,-1);
|
|
$size=explode(",",$size_str);
|
|
}else{
|
|
$size=explode(",",$msg["size"]);
|
|
}
|
|
//表头
|
|
$content.="<tr><td bgcolor=\"#f0f0f0\" width=\"25\">序号</td><td bgcolor=\"#f0f0f0\">客户</td>";
|
|
if($s_group_by=="4"){
|
|
//
|
|
foreach($arr_show_log_hd as $k1 => $v1){
|
|
$content.="<td bgcolor=\"#f0f0f0\" width=\"30\">".$v1."<br>次数</td>";
|
|
}
|
|
}
|
|
for($l=0;$l<count($size);$l++){
|
|
$tmp3=get_db_msg("select * from ".$table_pre."size where iid='".$msg["size_group"]."' and no='".$size[$l]."' limit 0,1");
|
|
$content.="<td bgcolor=\"#f0f0f0\" width=\"25\">".trim($tmp3["title"])."</td>";
|
|
}
|
|
$content.="<td bgcolor=\"#f0f0f0\" width=\"30\">小计</td></tr>";
|
|
//
|
|
$hj=0;
|
|
$list=1;
|
|
foreach($arr1 as $id1 => $num1){
|
|
$hj+=$num1;
|
|
$m=get_db_msg("select * from ".$table_pre."client where id='".$id1."'");
|
|
if($s_group_by=="4"){
|
|
$tmp_sql=" and uid='".$m["id"]."'";
|
|
}else{
|
|
$p=$m["path"]."-".$m["id"];
|
|
$tmp_sql=" and (upath='".$p."' or upath like '".$p."-%')";
|
|
}
|
|
$tmp=get_db_msg("select ".get_size_sql("sum1")." from ".$table_pre."order where ".$sql_con.$tmp_sql);
|
|
$content.="<tr><td bgcolor=\"#ffffff\">".$list."</td><td bgcolor=\"#ffffff\">".$m["title"]."(".$m["username"].")</td>";
|
|
if($s_group_by=="4"){
|
|
foreach($arr_show_log_hd as $k1 => $v1){
|
|
//加单次数
|
|
$t1=get_db_msg("select count(*) 'num' from ".$table_pre."log_hd where uid='".$m["id"]."' and iid='".$id."' and action='".$k1."'");
|
|
$content.="<td bgcolor=\"#ffffff\">".deel_0($t1["num"])."</td>";
|
|
$v1="hj_action_".$k1;
|
|
$$v1+=$t1["num"];
|
|
}
|
|
}
|
|
for($l=0;$l<count($size);$l++){
|
|
$content.="<td bgcolor=\"#ffffff\">".$tmp["num_".$size[$l]]."</td>";
|
|
//尺码合计
|
|
$v1="hj_".$size[$l];
|
|
$$v1+=$tmp["num_".$size[$l]];
|
|
}
|
|
$content.="<td bgcolor=\"#ffffff\">".$num1."</td>";
|
|
$list++;
|
|
}
|
|
//合计
|
|
$hj_colspan=2;
|
|
$content.="<tr><td bgcolor=\"#ffffff\" align=\"right\" colspan=\"".$hj_colspan."\">合计</td>";
|
|
if($s_group_by=="4"){
|
|
foreach($arr_show_log_hd as $k1 => $v1){
|
|
$v1="hj_action_".$k1;
|
|
$content.="<td bgcolor=\"#ffffff\">".$$v1."</td>";
|
|
}
|
|
}
|
|
for($l=0;$l<count($size);$l++){
|
|
$v1="hj_".$size[$l];
|
|
$content.="<td bgcolor=\"#ffffff\">".$$v1."</td>";
|
|
}
|
|
$content.="<td bgcolor=\"#ffffff\">".$hj."</td></tr>";
|
|
}
|
|
$content.="</table></td></tr></table>";
|
|
$_title_=$msg["xh"]."#".$msg["no"]."订单明细";
|
|
include template("blank");
|
|
break;
|
|
case "ks":
|
|
//----------------款式分析
|
|
$s_order=$s_order?$s_order:"num";
|
|
$s_key=$s_key?$s_key:$_key;
|
|
$s_ka=$s_ka?$s_ka:"n";
|
|
$s_group_by=$s_group_by?$s_group_by:"category";
|
|
$error="";
|
|
$con="";
|
|
$con_u=deel_con_u($s_username);
|
|
if($con_u)
|
|
$con.=" and ".substr($con_u,0,-4);
|
|
if($s_is_sp)
|
|
$con.=" and is_sp='".$s_is_sp."' ";
|
|
if($s_ka)
|
|
$con.=" and ka='".$s_ka."' ";
|
|
if($error){
|
|
$error=substr($error,0,-1);
|
|
alert_and_back("用户代码有错,请检查(".$error.")");
|
|
}
|
|
$search_content="";
|
|
$search_content.="<input type=\"hidden\" name=\"is_sub\" value=\"y\">";
|
|
//取得店铺框
|
|
$str="var clients = [\n";
|
|
for($i=0;$i<count($arr_dp);$i++){
|
|
$str.="{id:\"".$arr_dp[$i][0]."\",t:\"".$arr_dp[$i][3]."\",u:\"".$arr_dp[$i][1]."\",p:\"".$arr_dp[$i][2]."-".$arr_dp[$i][0]."\"},\n";
|
|
}
|
|
if($i>0)
|
|
$str=substr($str,0,-2);
|
|
$str.="];\n";
|
|
$js_function.=$str."\n$(function() {
|
|
$('#s_username').autocomplete(clients, {
|
|
max: 100, //列表里的条目数
|
|
minChars: 0, //自动完成激活之前填入的最小字符
|
|
width: 300, //提示的宽度，溢出隐藏
|
|
scrollHeight: 300, //提示的高度，溢出显示滚动条
|
|
matchContains: true, //包含匹配，就是data参数里的数据，是否只要包含文本框里的数据就显示
|
|
autoFill: false, //自动填充
|
|
multiple:true,
|
|
multipleSeparator:',',
|
|
formatItem: function(row, i, max) {
|
|
return row.t+'('+row.u+')';
|
|
},
|
|
formatMatch: function(row, i, max) {
|
|
return row.t + row.u;
|
|
},
|
|
formatResult: function(row) {
|
|
return row.u;
|
|
}
|
|
}).result(function(event, row, formatted) {
|
|
$('#s_username').value=row.u;
|
|
});
|
|
});";
|
|
$search_content.="店铺:<input type=text name=\"s_username\" id=\"s_username\" style=\"width:200px\" value=\"".$s_username."\"> ";
|
|
//饰品款
|
|
$search_content.="<select name=\"s_ka\">".get_main_op(array("n"=>"不显示删除款","y"=>"显示删除款"),$s_ka)."</select> ";
|
|
$search_content.="<select name=\"s_is_sp\"><option value=''>-显示饰品款-</option>".get_main_op(array("n"=>"否","y"=>"是"),$s_is_sp)."</select> ";
|
|
//-----------报表定制
|
|
//大类
|
|
$arr_group_by["category"]=get_cate_title_no("arr_select","category");
|
|
//小类
|
|
if(check_arr_select_show("category1"))
|
|
$arr_group_by["category1"]=get_cate_title_no("arr_select","category1");
|
|
//波段
|
|
if(check_arr_select_show("bc"))
|
|
$arr_group_by["bc"]=get_cate_title_no("arr_select","bc");
|
|
//波段,大类
|
|
if(check_arr_select_show("bc") && check_arr_select_show("category"))
|
|
$arr_group_by["bc|category"]=get_cate_title_no("arr_select","bc")."-".get_cate_title_no("arr_select","category");
|
|
//波段,小类
|
|
if(check_arr_select_show("bc") && check_arr_select_show("category1"))
|
|
$arr_group_by["bc|category1"]=get_cate_title_no("arr_select","bc")."-".get_cate_title_no("arr_select","category1");
|
|
//系列
|
|
if(check_arr_select_show("series"))
|
|
$arr_group_by["series"]=get_cate_title_no("arr_select","series");
|
|
//系列,大类
|
|
if(check_arr_select_show("series") && check_arr_select_show("category"))
|
|
$arr_group_by["series|category"]=get_cate_title_no("arr_select","series")."-".get_cate_title_no("arr_select","category");
|
|
//系列,小类
|
|
if(check_arr_select_show("series") && check_arr_select_show("category1"))
|
|
$arr_group_by["series|category1"]=get_cate_title_no("arr_select","series")."-".get_cate_title_no("arr_select","category1");
|
|
//主题
|
|
if(check_arr_select_show("theme"))
|
|
$arr_group_by["theme"]=get_cate_title_no("arr_select","theme");
|
|
//主题,大类
|
|
if(check_arr_select_show("theme") && check_arr_select_show("category"))
|
|
$arr_group_by["theme|category"]=get_cate_title_no("arr_select","theme")."-".get_cate_title_no("arr_select","category");
|
|
//主题,小类
|
|
if(check_arr_select_show("theme") && check_arr_select_show("category1"))
|
|
$arr_group_by["theme|category1"]=get_cate_title_no("arr_select","theme")."-".get_cate_title_no("arr_select","category1");
|
|
//推荐等级
|
|
if(check_arr_select_show("kh_dj"))
|
|
$arr_group_by["kh_dj"]=get_cate_title_no("arr_select","kh_dj");
|
|
if(check_arr_select_show("category") && check_arr_select_show("kh_dj"))
|
|
$arr_group_by["category|kh_dj"]=get_cate_title_no("arr_select","category")."-".get_cate_title_no("arr_select","kh_dj");
|
|
//价格带
|
|
if(check_arr_select_show("jgd")){
|
|
$arr_group_by["jgd"]=get_cate_title_no("arr_select","jgd");
|
|
$arr_group_by["category|jgd"]=get_cate_title_no("arr_select","category")."-".get_cate_title_no("arr_select","jgd");
|
|
}
|
|
//颜色
|
|
$arr_group_by["color"]="颜色";
|
|
//尺码
|
|
$arr_group_by["size"]="尺码";
|
|
//尺码大类
|
|
$arr_group_by["size_category"]="尺码".get_cate_title_no("arr_select","category");
|
|
//-----------
|
|
$search_content.="<select name=\"s_group_by\">".get_main_op2($arr_group_by,$s_group_by,"按","分组")."</select> ";
|
|
$search_content.="<input type=hidden value=\"is_sub\" value=\"y\"> ";
|
|
$search_content.="<input type=submit value=\"开始分析\" class=\"button_act\"> ";
|
|
$con_ka="";
|
|
if($s_ka)
|
|
$con_ka=" ka='".$s_ka."'";
|
|
else
|
|
$con_ka=" ka<>'y'";
|
|
//取得总款数
|
|
$tmp=get_db_msg("select count(*) 'num' from ".$table_pre."kh where ".$con_ka);
|
|
$total_ks=$tmp["num"];
|
|
//取得总款色数
|
|
$total_sku=0;
|
|
$q2="select no,color from ".$table_pre."kh where ".$con_ka;
|
|
$r2=$db->query($q2);
|
|
while($m2=$db->fetch_array($r2)){
|
|
$arr1=explode(",",$m2["color"]);
|
|
$arr2=explode(",",$m2["color_ka"]);
|
|
for($i1=0;$i1<count($arr1);$i1++){
|
|
if($s_ka=="y"){
|
|
if(in_array($arr1[$i1],$arr2))
|
|
$total_sku++;
|
|
}else{
|
|
if(!in_array($arr1[$i1],$arr2))
|
|
$total_sku++;
|
|
}
|
|
}
|
|
}
|
|
//
|
|
if($is_sub=="y"){
|
|
if($s_group_by=="category" || $s_group_by=="category1" || $s_group_by=="series" || $s_group_by=="theme" || $s_group_by=="jgd" || $s_group_by=="season" || $s_group_by=="bc" || $s_group_by=="kh_dj"){
|
|
//-------------------------------------------------------大类、小类、价格带和季节、波段、系列、色系
|
|
//取得已订总件数和金额
|
|
$q="select sum(".get_size_sql("sum").") 'num',sum((".get_size_sql("sum").")*price) 'je' from ".$table_pre."order where ".$s_group_by."<>'' ".$con;
|
|
$tmp=get_db_msg($q);
|
|
$total_yd_js=$tmp["num"];
|
|
$total_yd_je=$tmp["je"];
|
|
//取得已订总款数
|
|
$tmp1=get_db_msg("select count(distinct no) 'num' from ".$table_pre."order where ".$s_group_by."<>'' ".$con);
|
|
$total_yd_ks=$tmp1["num"];
|
|
//取得已订总款色数
|
|
$tmp1=get_db_msg("select count(distinct no,color) 'num' from ".$table_pre."order where ".$s_group_by."<>'' ".$con);
|
|
$total_yd_sku=$tmp1["num"];
|
|
//
|
|
$_tbody="<tr><td align=\"center\" rowspan=\"2\"><strong>".get_main_value($arr_group_by,$s_group_by)."</strong></td><td align=\"center\" colspan=\"2\"><strong>设计款</strong></td><td align=\"center\" colspan=\"2\"><strong>已订款</strong></td><td align=\"center\" colspan=\"2\"><strong>设计款色</strong></td><td align=\"center\" colspan=\"2\"><strong>已订款色</strong></td><td align=\"center\" colspan=\"2\"><strong>已订件数</strong></td><td align=\"center\" colspan=\"2\"><strong>吊牌金额</strong></td></tr>";
|
|
$_tbody.="<tr><td align=\"center\"><strong>数量</strong></td><td align=\"center\"><strong>占比</strong></td><td align=\"center\"><strong>数量</strong></td><td align=\"center\"><strong>占比</strong></td><td align=\"center\"><strong>数量</strong></td><td align=\"center\"><strong>占比</strong></td><td align=\"center\"><strong>数量</strong></td><td align=\"center\"><strong>占比</strong></td><td align=\"center\"><strong>数量</strong></td><td align=\"center\"><strong>占比</strong></td><td align=\"center\"><strong>金额</strong></td><td align=\"center\"><strong>占比</strong></td></tr>";
|
|
//
|
|
$q="select * from ".$table_pre."keyword where cate='".$s_group_by."' order by no";
|
|
//echo $q."<br>";
|
|
$r=$db->query($q);
|
|
$count=$l=$total_num=$total_money=0;
|
|
while($m=$db->fetch_array($r)){
|
|
$bg=($count%2)?"#f0f0f0":"#ffffff";
|
|
$list=$count+1;
|
|
if($s_group_by=="color"){
|
|
$gtitle=get_cate_title_no("color",$m["color"]);
|
|
}else{
|
|
$gtitle=get_cate_title_no($s_group_by,$m[$s_group_by]);
|
|
}
|
|
$con1=$s_ka?" and ka='".$s_ka."'":"";
|
|
//------取得款数
|
|
$tmp=get_db_msg("select count(distinct no) 'num' from ".$table_pre."order where ".$s_group_by."='".$m["no"]."'".$con);
|
|
$tmp_yd_ks=$tmp["num"];
|
|
$tmp=get_db_msg("select count(*) 'num' from ".$table_pre."kh where ".$s_group_by."='".$m["no"]."' and ".$con_ka);
|
|
$tmp_z_ks=$tmp["num"];
|
|
//取得款色
|
|
$tmp=get_db_msg("select count(distinct no,color) 'num' from ".$table_pre."order where ".$s_group_by."='".$m["no"]."'".$con);
|
|
$tmp_yd_sku=$tmp["num"];
|
|
$tmp_z_sku=0;
|
|
$q2="select no,color,color_ka from ".$table_pre."kh where ".$s_group_by."='".$m["no"]."' and ".$con_ka;
|
|
$r2=$db->query($q2);
|
|
while($m2=$db->fetch_array($r2)){
|
|
$n1=count(explode(",",$m2["color"]));
|
|
$n2=trim($m2["color_ka"])?count(explode(",",$m2["color_ka"])):0;
|
|
$tmp_z_sku+=$n1;
|
|
}
|
|
//取得数量
|
|
$tmp=get_db_msg("select sum(".get_size_sql("sum").") 'num',sum((".get_size_sql("sum").")*price) 'je' from ".$table_pre."order where _key='".$s_key."' and ".$s_group_by."='".$m["no"]."'".$con);
|
|
$tmp_yd_js=$tmp["num"];
|
|
$tmp_yd_je=$tmp["je"];
|
|
$v2="zb_".$s_group_by;
|
|
$$v2=$m["no"];
|
|
if($tmp_z_ks>0){
|
|
$_tcontent[$count]="<tr><td bgcolor=\"".$bg."\">".deel_td($m["title"])."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_z_ks))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($tmp_z_ks,$total_ks)))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_yd_ks))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($tmp_yd_ks,$total_yd_ks)))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_z_sku))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($tmp_z_sku,$total_sku)))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_yd_sku))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($tmp_yd_sku,$total_yd_sku)))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_yd_js))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($tmp_yd_js,$total_yd_js)))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_yd_je))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($tmp_yd_je,$total_yd_je)))."</td>";
|
|
$content.="</tr>";
|
|
$count++;
|
|
}
|
|
}
|
|
$_tcontent[$count]="<tr><td height=\"25\" align=\"right\">合计</td><td align=\"right\">".deel_td(deel_0($total_ks))."</td><td align=\"right\"> </td><td align=\"right\">".deel_td(deel_0($total_yd_ks))."</td><td align=\"right\"> </td><td align=\"right\">".deel_td(deel_0($total_sku))."</td><td align=\"right\"> </td><td align=\"right\">".deel_td(deel_0($total_yd_sku))."</td><td align=\"right\"> </td><td align=\"right\">".deel_td(deel_0($total_yd_js))."</td><td align=\"right\"> </td><td align=\"right\">".deel_td(deel_0($total_yd_je))."</td><td align=\"right\"> </td></tr>";
|
|
}else if($s_group_by=="sx"){
|
|
//-------------------------------------------------------色系
|
|
//取得已订总件数和金额
|
|
$q="select sum(".get_size_sql("sum").") 'num',sum((".get_size_sql("sum").")*price) 'je' from ".$table_pre."order where ".$s_group_by."<>'' ".$con;
|
|
$tmp=get_db_msg($q);
|
|
$total_yd_js=$tmp["num"];
|
|
$total_yd_je=$tmp["je"];
|
|
//取得已订总款色数
|
|
$tmp1=get_db_msg("select count(distinct no,color) 'num' from ".$table_pre."order where ".$s_group_by."<>'' ".$con);
|
|
$total_yd_sku=$tmp1["num"];
|
|
//
|
|
$_tbody="<tr><td align=\"center\"><strong>".get_main_value($arr_group_by,$s_group_by)."</strong></td><td align=\"center\" ><strong>已订款色</strong></td><td align=\"center\" ><strong>已订件数</strong></td><td align=\"center\" ><strong>件数占比</strong></td><td align=\"center\" ><strong>吊牌金额</strong></td><td align=\"center\" ><strong>金额占比</strong></td></tr>";
|
|
//
|
|
$q="select * from ".$table_pre."keyword where cate='".$s_group_by."' order by no";
|
|
//echo $q."<br>";
|
|
$r=$db->query($q);
|
|
$count=$l=$total_num=$total_money=0;
|
|
while($m=$db->fetch_array($r)){
|
|
$bg=($count%2)?"#f0f0f0":"#ffffff";
|
|
$list=$count+1;
|
|
if($s_group_by=="color"){
|
|
$gtitle=get_cate_title_no("color",$m["color"]);
|
|
}else{
|
|
$gtitle=get_cate_title_no($s_group_by,$m[$s_group_by]);
|
|
}
|
|
$con1=$s_ka?" and ka='".$s_ka."'":"";
|
|
//取得款色
|
|
$tmp=get_db_msg("select count(distinct no,color) 'num' from ".$table_pre."order where ".$s_group_by."='".$m["no"]."'".$con);
|
|
$tmp_yd_sku=$tmp["num"];
|
|
//取得数量
|
|
$tmp=get_db_msg("select sum(".get_size_sql("sum").") 'num',sum((".get_size_sql("sum").")*price) 'je' from ".$table_pre."order where _key='".$s_key."' and ".$s_group_by."='".$m["no"]."'".$con);
|
|
$tmp_yd_js=$tmp["num"];
|
|
$tmp_yd_je=$tmp["je"];
|
|
$zb_uid=$uid;
|
|
$v2="zb_".$s_group_by;
|
|
$$v2=$m["no"];
|
|
$_tcontent[$count]="<tr><td bgcolor=\"".$bg."\">".$m["title"]."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_yd_sku))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_yd_js))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($tmp_yd_js,$total_yd_js)))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_yd_je))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($tmp_yd_je,$total_yd_je)))."</td></tr>";
|
|
//记录数组
|
|
$arr_zb_js[$m["title"]]=deel_td(deel_0(deel_bfb($tmp_yd_js,$total_yd_js)));
|
|
$arr_zb_je[$m["title"]]=deel_td(deel_0(deel_bfb($tmp_yd_je,$total_yd_je)));
|
|
$count++;
|
|
}
|
|
$_tcontent[$count]="<tr><td height=\"25\" align=\"right\" >合计</td><td align=\"right\">".deel_td(deel_0($total_yd_sku))."</td><td align=\"right\">".deel_td(deel_0($total_yd_js))."</td><td align=\"right\"> </td><td align=\"right\">".deel_td(deel_0($total_yd_je))."</td><td align=\"right\"> </td></tr>";
|
|
$order_index=0;
|
|
}else if($s_group_by=="category|jgd" || $s_group_by=="bc|category" || $s_group_by=="bc|category1" || $s_group_by=="season|category" || $s_group_by=="season|category1" || $s_group_by=="series|category" || $s_group_by=="series|category1" || $s_group_by=="theme|category" || $s_group_by=="theme|category1" || $s_group_by=="category|kh_dj"){
|
|
//-------------------------------------------------------季节大类、季节小类、波段大类、波段小类、波段色系和系列大类、系列小类
|
|
$tmp=explode("|",$s_group_by);
|
|
$s_group_by1=$tmp[1];
|
|
$s_group_by2=$tmp[0];
|
|
$q4="select * from ".$table_pre."keyword where cate='".$s_group_by2."' order by no";
|
|
$r4=$db->query($q4);
|
|
//取得已订总件数和金额
|
|
$tmp=get_db_msg("select sum(".get_size_sql("sum").") 'num',sum((".get_size_sql("sum").")*price) 'je' from ".$table_pre."order where ".$s_group_by1."<>'' and ".$s_group_by2."<>'' ".$con);
|
|
$total_yd_js=$tmp["num"];
|
|
$total_yd_je=$tmp["je"];
|
|
//取得已订总款数
|
|
$tmp=get_db_msg("select count(distinct no) 'num' from ".$table_pre."order where ".$s_group_by1."<>'' and ".$s_group_by2."<>'' ".$con);
|
|
$total_yd_ks=$tmp["num"];
|
|
//取得已订总款色数
|
|
$tmp=get_db_msg("select count(distinct no,color) 'num' from ".$table_pre."order where ".$s_group_by1."<>'' and ".$s_group_by2."<>'' ".$con);
|
|
$total_yd_sku=$tmp["num"];
|
|
$_tbody="<tr><td align=\"center\" rowspan=\"2\"><strong>".get_cate_title_no("arr_select",$s_group_by2)."</strong></td><td align=\"center\" rowspan=\"2\"><strong>".get_cate_title_no("arr_select",$s_group_by1)."</strong></td><td align=\"center\" colspan=\"2\"><strong>设计款</strong></td><td align=\"center\" colspan=\"2\"><strong>已订款</strong></td><td align=\"center\" colspan=\"2\"><strong>设计款色</strong></td><td align=\"center\" colspan=\"2\"><strong>已订款色</strong></td><td align=\"center\" colspan=\"2\"><strong>已订件数</strong></td><td align=\"center\" colspan=\"2\"><strong>吊牌金额</strong></td></tr>";
|
|
$_tbody.="<tr><td align=\"center\"><strong>数量</strong></td><td align=\"center\"><strong>占比</strong></td><td align=\"center\"><strong>数量</strong></td><td align=\"center\"><strong>占比</strong></td><td align=\"center\"><strong>数量</strong></td><td align=\"center\"><strong>占比</strong></td><td align=\"center\"><strong>数量</strong></td><td align=\"center\"><strong>占比</strong></td><td align=\"center\"><strong>数量</strong></td><td align=\"center\"><strong>占比</strong></td><td align=\"center\"><strong>金额</strong></td><td align=\"center\"><strong>占比</strong></td></tr>";
|
|
$count=$l=$total_num=$total_money=0;
|
|
while($m4=$db->fetch_array($r4)){
|
|
$v21="zb_".$s_group_by2;
|
|
$$v21=$m4["no"];
|
|
//echo $v21."|".$$v21."<br>";
|
|
//取得小计设计款数
|
|
$tmp=get_db_msg("select count(*) 'num' from ".$table_pre."kh where ka<>'y' and ".$s_group_by2."='".$m4["no"]."' and ".$s_group_by1."<>''");
|
|
$xj_z_ks=$tmp["num"];
|
|
//取得小计设计款色数
|
|
$xj_z_sku=0;
|
|
$q2="select no,color from ".$table_pre."kh where ka<>'y' and ".$s_group_by2."='".$m4["no"]."' and ".$s_group_by1."<>''";
|
|
$r2=$db->query($q2);
|
|
while($m2=$db->fetch_array($r2)){
|
|
$arr1=explode(",",$m2["color"]);
|
|
$arr2=explode(",",$m2["color_ka"]);
|
|
for($i1=0;$i1<count($arr1);$i1++){
|
|
if(!in_array($arr1[$i1],$arr2))
|
|
$xj_z_sku++;
|
|
}
|
|
}
|
|
//
|
|
$q="select * from ".$table_pre."keyword where cate='".$s_group_by1."' order by no";
|
|
//echo $q."<br>";
|
|
$r=$db->query($q);
|
|
$l=0;
|
|
//取得已订小计款数
|
|
$tmp=get_db_msg("select count(distinct no) 'num' from ".$table_pre."order where ".$s_group_by2."='".$m4["no"]."' and ".$s_group_by1."<>'' and ".$s_group_by2."<>'' ".$con);
|
|
$xj_yd_ks=$tmp["num"];
|
|
//取得已订小计款色数
|
|
$tmp=get_db_msg("select count(distinct no,color) 'num' from ".$table_pre."order where ".$s_group_by2."='".$m4["no"]."' and ".$s_group_by2."<>'' and ".$s_group_by1."<>'' ".$con);
|
|
$xj_yd_sku=$tmp["num"];
|
|
//取得已订小计件数和金额
|
|
$tmp=get_db_msg("select sum(".get_size_sql("sum").") 'num',sum((".get_size_sql("sum").")*price) 'je' from ".$table_pre."order where ".$s_group_by2."='".$m4["no"]."' and ".$s_group_by2."<>'' and ".$s_group_by1."<>'' ".$con);
|
|
$xj_yd_js=$tmp["num"];
|
|
$xj_yd_je=$tmp["je"];
|
|
//
|
|
$xj_js_zb=$xj_je_zb=0;
|
|
while($m=$db->fetch_array($r)){
|
|
$bg=($count%2)?"#f0f0f0":"#ffffff";
|
|
$list=$count+1;
|
|
$gtitle=get_cate_title_no($s_group_by,$m[$s_group_by]);
|
|
//
|
|
//取得已订款数
|
|
$tmp=get_db_msg("select count(distinct no) 'num' from ".$table_pre."order where _key='".$s_key."' and ".$s_group_by2."='".$m4["no"]."' and ".$s_group_by1."='".$m["no"]."'".$con);
|
|
$tmp_yd_ks=$tmp["num"];
|
|
$tmp=get_db_msg("select count(*) 'num' from ".$table_pre."kh where ".$s_group_by2."='".$m4["no"]."' and ".$s_group_by1."='".$m["no"]."'".$con1);
|
|
$tmp_z_ks=$tmp["num"];
|
|
//取得款色
|
|
$tmp=get_db_msg("select count(distinct no,color) 'num' from ".$table_pre."order where _key='".$s_key."' and ".$s_group_by2."='".$m4["no"]."' and ".$s_group_by1."='".$m["no"]."'".$con);
|
|
$tmp_yd_sku=$tmp["num"];
|
|
$tmp_z_sku=0;
|
|
$q2="select no,color,color_ka from ".$table_pre."kh where ".$s_group_by2."='".$m4["no"]."' and ".$s_group_by1."='".$m["no"]."' ".$con1;
|
|
$r2=$db->query($q2);
|
|
while($m2=$db->fetch_array($r2)){
|
|
$n1=count(explode(",",$m2["color"]));
|
|
$n2=trim($m2["color_ka"])?count(explode(",",$m2["color_ka"])):0;
|
|
$tmp_z_sku+=$n1;
|
|
}
|
|
//取得数量
|
|
$tmp=get_db_msg("select sum(".get_size_sql("sum").") 'num',sum((".get_size_sql("sum").")*price) 'je' from ".$table_pre."order where _key='".$s_key."' and ".$s_group_by2."='".$m4["no"]."' and ".$s_group_by1."='".$m["no"]."'".$con);
|
|
$tmp_yd_js=$tmp["num"];
|
|
$tmp_yd_je=$tmp["je"];
|
|
//
|
|
$v22="zb_".$s_group_by1;
|
|
$$v22=$m["no"];
|
|
//echo $v22."|".$$v22."<br>";
|
|
if($tmp_z_ks>0){
|
|
$_tcontent[$count]="<tr><td bgcolor=\"".$bg."\">".$m4["title"]."</td><td bgcolor=\"".$bg."\">".$m["title"]."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_z_ks))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($tmp_z_ks,$xj_z_ks)))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_yd_ks))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($tmp_yd_ks,$xj_yd_ks)))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_z_sku))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($tmp_z_sku,$xj_z_sku)))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_yd_sku))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($tmp_yd_sku,$xj_yd_sku)))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_yd_js))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($tmp_yd_js,$xj_yd_js)))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_yd_je))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($tmp_yd_je,$xj_yd_je)))."</td></tr>";
|
|
$count++;
|
|
}
|
|
}
|
|
$content.="</tbody>";
|
|
if($xj_z_ks>0){
|
|
$_tcontent[$count]="<tr><td height=\"25\" align=\"right\" colspan=\"2\">小计</td><td align=\"right\">".deel_td(deel_0($xj_z_ks))."</td><td align=\"right\">".deel_td(deel_0(deel_bfb($xj_z_ks,$total_ks)))."</td><td align=\"right\">".deel_td(deel_0($xj_yd_ks))."</td><td align=\"right\">".deel_td(deel_0(deel_bfb($xj_yd_ks,$total_yd_ks)))."</td><td align=\"right\">".deel_td(deel_0($xj_z_sku))."</td><td align=\"right\">".deel_td(deel_0(deel_bfb($xj_z_sku,$total_sku)))."</td><td align=\"right\">".deel_td(deel_0($xj_yd_sku))."</td><td align=\"right\">".deel_td(deel_0(deel_bfb($xj_yd_sku,$total_yd_sku)))."</td><td align=\"right\">".deel_td(deel_0($xj_yd_js))."</td><td align=\"right\">".deel_td(deel_0(deel_bfb($xj_yd_js,$total_yd_js)))."</td><td align=\"right\">".deel_td(deel_0($xj_yd_je))."</td><td align=\"right\">".deel_td(deel_0(deel_bfb($xj_yd_je,$total_yd_je)))."</td></tr>";
|
|
$count++;
|
|
}
|
|
}
|
|
$_tcontent[$count]="<tr><td height=\"25\" align=\"right\" colspan=\"2\"><b>合计</b></td><td align=\"right\"><b>".deel_td(deel_0($total_ks))."</b></td><td align=\"right\"> </td><td align=\"right\"><b>".deel_td(deel_0($total_yd_ks))."</b></td><td align=\"right\"> </td><td align=\"right\"><b>".deel_td(deel_0($total_sku))."</b></td><td align=\"right\"> </td><td align=\"right\"><b>".deel_td(deel_0($total_yd_sku))."</b></td><td align=\"right\"> </td><td align=\"right\"><b>".deel_td(deel_0($total_yd_js))."</b></td><td align=\"right\"> </td><td align=\"right\"><b>".deel_td(deel_0($total_yd_je))."</b></td><td align=\"right\"> </td></tr>";
|
|
}else if($s_group_by=="season|sx" || $s_group_by=="bc|sx" || $s_group_by=="series|sx" || $s_group_by=="theme|sx"){
|
|
//-------------------------------------------------------季节色系、波段色系、系列色系
|
|
$tmp=explode("|",$s_group_by);
|
|
$s_group_by1=$tmp[1];
|
|
$s_group_by2=$tmp[0];
|
|
$q4="select * from ".$table_pre."keyword where cate='".$s_group_by2."' order by no";
|
|
$r4=$db->query($q4);
|
|
//取得已订总件数和金额
|
|
$tmp=get_db_msg("select sum(".get_size_sql("sum").") 'num',sum((".get_size_sql("sum").")*price) 'je' from ".$table_pre."order where ".$s_group_by1."<>'' and ".$s_group_by2."<>'' ".$con);
|
|
$total_yd_js=$tmp["num"];
|
|
$total_yd_je=$tmp["je"];
|
|
//取得已订总款色数
|
|
$tmp1=get_db_msg("select count(distinct no,color) 'num' from ".$table_pre."order where ".$s_group_by1."<>'' and ".$s_group_by2."<>'' ".$con);
|
|
$total_yd_sku=$tmp1["num"];
|
|
$_tbody="<tr><td align=\"center\" ><strong>".get_cate_title_no("arr_select",$s_group_by2)."</strong></td><td align=\"center\" ><strong>".get_main_value($arr_group_by,$s_group_by1)."</strong></td><td align=\"center\" ><strong>已订款色</strong></td><td align=\"center\" ><strong>已订数量</strong></td><td align=\"center\" ><strong>数量占比</strong></td><td align=\"center\" ><strong>吊牌金额</strong></td><td align=\"center\" ><strong>金额占比</strong></td></tr>";
|
|
$zb_uid=$uid;
|
|
$count=$l=$total_num=$total_money=0;
|
|
while($m4=$db->fetch_array($r4)){
|
|
//
|
|
$q="select * from ".$table_pre."keyword where cate='".$s_group_by1."' order by no";
|
|
//echo $q."<br>";
|
|
$r=$db->query($q);
|
|
//取得已订小计件数和金额
|
|
$tmp=get_db_msg("select sum(".get_size_sql("sum").") 'num',sum((".get_size_sql("sum").")*price) 'je' from ".$table_pre."order where ".$s_group_by2."='".$m4["no"]."' and ".$s_group_by2."<>'' and ".$s_group_by1."<>'' ".$con);
|
|
$xj_yd_js=$tmp["num"];
|
|
$xj_yd_je=$tmp["je"];
|
|
//取得已订小计款色数
|
|
$tmp1=get_db_msg("select count(distinct no,color) 'num' from ".$table_pre."order where ".$s_group_by2."='".$m4["no"]."' and ".$s_group_by2."<>'' and ".$s_group_by1."<>'' ".$con);
|
|
$xj_yd_sku=$tmp1["num"];
|
|
//
|
|
while($m=$db->fetch_array($r)){
|
|
$bg=($count%2)?"#f0f0f0":"#ffffff";
|
|
$list=$count+1;
|
|
$gtitle=get_cate_title_no($s_group_by,$m[$s_group_by]);
|
|
$con1=$s_ka?" and ka='".$s_ka."'":"";
|
|
//
|
|
//取得数量
|
|
$tmp=get_db_msg("select sum(".get_size_sql("sum").") 'num',sum((".get_size_sql("sum").")*price) 'je' from ".$table_pre."order where _key='".$s_key."' and ".$s_group_by2."='".$m4["no"]."' and ".$s_group_by1."='".$m["no"]."'".$con);
|
|
$tmp_yd_js=$tmp["num"];
|
|
$tmp_yd_je=$tmp["je"];
|
|
//取得已订小计款色数
|
|
$tmp1=get_db_msg("select count(distinct no,color) 'num' from ".$table_pre."order where _key='".$s_key."' and ".$s_group_by2."='".$m4["no"]."' and ".$s_group_by1."='".$m["no"]."'".$con);
|
|
$tmp_yd_sku=$tmp1["num"];
|
|
//
|
|
$_tcontent[$count]="<tr><td bgcolor=\"".$bg."\">".$m4["title"]."</td><td bgcolor=\"".$bg."\">".$m["title"]."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_yd_sku))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_yd_js))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($tmp_yd_js,$xj_yd_js)))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_yd_je))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(eel_bfb($tmp_yd_je,$xj_yd_je)))."</td></tr>";
|
|
$count++;
|
|
}
|
|
$_tcontent[$count]="<tr><td height=\"25\" align=\"right\" colspan=\"2\">小计</td><td align=\"right\">".deel_td(deel_0($xj_yd_sku))."</td><td align=\"right\">".$xj_yd_js."</td><td align=\"right\">".deel_td(deel_0(deel_bfb($xj_yd_js,$total_yd_js)))."</td><td align=\"right\">".$xj_yd_je."</td><td align=\"right\">".deel_td(deel_0(deel_bfb($xj_yd_je,$total_yd_je)))."</td></tr>";
|
|
$count++;
|
|
}
|
|
$_tcontent[$count]="<tr><td height=\"25\" align=\"right\" colspan=\"2\"><b>合计</b></td><td align=\"right\"><b>".deel_td(deel_0($total_yd_sku))."</b></td><td align=\"right\"><b>".deel_td(deel_0($total_yd_js))."</b></td><td align=\"right\"> </td><td align=\"right\"><b>".deel_td(deel_0($total_yd_je))."</b></td><td align=\"right\"> </td></tr>";
|
|
}else if($s_group_by=="size_category"){
|
|
//尺码大类
|
|
//取得已订总件数和金额
|
|
$tmp=get_db_msg("select sum(".get_size_sql("sum").") 'num',sum((".get_size_sql("sum").")*price) 'je' from ".$table_pre."order where _key='".$s_key."'".$con);
|
|
$total_yd_js=$tmp["num"];
|
|
$total_yd_je=$tmp["je"];
|
|
$_tbody="<tr><td align=\"center\" ><strong>".get_cate_title_no("arr_select","category")."</strong></td><td align=\"center\" ><strong>尺码</strong></td><td align=\"center\" ><strong>已订件数</strong></td><td align=\"center\" ><strong>件数占比</strong></td><td align=\"center\" ><strong>吊牌金额</strong></td><td align=\"center\" ><strong>金额占比</strong></td></tr>";
|
|
$q1="select * from ".$table_pre."keyword where cate='category' order by ord";
|
|
$r1=$db->query($q1);
|
|
$count=$total_num=0;
|
|
$l=0;
|
|
while($m1=$db->fetch_array($r1)){
|
|
$tmp=get_db_msg("select size_group from ".$table_pre."kh where category='".$m1["no"]."' limit 0,1");
|
|
$q="select * from ".$table_pre."size where iid='".$tmp["size_group"]."' order by iid,no";
|
|
$r=$db->query($q);
|
|
//
|
|
$tmp=get_db_msg("select sum(".get_size_sql("sum").") 'num',sum((".get_size_sql("sum").")*price) 'je' from ".$table_pre."order where _key='".$s_key."' and category='".$m1["no"]."'".$con);
|
|
$xj_yd_js=$tmp["num"];
|
|
$xj_yd_je=$tmp["je"];
|
|
while($m=$db->fetch_array($r)){
|
|
$bg=($l%2)?"#f0f0f0":"#ffffff";
|
|
$arr1=get_num_je_size_category($m["no"],$m1["no"]);
|
|
$total_num+=$arr1[0];
|
|
$total_money+=$arr1[1];
|
|
$_tcontent[$count]="<tr><td bgcolor=\"".$bg."\">".$m1["title"]."</td><td bgcolor=\"".$bg."\">".$m["title"]."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($arr1[0]))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($arr1[0],$xj_yd_js)))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($arr1[1]))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($arr1[1],$xj_yd_je)))."</td></tr>";
|
|
$count++;
|
|
}
|
|
$l++;
|
|
}
|
|
$_tcontent[$count]="<tr><td height=\"25\" align=\"right\" colspan=\"2\">合计</td><td align=\"right\">".deel_td(deel_0($total_num))."</td><td align=\"right\"> </td><td align=\"right\">".deel_td(deel_0($total_money))."</td><td align=\"right\"> </td></tr>";
|
|
}else if($s_group_by=="size"){
|
|
//尺码
|
|
//取得已订总件数和金额
|
|
$tmp=get_db_msg("select sum(".get_size_sql("sum").") 'num',sum((".get_size_sql("sum").")*price) 'je' from ".$table_pre."order where _key='".$s_key."'".$con);
|
|
$total_yd_js=$tmp["num"];
|
|
$total_yd_je=$tmp["je"];
|
|
$_tbody="<tr><td align=\"center\" ><strong>尺码组</strong></td><td align=\"center\" ><strong>尺码</strong></td><td align=\"center\" ><strong>已订件数</strong></td><td align=\"center\" ><strong>件数占比</strong></td><td align=\"center\" ><strong>吊牌金额</strong></td><td align=\"center\" ><strong>金额占比</strong></td></tr>";
|
|
$q1="select * from ".$table_pre."keyword where cate='size' order by ord";
|
|
$r1=$db->query($q1);
|
|
$count=$total_num=0;
|
|
$l=0;
|
|
while($m1=$db->fetch_array($r1)){
|
|
$q="select * from ".$table_pre."size where iid='".$m1["id"]."' order by iid,no";
|
|
$r=$db->query($q);
|
|
//
|
|
$tmp=get_db_msg("select sum(".get_size_sql("sum").") 'num',sum((".get_size_sql("sum").")*price) 'je' from ".$table_pre."order where _key='".$s_key."' and category='".$m1["no"]."'".$con);
|
|
$xj_yd_js=$tmp["num"];
|
|
$xj_yd_je=$tmp["je"];
|
|
while($m=$db->fetch_array($r)){
|
|
$bg=($l%2)?"#f0f0f0":"#ffffff";
|
|
$arr1=get_num_je_size($m["no"],$m1["id"]);
|
|
$total_num+=$arr1[0];
|
|
$total_money+=$arr1[1];
|
|
$_tcontent[$count]="<tr><td bgcolor=\"".$bg."\">".$m1["title"]."</td><td bgcolor=\"".$bg."\">".$m["title"]."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($arr1[0]))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($arr1[0],$xj_yd_js)))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($arr1[1]))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($arr1[1],$xj_yd_je)))."</td></tr>";
|
|
$count++;
|
|
}
|
|
$l++;
|
|
}
|
|
$_tcontent[$count]="<tr><td height=\"25\" align=\"right\" colspan=\"2\">合计</td><td align=\"right\">".deel_td(deel_0($total_num))."</td><td align=\"right\"> </td><td align=\"right\">".deel_td(deel_0($total_money))."</td><td align=\"right\"> </td></tr>";
|
|
}else if($s_group_by=="color"){
|
|
//颜色
|
|
//$content_search.="<select name=\"s_order\" onchange=\"tj.submit();show_loading();\" style=\"width:100px;\">".get_main_op(array("num"=>"按数量排序","je"=>"按金额排序"),$s_order)."</select>";
|
|
//
|
|
//取得已订总件数和金额
|
|
$tmp=get_db_msg("select sum(".get_size_sql("sum").") 'num',sum((".get_size_sql("sum").")*price) 'je' from ".$table_pre."order where _key='".$s_key."'".$con);
|
|
$total_yd_js=$tmp["num"];
|
|
$total_yd_je=$tmp["je"];
|
|
//取得已订总款色数
|
|
$tmp1=get_db_msg("select count(distinct no,color) 'num' from ".$table_pre."order where ".$s_group_by."<>'' ".$con);
|
|
$total_yd_sku=$tmp1["num"];
|
|
$_tbody="<tr><td align=\"center\" rowspan=\"2\"><strong>".get_main_value($arr_group_by,$s_group_by)."</strong></td><td align=\"center\" colspan=\"2\"><strong>设计款</strong></td><td align=\"center\" colspan=\"2\"><strong>已订款</strong></td><td align=\"center\" colspan=\"2\"><strong>已订件数</strong></td><td align=\"center\" colspan=\"2\"><strong>吊牌金额</strong></td></tr><tr><td align=\"center\"><strong>数量</strong></td><td align=\"center\"><strong>占比</strong></td><td align=\"center\"><strong>数量</strong></td><td align=\"center\"><strong>占比</strong></td><td align=\"center\"><strong>数量</strong></td><td align=\"center\"><strong>占比</strong></td><td align=\"center\"><strong>金额</strong></td><td align=\"center\"><strong>占比</strong></td></tr>";
|
|
$q="select * from ".$table_pre."keyword where cate='".$s_group_by."' order by no";
|
|
//echo $q."<br>";
|
|
$r=$db->query($q);
|
|
$count=$l=$total_num=$total_money=0;
|
|
while($m=$db->fetch_array($r)){
|
|
$bg=($count%2)?"#f0f0f0":"#ffffff";
|
|
$list=$count+1;
|
|
//取得数量
|
|
$m1=get_db_msg("select sum(".get_size_sql("sum").") 'num',sum((".get_size_sql("sum").")*price) 'je' from ".$table_pre."order where _key='".$s_key."' and ".$s_group_by."='".$m["no"]."'".$con);
|
|
$total_num+=$m1["num"];
|
|
$total_money+=$m1["je"];
|
|
//取得款色
|
|
$tmp=get_db_msg("select count(distinct no,color) 'num' from ".$table_pre."order where ".$s_group_by."='".$m["no"]."'".$con);
|
|
$tmp_yd_sku=$tmp["num"];
|
|
$tmp_z_sku=0;
|
|
$q2="select no,color,color_ka from ".$table_pre."kh where ka<>'y'";
|
|
$r2=$db->query($q2);
|
|
while($m2=$db->fetch_array($r2)){
|
|
$tmp1=explode(",",$m2["color"]);
|
|
$tmp2=explode(",",$m2["color_ka"]);
|
|
if(in_array($m["no"],$tmp1) && !in_array($m["no"],$tmp2)){
|
|
$tmp_z_sku++;
|
|
}
|
|
}
|
|
$_tcontent[$count]="<tr><td bgcolor=\"".$bg."\">".$m["title"]."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_z_sku))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($tmp_z_sku,$total_sku)))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($tmp_yd_sku))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($tmp_yd_sku,$total_yd_sku)))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($m1["num"]))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($m1["num"],$total_yd_js)))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($m1["je"]))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_bfb($m1["je"],$total_yd_je)))."</td></tr>";
|
|
$count++;
|
|
}
|
|
$_tcontent[$count]="</tbody><tr><td height=\"25\" align=\"right\">合计</td><td align=\"right\">".deel_td(deel_0($total_sku))."</td><td align=\"right\"> </td><td align=\"right\">".deel_td(deel_0($total_yd_sku))."</td><td align=\"right\"> </td><td align=\"right\">".deel_td(deel_0($total_num))."</td><td align=\"right\"> </td><td align=\"right\">".deel_td(deel_0($total_money))."</td><td align=\"right\"> </td></tr>";
|
|
}
|
|
}
|
|
//echo $con."<br>";
|
|
break;
|
|
case "detail":
|
|
//-------------------处理尺码表头
|
|
//取得合并尺码
|
|
$arr_size_merged=get_size_merged();
|
|
$num_size_total=count($arr_size_merged);
|
|
//取得尺码合计sql
|
|
$sql_sum_num="";
|
|
for($k=0;$k<$num_size_total;$k++){
|
|
$sql_sum_num.="sum(num_".$arr_size_merged[$k].") 'num_".$arr_size_merged[$k]."',";
|
|
}
|
|
//取得尺码表头内容
|
|
$num_size_group=0;
|
|
$size_tr=array();
|
|
$r1=$db->query("select * from ".$table_pre."keyword where cate='size' order by ord");
|
|
while($m1=$db->fetch_array($r1)){
|
|
$size_tr[$num_size_group]="";
|
|
for($i=1;$i<=$num_size_total;$i++){
|
|
$tmp=get_db_msg("select title from ".$table_pre."size where iid='".$m1["id"]."' and no='".$i."'");
|
|
$t=$tmp["title"]?$tmp["title"]:" ";
|
|
$size_tr[$num_size_group].="<td bgcolor=\"#f0f0f0\" align=\"center\" width=\"30\">".$t."</td>";
|
|
}
|
|
$arr_size_merged[]=$m1["no"];
|
|
$num_size_group++;
|
|
}
|
|
//-------------------/处理尺码表头结束
|
|
$s_key=$s_key?$s_key:$_key;
|
|
$s_ka=$s_ka?$s_ka:"n";
|
|
$s_hbkh=$s_hbkh?$s_hbkh:"y";
|
|
$s_zd=$s_zd?$s_zd:array("price");
|
|
$sql_con="";
|
|
if($s_brand || $s_is_sp || $s_series || $s_theme || $s_designer || $s_category || $s_category1 || $s_key || $s_no || $s_season || $s_bc || $s_ka){
|
|
if($s_designer)
|
|
$sql_con.="designer='".$s_designer."' and ";
|
|
if($s_no)
|
|
$sql_con.="no like '%".$s_no."%' and ";
|
|
if($s_brand){
|
|
$sql_con.="brand='".$s_brand."' and ";
|
|
}
|
|
if($s_is_sp){
|
|
$sql_con.="is_sp='".$s_is_sp."' and ";
|
|
}
|
|
if($s_series){
|
|
$sql_con.="series='".$s_series."' and ";
|
|
}
|
|
if($s_theme){
|
|
$sql_con.="theme='".$s_theme."' and ";
|
|
}
|
|
if($s_category){
|
|
$sql_con.="category='".$s_category."' and ";
|
|
}
|
|
if($s_category1){
|
|
$sql_con.="category1='".$s_category1."' and ";
|
|
}
|
|
if($s_season){
|
|
$sql_con.="season='".$s_season."' and ";
|
|
}
|
|
if($s_bc){
|
|
$sql_con.="bc='".$s_bc."' and ";
|
|
}
|
|
if($s_ka){
|
|
$sql_con.="ka='".$s_ka."' and ";
|
|
}
|
|
}
|
|
$con_u=deel_con_u($s_username);
|
|
if($con_u)
|
|
$sql_con.=$con_u;
|
|
if($sql_con)
|
|
$sql_con="where ".substr($sql_con,0,-4);
|
|
$search_content="";
|
|
$search_content.="<input type=\"hidden\" name=\"is_sub\" value=\"y\">";
|
|
$search_content.="<select name=\"s_ka\">".get_main_op(array("n"=>"不显示删除款","y"=>"显示删除款"),$s_ka)."</select> ";
|
|
//取得店铺框
|
|
$str="var clients = [\n";
|
|
for($i=0;$i<count($arr_dp);$i++){
|
|
$str.="{id:\"".$arr_dp[$i][0]."\",t:\"".$arr_dp[$i][3]."\",u:\"".$arr_dp[$i][1]."\",p:\"".$arr_dp[$i][2]."-".$arr_dp[$i][0]."\"},\n";
|
|
}
|
|
if($i>0)
|
|
$str=substr($str,0,-2);
|
|
$str.="];\n";
|
|
$js_function.=$str."\n$(function() {
|
|
$('#s_username').autocomplete(clients, {
|
|
max: 100, //列表里的条目数
|
|
minChars: 0, //自动完成激活之前填入的最小字符
|
|
width: 300, //提示的宽度，溢出隐藏
|
|
scrollHeight: 300, //提示的高度，溢出显示滚动条
|
|
matchContains: true, //包含匹配，就是data参数里的数据，是否只要包含文本框里的数据就显示
|
|
autoFill: false, //自动填充
|
|
multiple:true,
|
|
multipleSeparator:',',
|
|
formatItem: function(row, i, max) {
|
|
return row.t+'('+row.u+')';
|
|
},
|
|
formatMatch: function(row, i, max) {
|
|
return row.t + row.u;
|
|
},
|
|
formatResult: function(row) {
|
|
return row.u;
|
|
}
|
|
}).result(function(event, row, formatted) {
|
|
$('#s_username').value=row.u;
|
|
});
|
|
});";
|
|
$search_content.="店铺:<input type=text name=\"s_username\" id=\"s_username\" style=\"width:200px\" value=\"".$s_username."\"> ";
|
|
//饰品款
|
|
$search_content.="<select name=\"s_is_sp\"><option value=''>-显示饰品款-</option>".get_main_op(array("n"=>"否","y"=>"是"),$s_is_sp)."</select> ";
|
|
//推荐等级
|
|
$search_content.="<select name=\"s_brand\"><option value=''>-季节-</option>".op_select_cate1("brand",$s_brand)."</select> ";
|
|
//系列
|
|
if(check_arr_select_show("series"))
|
|
$search_content.="<select name=\"s_series\"><option value=''>-".get_cate_title_no("arr_select","series")."-</option>".op_select_cate1("series",$s_series)."</select> ";
|
|
//主题
|
|
if(check_arr_select_show("brand"))
|
|
$search_content.="<select name=\"s_brand\"><option value=''>-".get_cate_title_no("arr_select","brand")."-</option>".op_select_cate1("brand",$s_brand)."</select> ";
|
|
//波段
|
|
if(check_arr_select_show("bc"))
|
|
$search_content.="<select name=\"s_bc\"><option value=''>-".get_cate_title_no("arr_select","bc")."-</option>".op_select_cate1("bc",$s_bc)."</select> ";
|
|
//大类
|
|
if(check_arr_select_show("category"))
|
|
$search_content.="<select name=\"s_category\"><option value=''>-".get_cate_title_no("arr_select","category")."-</option>".op_select_cate1("category",$s_category)."</select> ";
|
|
//小类
|
|
if(check_arr_select_show("category1"))
|
|
$search_content.="<select name=\"s_category1\"><option value=''>-".get_cate_title_no("arr_select","category1")."-</option>".op_select_cate1("category1",$s_category1)."</select> ";
|
|
//设计师
|
|
if(check_arr_select_show("designer"))
|
|
$search_content.="<select name=\"s_designer\"><option value=''>-".get_cate_title_no("arr_select","designer")."-</option>".op_select_cate1("designer",$s_designer)."</select> ";
|
|
$search_content.="款号:<input type=\"text\" name=\"s_no\" value=\"".$s_no."\" style=\"width:60px;\"> ";
|
|
$check1=($s_hbkh=="n")?" checked":"";
|
|
$search_content.="<select name=\"s_hbkh\">".get_main_op(array("y"=>"合并款号","n"=>"不合并"),$s_hbkh)."</select>";
|
|
//字段
|
|
$zd="";
|
|
$i=0;
|
|
foreach($arr_zd as $k1 => $v1){
|
|
$zd.="<input type=\"checkbox\" name=\"s_zd[]\" value=\"".$k1."\" id=\"zd_".$k1."\"";
|
|
if(in_array($k1,$s_zd))
|
|
$zd.=" checked";
|
|
$zd.="><label for=\"zd_".$k1."\">".$v1."</label>";
|
|
}
|
|
$search_content.="<br>显示列:".$zd;
|
|
$search_content.="<input type=submit value=\"开始分析\" class=\"button_act\"> ";
|
|
//-----------------------/search
|
|
//-----------------------tab
|
|
|
|
//-----------------------/tab
|
|
$th_zd="";
|
|
for($i=0;$i<count($s_zd);$i++){
|
|
$th_zd.="<td rowspan=\"".$num_size_group."\" bgcolor=\"#f0f0f0\" align=\"center\">".get_main_value($arr_zd,$s_zd[$i])."</td>";
|
|
}
|
|
$_tbody="<tr><td rowspan=\"".$num_size_group."\" bgcolor=\"#f0f0f0\" align=\"center\">款号</td>".$th_zd."<td rowspan=\"".$num_size_group."\" bgcolor=\"#f0f0f0\" align=\"center\">颜色</td><td rowspan=\"".$num_size_group."\" bgcolor=\"#f0f0f0\" align=\"center\">颜色代码</td>";
|
|
//$_tbody.="<td rowspan=\"".$num_size_group."\" bgcolor=\"#f0f0f0\" align=\"center\" width=\"30\">版型</td>";
|
|
$_tbody.=$size_tr[0]."<td width=\"50\" rowspan=\"".$num_size_group."\" align=\"center\" bgcolor=\"#f0f0f0\">小计</td><td rowspan=\"".$num_size_group."\" width=\"60\" bgcolor=\"#f0f0f0\" align=\"center\">吊牌金额</td></tr>";
|
|
for($i=1;$i<$num_size_group;$i++){
|
|
$_tbody.="<tr>".$size_tr[$i]."</tr>";
|
|
}
|
|
//echo $sql_con."<br>";
|
|
if($is_sub=="y"){
|
|
$q="select id,iid,no,sum(".get_size_sql("sum").") 'num',bx from ".$table_pre."order ".$sql_con." group by no order by num desc";
|
|
//echo $q."<br>";
|
|
$r=$db->query($q);
|
|
$count=0;
|
|
$l=0;
|
|
$_tcontent=array();
|
|
while($m=$db->fetch_array($r)){
|
|
$list=$count+1;
|
|
$bg=($l%2)?"#f0f0f0":"#ffffff";
|
|
$m1=get_db_msg("select * from ".$table_pre."kh where id='".$m["iid"]."'");
|
|
//取得颜色,杯型
|
|
$tmp1=get_db_msg("select count(distinct color,bx) 'num',sum(num) 'xj_num',sum(je) 'xj_money' from ".$table_pre."order ".$sql_con." and no='".$m["no"]."'");
|
|
$num1=$tmp1["num"];
|
|
$q2="select ".$sql_sum_num."color,bx from ".$table_pre."order ".$sql_con." and no='".$m["no"]."' group by color,bx";
|
|
//echo $q2."<br>";
|
|
$r2=$db->query($q2);
|
|
if($s_hbkh=="y"){
|
|
//需要合并款号
|
|
$j=0;
|
|
$xj_num=$xj_money=0;
|
|
while($m2=$db->fetch_array($r2)){
|
|
$num=0;
|
|
$td_size1="";
|
|
for($k=0;$k<$num_size_total;$k++){
|
|
$ck_md=check_md($m1["no"],$m2["color"],$m2["bx"],$arr_size_merged[$k]);
|
|
if($ck_md!="n"){
|
|
$sty1="#999900";
|
|
}else{
|
|
$sty1=$bg;
|
|
}
|
|
$num+=$m2["num_".$arr_size_merged[$k]];
|
|
$td_size1.="<td bgcolor=\"".$sty1."\">".deel_td(deel_0($m2["num_".$arr_size_merged[$k]]))."</td>";
|
|
}
|
|
$money=$num*$m1["price"];
|
|
$total_num+=$num;
|
|
$total_money+=$money;
|
|
$xj_num+=$num;
|
|
$xj_money+=$money;
|
|
if($j==0){
|
|
$tmp_zd="";
|
|
for($i=0;$i<count($s_zd);$i++){
|
|
$tmp_zd.="<td bgcolor=\"".$bg."\" rowspan=\"".$num1."\">";
|
|
$tmp_zd.=($s_zd=="title" || $s_zd=="price" || $s_zd=="xh")?deel_td($m1[$s_zd[$i]]):deel_td(get_cate_title_no($s_zd[$i],$m1[$s_zd[$i]]));
|
|
$tmp_zd.="</td>";
|
|
}
|
|
//
|
|
$_tcontent[$count].="<tr height=\"25\"><td bgcolor=\"".$bg."\" rowspan=\"".$num1."\">".$m1["no"]."</td>".$tmp_zd."<td bgcolor=\"".$bg."\">".deel_td(get_cate_title_no("color",$m2["color"]))."</td><td bgcolor=\"".$bg."\">".$m2["color"]."</td>";
|
|
//$_tcontent[$count].="<td bgcolor=\"".$bg."\" align=\"center\">".get_gg_title($m2["bx"])."</td>";
|
|
$_tcontent[$count].=$td_size1."<td bgcolor=\"".$bg."\" rowspan=\"".$num1."\" align=\"right\">".$tmp1["xj_num"]."</td><td bgcolor=\"".$bg."\" rowspan=\"".$num1."\" align=\"right\">".deel_td(deel_0(deel_num($tmp1["xj_money"])))."</td></tr>";
|
|
}else{
|
|
$_tcontent[$count].="<tr height=\"25\"><td bgcolor=\"".$bg."\">".deel_td(get_cate_title_no("color",$m2["color"]))."</td><td bgcolor=\"".$bg."\">".$m2["color"]."</td>";
|
|
//$_tcontent[$count].="<td bgcolor=\"".$bg."\" align=\"center\">".get_gg_title($m2["bx"])."</td>";
|
|
$_tcontent[$count].=$td_size1."</tr>";
|
|
}
|
|
$j++;
|
|
$count++;
|
|
}
|
|
}else{
|
|
//不需要合并款号
|
|
$tmp_zd="";
|
|
for($i=0;$i<count($s_zd);$i++){
|
|
$tmp_zd.="<td bgcolor=\"".$bg."\">";
|
|
$tmp_zd.=($s_zd=="title" || $s_zd=="price" || $s_zd=="xh")?deel_td($m1[$s_zd[$i]]):deel_td(get_cate_title_no($s_zd[$i],$m1[$s_zd[$i]]));
|
|
$tmp_zd.="</td>";
|
|
}
|
|
//有多种颜色
|
|
$j=0;
|
|
while($m2=$db->fetch_array($r2)){
|
|
$num=0;
|
|
$td_size1="";
|
|
for($k=0;$k<$num_size_total;$k++){
|
|
$num+=$m2["num_".$arr_size_merged[$k]];
|
|
$td_size1.="<td bgcolor=\"".$bg."\">".deel_td(deel_0($m2["num_".$arr_size_merged[$k]]))."</td>";
|
|
}
|
|
$money=$num*$m1["price"];
|
|
$total_num+=$num;
|
|
$total_money+=$money;
|
|
$_tcontent[$count].="<tr height=\"25\"><td bgcolor=\"".$bg."\">".$m1["no"]."</td>".$tmp_zd."<td bgcolor=\"".$bg."\">".deel_td(get_cate_title_no("color",$m2["color"]))."</td><td bgcolor=\"".$bg."\">".$m2["color"]."</td>";
|
|
//$_tcontent[$count].="<td bgcolor=\"".$bg."\" align=\"center\">".get_gg_title($m2["bx"])."</td>";
|
|
$_tcontent[$count].=$td_size1."<td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($num))."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0(deel_num($money)))."</td></tr>";
|
|
$j++;
|
|
$count++;
|
|
}
|
|
}
|
|
$l++;
|
|
}
|
|
}
|
|
$hj_colspan=3;
|
|
$_tcontent[$count]="<tr height=\"25\"><td colspan=\"".(count($s_zd)+$hj_colspan+$num_size_total)."\" align=\"right\" bgcolor=\"#f0f0f0\">合计</td><td bgcolor=\"#f0f0f0\" align=\"right\">".deel_td($total_num)."</td><td bgcolor=\"#f0f0f0\" align=\"right\">".deel_td($total_money)."</td></tr>";
|
|
$_title=$title_user."订单明细(".date("Y年m月d日 H时i分").")";
|
|
$bottom_button="<input type=\"button\" name=\"s1\" value=\"打 印\" onclick=\"start_print()\">";
|
|
break;
|
|
case "ph":
|
|
$s_key=$s_key?$s_key:$_key;
|
|
$s_ka=$s_ka?$s_ka:"n";
|
|
$s_zd=$s_zd?$s_zd:array("price");
|
|
$sql_con="";
|
|
if($s_series || $s_theme || $s_kh_dj || $s_is_sp || $s_designer || $s_category || $s_category1 || $s_key || $s_no || $s_season || $s_bc || $s_ka){
|
|
if($s_designer)
|
|
$sql_con.="designer='".$s_designer."' and ";
|
|
if($s_no)
|
|
$sql_con.="no like '%".$s_no."%' and ";
|
|
if($s_kh_dj){
|
|
$sql_con.="kh_dj='".$s_kh_dj."' and ";
|
|
}
|
|
if($s_is_sp){
|
|
$sql_con.="is_sp='".$s_is_sp."' and ";
|
|
}
|
|
if($s_series){
|
|
$sql_con.="series='".$s_series."' and ";
|
|
}
|
|
if($s_theme){
|
|
$sql_con.="theme='".$s_theme."' and ";
|
|
}
|
|
if($s_category){
|
|
$sql_con.="category='".$s_category."' and ";
|
|
}
|
|
if($s_category1){
|
|
$sql_con.="category1='".$s_category1."' and ";
|
|
}
|
|
if($s_season){
|
|
$sql_con.="season='".$s_season."' and ";
|
|
}
|
|
if($s_bc){
|
|
$sql_con.="bc='".$s_bc."' and ";
|
|
}
|
|
if($s_ka){
|
|
$sql_con.="ka='".$s_ka."' and ";
|
|
}
|
|
if($s_key){
|
|
$sql_con.="_key='".$s_key."' and ";
|
|
}
|
|
}
|
|
$con_u=deel_con_u($s_username);
|
|
if($con_u)
|
|
$sql_con.=$con_u;
|
|
if($sql_con)
|
|
$sql_con="where ".substr($sql_con,0,-4);
|
|
$search_content="";
|
|
//$search_content.="<select name=\"s_key\"><option value=''>-订货标记-</option>".get_main_op($arr_key,$s_key)."</select> ";
|
|
$search_content.="<select name=\"s_ka\">".get_main_op(array("n"=>"不显示删除款","y"=>"显示删除款"),$s_ka)."</select> ";
|
|
//取得店铺框
|
|
$str="var clients = [\n";
|
|
for($i=0;$i<count($arr_dp);$i++){
|
|
$str.="{id:\"".$arr_dp[$i][0]."\",t:\"".$arr_dp[$i][3]."\",u:\"".$arr_dp[$i][1]."\",p:\"".$arr_dp[$i][2]."-".$arr_dp[$i][0]."\"},\n";
|
|
}
|
|
if($i>0)
|
|
$str=substr($str,0,-2);
|
|
$str.="];\n";
|
|
$js_function.=$str."\n$(function() {
|
|
$('#s_username').autocomplete(clients, {
|
|
max: 100, //列表里的条目数
|
|
minChars: 0, //自动完成激活之前填入的最小字符
|
|
width: 300, //提示的宽度，溢出隐藏
|
|
scrollHeight: 300, //提示的高度，溢出显示滚动条
|
|
matchContains: true, //包含匹配，就是data参数里的数据，是否只要包含文本框里的数据就显示
|
|
autoFill: false, //自动填充
|
|
multiple:true,
|
|
multipleSeparator:',',
|
|
formatItem: function(row, i, max) {
|
|
return row.t+'('+row.u+')';
|
|
},
|
|
formatMatch: function(row, i, max) {
|
|
return row.t + row.u;
|
|
},
|
|
formatResult: function(row) {
|
|
return row.u;
|
|
}
|
|
}).result(function(event, row, formatted) {
|
|
$('#s_username').value=row.u;
|
|
});
|
|
});";
|
|
$search_content.="店铺:<input type=text name=\"s_username\" id=\"s_username\" style=\"width:200px\" value=\"".$s_username."\">";
|
|
//饰品款
|
|
$search_content.="<select name=\"s_is_sp\"><option value=''>-显示饰品款-</option>".get_main_op(array("n"=>"否","y"=>"是"),$s_is_sp)."</select> ";
|
|
//推荐等级
|
|
$search_content.="<select name=\"s_kh_dj\"><option value=''>-推荐-</option>".op_select_cate1("kh_dj",$s_kh_dj)."</select> ";
|
|
//系列
|
|
if(check_arr_select_show("series"))
|
|
$search_content.="<select name=\"s_series\"><option value=''>-".get_cate_title_no("arr_select","series")."-</option>".op_select_cate1("series",$s_series)."</select> ";
|
|
//主题
|
|
if(check_arr_select_show("theme"))
|
|
$search_content.="<select name=\"s_theme\"><option value=''>-".get_cate_title_no("arr_select","theme")."-</option>".op_select_cate1("theme",$s_theme)."</select> ";
|
|
//波段
|
|
if(check_arr_select_show("bc"))
|
|
$search_content.="<select name=\"s_bc\"><option value=''>-".get_cate_title_no("arr_select","bc")."-</option>".op_select_cate1("bc",$s_bc)."</select> ";
|
|
//大类
|
|
if(check_arr_select_show("category"))
|
|
$search_content.="<select name=\"s_category\"><option value=''>-".get_cate_title_no("arr_select","category")."-</option>".op_select_cate1("category",$s_category)."</select> ";
|
|
//小类
|
|
if(check_arr_select_show("category1"))
|
|
$search_content.="<select name=\"s_category1\"><option value=''>-".get_cate_title_no("arr_select","category1")."-</option>".op_select_cate1("category1",$s_category1)."</select> ";
|
|
//设计师
|
|
if(check_arr_select_show("designer"))
|
|
$search_content.="<select name=\"s_designer\"><option value=''>-".get_cate_title_no("arr_select","designer")."-</option>".op_select_cate1("designer",$s_designer)."</select> ";
|
|
$search_content.="款号:<input type=\"text\" name=\"s_no\" value=\"".$s_no."\" style=\"width:60px;\"> ";
|
|
//字段
|
|
$zd="";
|
|
$i=0;
|
|
foreach($arr_zd as $k1 => $v1){
|
|
$zd.="<input type=\"checkbox\" name=\"s_zd[]\" value=\"".$k1."\" id=\"zd_".$k1."\"";
|
|
if(in_array($k1,$s_zd))
|
|
$zd.=" checked";
|
|
$zd.="><label for=\"zd_".$k1."\">".$v1."</label>";
|
|
}
|
|
$search_content.="<br>显示列:".$zd;
|
|
$search_content.=" <input type=submit value=\"开始分析\" class=\"button_act\"> ";
|
|
//-----------------------/search
|
|
$th_zd="";
|
|
for($i=0;$i<count($s_zd);$i++){
|
|
$th_zd.="<td align=\"center\" bgcolor=\"#dddddd\">".get_main_value($arr_zd,$s_zd[$i])."</td>";
|
|
}
|
|
$_tbody="<tr><td align=\"center\" bgcolor=\"#dddddd\" width=\"60\">排名</td><td align=\"center\" bgcolor=\"#dddddd\">款号</td>".$th_zd."<td align=\"center\" bgcolor=\"#dddddd\" width=\"70\">数量（件）</td><td align=\"center\" bgcolor=\"#dddddd\" width=\"70\">金额（元）</td></tr>";
|
|
$query="select sum(".get_size_sql("sum").") 'num',no,iid from ".$table_pre."order ".$sql_con." group by no order by num desc";
|
|
//echo $query."<br>";
|
|
$res=$db->query($query);
|
|
$count=0;
|
|
$l=0;
|
|
$_tcontent=array();
|
|
while($m=$db->fetch_array($res)){
|
|
$list=$count+1;
|
|
$bg=($l%2)?"#f0f0f0":"#ffffff";
|
|
$m1=get_db_msg("select * from ".$table_pre."kh where id='".$m["iid"]."'");
|
|
$money=$m["num"]*$m1["price"];
|
|
$total_num+=$m["num"];
|
|
$total_money+=$money;
|
|
//图片获取规则
|
|
$tmp_zd="";
|
|
for($i=0;$i<count($s_zd);$i++){
|
|
$tmp_zd.="<td bgcolor=\"".$bg."\">";
|
|
$tmp_zd.=($s_zd=="title" || $s_zd=="price" || $s_zd=="xh")?deel_td($m1[$s_zd[$i]]):deel_td(get_cate_title_no($s_zd[$i],$m1[$s_zd[$i]]));
|
|
$tmp_zd.="</td>";
|
|
}
|
|
$_tcontent[$count]="<tr height=\"25\"><td bgcolor=\"".$bg."\">".$list."</td><td bgcolor=\"".$bg."\">".$m1["no"]."</td>".$tmp_zd."<td bgcolor=\"".$bg."\"><a href=\"javascript:o_window('?_cid=".$_cid."&_m=".$_m."&_a=view_order&id=".$m1["id"]."&cid=".get_parent_id($s_jxs)."','view_order',700,600)\">".$m["num"]."</td><td bgcolor=\"".$bg."\">".$money."</td></tr>";
|
|
$count++;
|
|
$l++;
|
|
|
|
}
|
|
if(!$_tcontent)
|
|
$_tcontent[0]="<tr><td colspan=\"5\" bgcolor=\"#ffffff\">暂无记录!</td></tr>";
|
|
else
|
|
$_tcontent[$count]="<tr height=\"25\"><td colspan=\"".(2+count($s_zd))."\" align=\"right\" bgcolor=\"#dddddd\">合计</td><td bgcolor=\"#dddddd\">".$total_num."</td><td bgcolor=\"#dddddd\">".$total_money."</td></tr>";
|
|
break;
|
|
case "ph_ks":
|
|
$s_key=$s_key?$s_key:$_key;
|
|
$s_ka=$s_ka?$s_ka:"n";
|
|
$s_zd=$s_zd?$s_zd:array("price");
|
|
$sql_con="";
|
|
if($s_series || $s_theme || $s_kh_dj || $s_is_sp || $s_designer || $s_category || $s_category1 || $s_key || $s_no || $s_season || $s_bc || $s_ka){
|
|
if($s_designer)
|
|
$sql_con.="designer='".$s_designer."' and ";
|
|
if($s_no)
|
|
$sql_con.="no like '%".$s_no."%' and ";
|
|
if($s_kh_dj){
|
|
$sql_con.="kh_dj='".$s_kh_dj."' and ";
|
|
}
|
|
if($s_is_sp){
|
|
$sql_con.="is_sp='".$s_is_sp."' and ";
|
|
}
|
|
if($s_series){
|
|
$sql_con.="series='".$s_series."' and ";
|
|
}
|
|
if($s_theme){
|
|
$sql_con.="theme='".$s_theme."' and ";
|
|
}
|
|
if($s_category){
|
|
$sql_con.="category='".$s_category."' and ";
|
|
}
|
|
if($s_category1){
|
|
$sql_con.="category1='".$s_category1."' and ";
|
|
}
|
|
if($s_season){
|
|
$sql_con.="season='".$s_season."' and ";
|
|
}
|
|
if($s_bc){
|
|
$sql_con.="bc='".$s_bc."' and ";
|
|
}
|
|
if($s_ka){
|
|
$sql_con.="ka='".$s_ka."' and ";
|
|
}
|
|
if($s_key){
|
|
$sql_con.="_key='".$s_key."' and ";
|
|
}
|
|
}
|
|
$con_u=deel_con_u($s_username);
|
|
if($con_u)
|
|
$sql_con.=$con_u;
|
|
if($sql_con)
|
|
$sql_con="where ".substr($sql_con,0,-4);
|
|
$search_content="";
|
|
//$search_content.="<select name=\"s_key\"><option value=''>-订货标记-</option>".get_main_op($arr_key,$s_key)."</select> ";
|
|
$search_content.="<select name=\"s_ka\">".get_main_op(array("n"=>"不显示删除款","y"=>"显示删除款"),$s_ka)."</select> ";
|
|
//取得店铺框
|
|
$str="var clients = [\n";
|
|
for($i=0;$i<count($arr_dp);$i++){
|
|
$str.="{id:\"".$arr_dp[$i][0]."\",t:\"".$arr_dp[$i][3]."\",u:\"".$arr_dp[$i][1]."\",p:\"".$arr_dp[$i][2]."-".$arr_dp[$i][0]."\"},\n";
|
|
}
|
|
if($i>0)
|
|
$str=substr($str,0,-2);
|
|
$str.="];\n";
|
|
$js_function.=$str."$(function() {
|
|
$('#s_username').autocomplete(clients, {
|
|
max: 100, //列表里的条目数
|
|
minChars: 0, //自动完成激活之前填入的最小字符
|
|
width: 300, //提示的宽度，溢出隐藏
|
|
scrollHeight: 300, //提示的高度，溢出显示滚动条
|
|
matchContains: true, //包含匹配，就是data参数里的数据，是否只要包含文本框里的数据就显示
|
|
autoFill: false, //自动填充
|
|
multiple:true,
|
|
multipleSeparator:',',
|
|
formatItem: function(row, i, max) {
|
|
return row.t+'('+row.u+')';
|
|
},
|
|
formatMatch: function(row, i, max) {
|
|
return row.t + row.u;
|
|
},
|
|
formatResult: function(row) {
|
|
return row.u;
|
|
}
|
|
}).result(function(event, row, formatted) {
|
|
$('#s_username').value=row.u;
|
|
});
|
|
});";
|
|
$search_content.="店铺:<input type=text name=\"s_username\" id=\"s_username\" style=\"width:200px\" value=\"".$s_username."\">";
|
|
//饰品款
|
|
$search_content.="<select name=\"s_is_sp\"><option value=''>-显示饰品款-</option>".get_main_op(array("n"=>"否","y"=>"是"),$s_is_sp)."</select> ";
|
|
//推荐等级
|
|
$search_content.="<select name=\"s_kh_dj\"><option value=''>-推荐-</option>".op_select_cate1("kh_dj",$s_kh_dj)."</select> ";
|
|
//系列
|
|
if(check_arr_select_show("series"))
|
|
$search_content.="<select name=\"s_series\"><option value=''>-".get_cate_title_no("arr_select","series")."-</option>".op_select_cate1("series",$s_series)."</select> ";
|
|
if(check_arr_select_show("theme"))
|
|
$search_content.="<select name=\"s_theme\"><option value=''>-".get_cate_title_no("arr_select","theme")."-</option>".op_select_cate1("theme",$s_theme)."</select> ";
|
|
//波段
|
|
if(check_arr_select_show("bc"))
|
|
$search_content.="<select name=\"s_bc\"><option value=''>-".get_cate_title_no("arr_select","bc")."-</option>".op_select_cate1("bc",$s_bc)."</select> ";
|
|
//大类
|
|
if(check_arr_select_show("category"))
|
|
$search_content.="<select name=\"s_category\"><option value=''>-".get_cate_title_no("arr_select","category")."-</option>".op_select_cate1("category",$s_category)."</select> ";
|
|
//小类
|
|
if(check_arr_select_show("category1"))
|
|
$search_content.="<select name=\"s_category1\"><option value=''>-".get_cate_title_no("arr_select","category1")."-</option>".op_select_cate1("category1",$s_category1)."</select> ";
|
|
//设计师
|
|
if(check_arr_select_show("designer"))
|
|
$search_content.="<select name=\"s_designer\"><option value=''>-".get_cate_title_no("arr_select","designer")."-</option>".op_select_cate1("designer",$s_designer)."</select> ";
|
|
$search_content.="款号:<input type=\"text\" name=\"s_no\" value=\"".$s_no."\" style=\"width:60px;\"> ";
|
|
//字段
|
|
$zd="";
|
|
$i=0;
|
|
foreach($arr_zd as $k1 => $v1){
|
|
$zd.="<input type=\"checkbox\" name=\"s_zd[]\" value=\"".$k1."\" id=\"zd_".$k1."\"";
|
|
if(in_array($k1,$s_zd))
|
|
$zd.=" checked";
|
|
$zd.="><label for=\"zd_".$k1."\">".$v1."</label>";
|
|
}
|
|
$search_content.="<br>显示列:".$zd;
|
|
$search_content.=" <input type=submit value=\"开始分析\" class=\"button_act\"> ";
|
|
//-----------------------/search
|
|
$th_zd="";
|
|
for($i=0;$i<count($s_zd);$i++){
|
|
$th_zd.="<td align=\"center\" bgcolor=\"#dddddd\">".get_main_value($arr_zd,$s_zd[$i])."</td>";
|
|
}
|
|
$_tbody="<tr><td align=\"center\" bgcolor=\"#dddddd\" width=\"60\">排名</td><td align=\"center\" bgcolor=\"#dddddd\">款号</td><td align=\"center\" bgcolor=\"#dddddd\">颜色</td>".$th_zd."<td align=\"center\" bgcolor=\"#dddddd\" width=\"70\">数量（件）</td><td align=\"center\" bgcolor=\"#dddddd\" width=\"70\">金额（元）</td></tr>";
|
|
$query="select sum(".get_size_sql("sum").") 'num',no,iid,color from ".$table_pre."order ".$sql_con." group by no,color order by num desc";
|
|
//echo $query."<br>";
|
|
$res=$db->query($query);
|
|
$count=0;
|
|
$l=0;
|
|
$_tcontent=array();
|
|
while($m=$db->fetch_array($res)){
|
|
$list=$count+1;
|
|
$bg=($l%2)?"#f0f0f0":"#ffffff";
|
|
$m1=get_db_msg("select * from ".$table_pre."kh where id='".$m["iid"]."'");
|
|
$money=$m["num"]*$m1["price"];
|
|
$total_num+=$m["num"];
|
|
$total_money+=$money;
|
|
$tmp_zd="";
|
|
for($i=0;$i<count($s_zd);$i++){
|
|
$tmp_zd.="<td bgcolor=\"".$bg."\">";
|
|
$tmp_zd.=($s_zd=="title" || $s_zd=="price" || $s_zd=="xh")?deel_td($m1[$s_zd[$i]]):deel_td(get_cate_title_no($s_zd[$i],$m1[$s_zd[$i]]));
|
|
$tmp_zd.="</td>";
|
|
}
|
|
$_tcontent[$count]="<tr height=\"25\"><td bgcolor=\"".$bg."\">".$list."</td><td bgcolor=\"".$bg."\">".$m1["no"]."</td><td bgcolor=\"".$bg."\">".$m["color"]."-".deel_td(get_cate_title_no("color",$m["color"]))."</td>".$tmp_zd."<td bgcolor=\"".$bg."\"><a href=\"javascript:o_window('?_cid=".$_cid."&_m=".$_m."&_a=view_order&id=".$m1["id"]."&cid=".get_parent_id($s_jxs)."&color=".$m["color"]."','view_order',700,600)\">".$m["num"]."</td><td bgcolor=\"".$bg."\">".$money."</td></tr>";
|
|
$count++;
|
|
$l++;
|
|
|
|
}
|
|
if(!$_tcontent)
|
|
$_tcontent[0]="<tr><td colspan=\"6\" bgcolor=\"#ffffff\">暂无记录!</td></tr>";
|
|
else
|
|
$_tcontent[$count]="<tr height=\"25\"><td colspan=\"".(3+count($s_zd))."\" align=\"right\" bgcolor=\"#dddddd\">合计</td><td bgcolor=\"#dddddd\">".$total_num."</td><td bgcolor=\"#dddddd\">".$total_money."</td></tr>";
|
|
break;
|
|
case "gl":
|
|
$arr1=array("qy"=>"省代","dl"=>"客户");
|
|
$check_md=get_db_msg("select count(*) 'num' from ".$table_pre."kh_md");
|
|
//是否显示吊牌金额
|
|
if($zk_type || $check_md["num"]>0)
|
|
$show_jsje="y";
|
|
else
|
|
$show_jsje="n";
|
|
$arr_group_by["uid"]="店铺";
|
|
foreach($arr1 as $k1 => $v1){
|
|
$arr_group_by[$k1]=$v1;
|
|
}
|
|
if(check_arr_select_show("series"))
|
|
$arr_group_by["series"]=get_cate_title_no("arr_select","series");
|
|
if(check_arr_select_show("theme"))
|
|
$arr_group_by["theme"]=get_cate_title_no("arr_select","theme");
|
|
if(check_arr_select_show("bc"))
|
|
$arr_group_by["bc"]=get_cate_title_no("arr_select","bc");
|
|
if(check_arr_select_show("category"))
|
|
$arr_group_by["category"]=get_cate_title_no("arr_select","category");
|
|
if(check_arr_select_show("category1"))
|
|
$arr_group_by["category1"]=get_cate_title_no("arr_select","category1");
|
|
if(check_arr_select_show("designer"))
|
|
$arr_group_by["designer"]=get_cate_title_no("arr_select","designer");
|
|
$s_key=$s_key?$s_key:$_key;
|
|
$s_ka=$s_ka?$s_ka:"n";
|
|
$s_group_by=$s_group_by?$s_group_by:"uid";
|
|
$s_order=$s_order?$s_order:"num";
|
|
//-----------------------search
|
|
$search_content="";
|
|
//$search_content.="<select name=\"s_key\"><option value=''>-订货标记-</option>".get_main_op($arr_key,$s_key)."</select> ";
|
|
$search_content.="<select name=\"s_ka\">".get_main_op(array("n"=>"非删除款","y"=>"删除款"),$s_ka)."</select> ";
|
|
$search_content.="请选择分类依据：<select name=\"s_group_by\">".get_main_op($arr_group_by,$s_group_by)."</select> ";
|
|
if($s_group_by=="uid"){
|
|
$search_content.="<select name=\"s_brand\"><option value=''>-所有".get_cate_title_no("arr_select","brand")."-</option>".op_select_cate1("brand",$s_brand)."</select>";
|
|
$search_content.="<select name=\"s_is_checked\"><option value=''>-订单是否确认-</option>".get_main_op(array("y"=>"是","n"=>"否"),$s_is_checked)."</select> ";
|
|
$_tbody="<tr><td align=\"center\" bgcolor=\"#dddddd\" width=\"40\">序号</td><td align=\"center\" bgcolor=\"#dddddd\">区域</td><td align=\"center\" bgcolor=\"#dddddd\">代理</td><td align=\"center\" bgcolor=\"#dddddd\">类型</td>";
|
|
$_tbody.="<td align=\"center\" bgcolor=\"#dddddd\">店铺代码</td><td align=\"center\" bgcolor=\"#dddddd\">店铺名称</td><td align=\"center\" bgcolor=\"#dddddd\" width=\"50\">订单数量</td><td align=\"center\" bgcolor=\"#dddddd\" width=\"60\">吊牌金额</td>";
|
|
if($s_brand==""){
|
|
$_tbody.="<td align=\"center\" bgcolor=\"#dddddd\" width=\"60\">金额指标<td align=\"right\" bgcolor=\"#dddddd\" width=\"50\">完成率</td>";
|
|
}
|
|
$_tbody.="</tr>";
|
|
}else if($s_group_by=="qy" || $s_group_by=="dl"){
|
|
$_tbody="<tr><td align=\"center\" bgcolor=\"#dddddd\" width=\"40\">序号</td>";
|
|
$_tbody.="<td align=\"center\" bgcolor=\"#dddddd\">登陆代码</td><td align=\"center\" bgcolor=\"#dddddd\">名称</td><td align=\"center\" bgcolor=\"#dddddd\" width=\"50\">自营数量</td><td align=\"center\" bgcolor=\"#dddddd\" width=\"50\">自营金额</td><td align=\"center\" bgcolor=\"#dddddd\" width=\"50\">分销数量</td><td align=\"center\" bgcolor=\"#dddddd\" width=\"50\">分销金额</td><td align=\"center\" bgcolor=\"#dddddd\" width=\"50\">合计数量</td><td align=\"center\" bgcolor=\"#dddddd\" width=\"60\">合计金额</td>";
|
|
$_tbody.="<td align=\"center\" bgcolor=\"#dddddd\" width=\"60\">指标</td>";
|
|
$_tbody.="<td align=\"right\" bgcolor=\"#dddddd\" width=\"50\">完成率</td>";
|
|
$_tbody.="</tr>";
|
|
}else{
|
|
//设计师
|
|
$_tbody="<tr><td align=\"center\" bgcolor=\"#dddddd\">序号</td><td align=\"center\" bgcolor=\"#dddddd\">".get_main_value($arr_group_by,$s_group_by)."</td><td align=\"center\" bgcolor=\"#dddddd\" width=\"50\">设计款数</td><td align=\"center\" bgcolor=\"#dddddd\" width=\"50\">订单数量</td><td align=\"center\" bgcolor=\"#dddddd\" width=\"70\">订单金额</td>";
|
|
$_tbody.="</tr>";
|
|
//取得店铺框
|
|
$str="var clients = [\n";
|
|
for($i=0;$i<count($arr_dp);$i++){
|
|
$str.="{id:\"".$arr_dp[$i][0]."\",t:\"".$arr_dp[$i][3]."\",u:\"".$arr_dp[$i][1]."\",p:\"".$arr_dp[$i][2]."-".$arr_dp[$i][0]."\"},\n";
|
|
}
|
|
if($i>0)
|
|
$str=substr($str,0,-2);
|
|
$str.="];\n";
|
|
$js_function.=$str."$(function() {
|
|
$('#s_dp').autocomplete(clients, {
|
|
max: 100, //列表里的条目数
|
|
minChars: 0, //自动完成激活之前填入的最小字符
|
|
width: 400, //提示的宽度，溢出隐藏
|
|
scrollHeight: 300, //提示的高度，溢出显示滚动条
|
|
matchContains: true, //包含匹配，就是data参数里的数据，是否只要包含文本框里的数据就显示
|
|
autoFill: false, //自动填充
|
|
formatItem: function(row, i, max) {
|
|
return row.t+'('+row.u+')';
|
|
},
|
|
formatMatch: function(row, i, max) {
|
|
return row.t + row.u;
|
|
},
|
|
formatResult: function(row) {
|
|
return row.u;
|
|
}
|
|
}).result(function(event, row, formatted) {
|
|
$('#s_dp').value=row.u;
|
|
});
|
|
});";
|
|
$search_content.="客户: <input type=text name=\"s_dp\" id=\"s_dp\" style=\"width:80px\" onfocus=\"this.select()\" value=\"".$s_dp."\">";
|
|
}
|
|
$search_content.="<select name=\"s_order\">".get_main_op(array("num"=>"按数量排序","je"=>"按金额排序"),$s_order)."</select> ";
|
|
$search_content.=" <input type=submit value=\"开始分析\" class=\"button_act\"> ";
|
|
//-----------------------/search
|
|
$tmp_sql_con=$con_u_all;
|
|
if($s_brand)
|
|
$tmp_sql_con.="brand='".$s_brand."' and ";
|
|
if($s_group_by=="qy" || $s_group_by=="dl"){
|
|
$q="select qy,dl,sum(num) 'num',sum(je) 'je' from ".$table_pre."order where ".$tmp_sql_con." ka='".$s_ka."' and ".$s_group_by."<>'' group by ".$s_group_by." order by ".$s_order." desc";
|
|
}else{
|
|
$q="select season,category,category1,series,theme,designer,bc,uid,upath,sum(".get_size_sql("sum").") 'num',sum((".get_size_sql("sum").")*price) 'je' from ".$table_pre."order where ".$tmp_sql_con." ka='".$s_ka."' group by ".$s_group_by." order by ".$s_order." desc";
|
|
}
|
|
$r=$db->query($q);
|
|
//echo $q."<br>";
|
|
$count=$l=$total_num=$total_money=0;
|
|
$total_sjks=0;
|
|
$_tcontent=array();
|
|
$flag1=($is_spk=="y")?"1":"";
|
|
$total_zb_js=$total_zb_je=0;
|
|
while($m=$db->fetch_array($r)){
|
|
if($s_group_by=="uid"){
|
|
//店铺
|
|
$m1=get_db_msg("select * from ".$table_pre."client where id='".$m["uid"]."'");
|
|
if(!$s_is_checked || ($s_is_checked=="y" && $m1["is_checked"]=="y") || ($s_is_checked=="n" && $m1["is_checked"]!="y")){
|
|
//
|
|
$list=$count+1;
|
|
$m_qy=get_db_msg("select title from ".$table_pre."client where id='".get_qy_id($m["upath"])."'");
|
|
$m_dl=get_db_msg("select title from ".$table_pre."client where id='".get_dl_id($m["upath"])."'");
|
|
$bg=($l%2)?"#f0f0f0":"#ffffff";
|
|
if($s_brand){
|
|
$sql_tmp1=" and brand='".$s_brand."'";
|
|
}else{
|
|
$sql_tmp1="";
|
|
}
|
|
$m2=get_db_msg("select sum(num) 'order_num',sum(je) 'order_money' from ".$table_pre."order where ka='".$s_ka."' and uid='".$m["uid"]."'".$sql_tmp1);
|
|
if($s_brand){
|
|
//不显示完成率
|
|
$ydjs=$m2["order_num"];
|
|
$ydje=$m2["order_money"];
|
|
$td_zb="";
|
|
}else{
|
|
$ydjs=$m2["order_num"];
|
|
$ydje=$m2["order_money"];
|
|
$zb=$m1["zb"]*10000;
|
|
$total_zb_je+=$zb;
|
|
$wcl=deel_bfb1($ydje,$zb,1);
|
|
$td_zb="<td bgcolor=\"".$bg."\" align=\"right\">".deel_td($zb)."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($wcl))."</td>";
|
|
}
|
|
$_tcontent[$count]="<tr height=\"25\"><td bgcolor=\"".$bg."\" width=\"60\">".$list."</td><td bgcolor=\"".$bg."\" align=\"left\">".deel_td($m_qy["title"])."</td><td bgcolor=\"".$bg."\" align=\"left\">".deel_td($m_dl["title"])."</td><td bgcolor=\"".$bg."\" align=\"left\">".deel_td($m1["lx"])."</td>";
|
|
$_tcontent[$count].="<td bgcolor=\"".$bg."\" align=\"left\">".$m1["username"]."</td><td bgcolor=\"".$bg."\" align=\"left\">".$m1["title"]."</td><td bgcolor=\"".$bg."\" align=\"right\"><a href=\"".$_SERVER[PHP_SELF]."?_m=".$_m."&_cid=".$_cid."&_a=detail&s_username=".$m1["username"]."&is_sub=y\">".$ydjs."</a></td><td bgcolor=\"".$bg."\" align=\"right\">".deel_num($ydje)."</td>";
|
|
$_tcontent[$count].=$td_zb;
|
|
$_tcontent[$count].="</tr>";
|
|
$total_num+=$ydjs;
|
|
$total_money+=$ydje;
|
|
$count++;
|
|
$l++;
|
|
}
|
|
}else if($s_group_by=="qy"|| $s_group_by=="dl"){
|
|
//客户分组
|
|
$m1=get_db_msg("select * from ".$table_pre."client where id='".$m[$s_group_by]."'");
|
|
$list=$count+1;
|
|
$bg=($l%2)?"#f0f0f0":"#ffffff";
|
|
//指标
|
|
$zb=$zb_style=$wcl="";
|
|
$td_zb="";
|
|
$wcl=deel_bfb1($m1["order_money"],$m1["zb"]*10000,1);
|
|
$ydje=$m["je"];
|
|
$zb=$m1["zb"]*10000;
|
|
$total_zb_je+=$zb;
|
|
$td_zb.="<td bgcolor=\"".$bg."\" align=\"right\">".deel_td($zb)."</td>";
|
|
$ydjs=$m["num"];
|
|
//取得直营和加盟的订单
|
|
if($s_brand)
|
|
$tmp_sql1=" and o.brand='".$s_brand."'";
|
|
else
|
|
$tmp_sql1="";
|
|
$q2="select c.lx 'lx',sum(o.num) 'num',sum(o.je) 'je' from ".$table_pre."order o,".$table_pre."client c where (c.path='".$m1["path"]."-".$m1["id"]."' or c.path like '".$m1["path"]."-".$m1["id"]."-%') and c.id=o.uid and c.face='4' and o.ka='".$s_ka."'".$tmp_sql1." and o.".$s_group_by."<>'' group by o.uid";
|
|
//echo $q2."<br>";
|
|
$r2=$db->query($q2);
|
|
$zy_num=$zy_je=0;
|
|
$jm_num=$ydjs;
|
|
$jm_je=$ydje;
|
|
while($m2=$db->fetch_array($r2)){
|
|
if($m2["lx"]=="自营"){
|
|
$zy_num+=$m2["num"];
|
|
$zy_je+=$m2["je"];
|
|
$jm_num-=$m2["num"];
|
|
$jm_je-=$m2["je"];
|
|
}
|
|
}
|
|
$_tcontent[$count]="<tr height=\"25\">";
|
|
$_tcontent[$count].="<td bgcolor=\"".$bg."\" align=\"left\">".$list."</td><td bgcolor=\"".$bg."\" align=\"left\">".$m1["username"]."</td><td bgcolor=\"".$bg."\" align=\"left\">".$m1["title"]."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_num($zy_num)."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_num($zy_je)."</td><td bgcolor=\"".$bg."\" align=\"right\">".$jm_num."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_num($jm_je)."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_num($ydjs)."</td><td bgcolor=\"".$bg."\" align=\"right\">".deel_num($ydje)."</td>";
|
|
$_tcontent[$count].=$td_zb;
|
|
$_tcontent[$count].="<td bgcolor=\"".$bg."\" align=\"right\">".deel_td(deel_0($wcl))."</td></tr>";
|
|
$total_num+=$ydjs;
|
|
$total_money+=$ydje;
|
|
$total_num_zy+=$zy_num;
|
|
$total_money_zy+=$zy_je;
|
|
$total_num_jm+=$jm_num;
|
|
$total_money_jm+=$jm_je;
|
|
$count++;
|
|
$l++;
|
|
}else{
|
|
//设计师分组
|
|
$list=$count+1;
|
|
$gtitle=get_cate_title_no($s_group_by,$m[$s_group_by]);
|
|
$bg=($l%2)?"#f0f0f0":"#ffffff";
|
|
//取得设计款数
|
|
$tmp=get_db_msg("select count(*) 'num' from ".$table_pre."kh where ".$s_group_by."='".$m[$s_group_by]."'");
|
|
$sjks=$tmp["num"];
|
|
$total_sjks+=$sjks;
|
|
$_tcontent[$count]="<tr height=\"25\"><td bgcolor=\"".$bg."\" width=\"60\">".$list."</td><td bgcolor=\"".$bg."\" align=\"left\">".deel_td($gtitle)."</td><td bgcolor=\"".$bg."\" align=\"right\">".$sjks." </td><td bgcolor=\"".$bg."\" align=\"right\">".$m["num"]." </td><td bgcolor=\"".$bg."\" align=\"right\">".$m["je"]." </td></tr>";
|
|
$total_num+=$m["num"];
|
|
$total_money+=$m["je"];
|
|
$count++;
|
|
$l++;
|
|
}
|
|
|
|
}
|
|
if(!$_tcontent){
|
|
//
|
|
//$colspan1=($s_group_by=="uid")?"9":"5";
|
|
//$_tcontent[0]="<tr><td colspan=\"".($colspan1+1)."\" bgcolor=\"#ffffff\">暂无记录!</td></tr>";
|
|
}else{
|
|
$_tcontent[$count]="<tr height=\"25\">";
|
|
if($s_group_by=="uid"){
|
|
//客户分组
|
|
$hj_colspan=6;
|
|
$_tcontent[$count]="<td colspan=\"".$hj_colspan."\" align=\"right\" bgcolor=\"#dddddd\">合计</td><td bgcolor=\"#dddddd\" align=\"right\">".$total_num."</td><td bgcolor=\"#dddddd\" align=\"right\">".$total_money."</td>";
|
|
$wcl="";
|
|
if($s_brand==""){
|
|
$wcl=deel_bfb1($total_money,$total_zb_je,1);
|
|
$_tcontent[$count].="<td bgcolor=\"#dddddd\" align=\"right\">".deel_td(deel_num($total_zb_je))."</td><td bgcolor=\"#dddddd\" align=\"right\">".deel_td(deel_0($wcl))."</td>";
|
|
}
|
|
}else if($s_group_by=="qy" || $s_group_by=="dl"){
|
|
$hj_colspan=3;
|
|
$_tcontent[$count]="<td colspan=\"".$hj_colspan."\" align=\"right\" bgcolor=\"#dddddd\">合计</td><td bgcolor=\"#dddddd\" align=\"right\">".$total_num_zy."</td><td bgcolor=\"#dddddd\" align=\"right\">".$total_money_zy."</td><td bgcolor=\"#dddddd\" align=\"right\">".$total_num_jm."</td><td bgcolor=\"#dddddd\" align=\"right\">".$total_money_jm."</td><td bgcolor=\"#dddddd\" align=\"right\">".$total_num."</td><td bgcolor=\"#dddddd\" align=\"right\">".$total_money."</td>";
|
|
$wcl="";
|
|
$_tcontent[$count].="<td bgcolor=\"#dddddd\" align=\"right\">".deel_td(deel_num($total_zb_je))."</td>";
|
|
$wcl=deel_bfb1($total_money,$total_zb_je,1);
|
|
$_tcontent[$count].="<td bgcolor=\"#dddddd\" align=\"right\">".deel_td(deel_0($wcl))."</td>";
|
|
}else{
|
|
//设计师分组
|
|
$_tcontent[$count]="<td colspan=\"2\" align=\"right\" bgcolor=\"#dddddd\">合计</td><td bgcolor=\"#dddddd\" align=\"right\">".$total_sjks." </td><td bgcolor=\"#dddddd\" align=\"right\">".$total_num." </td><td bgcolor=\"#dddddd\" align=\"right\">".$total_money." </td>";
|
|
}
|
|
$_tcontent[$count].="</tr>";
|
|
}
|
|
$bottom_button="<input type=\"button\" value=\"导 出\" onclick=\"js_export('main_table');\">";
|
|
break;
|
|
}
|
|
if($_a!="view_order"){
|
|
//-----------------------tab
|
|
$tab_content=array();
|
|
$i=0;
|
|
foreach($arr_report as $k => $v){
|
|
if($k==$_a)
|
|
$tab_content[$i][0]="_1";
|
|
else
|
|
$tab_content[$i][0]="";
|
|
$tab_content[$i][1]="<a href=\"".$_SERVER[PHP_SELF]."?_cid=".$_cid."&_m=".$_m."&_a=".$k."\">".$v."</a>";
|
|
$i++;
|
|
}
|
|
//-----------------------/tab
|
|
$_title=$_title?$_title:$_title_;
|
|
include template("report");
|
|
}
|
|
?>
|