'sx' and no<>'zd1' and no<>'zd2' and no<>'zd3' order by ord"; $r=$db->query($q); while($m=$db->fetch_array($r)){ $arr_select_no[]=$m["no"]; $arr_select_title[]=$m["title"]; } $con=""; for($i=0;$i0?$s_ph_num:0; if($s_ph_ms=="ph_ds"){ $con_group_by="no,color"; $hj_colspan=5; }else{ $con_group_by="no"; $hj_colspan=5; } $kh_ph_num=get_set("kh_ph_num"); $kh_ph_num=$kh_ph_num>0?$kh_ph_num:10; $s_order=$s_order?$s_order:"num"; $s_desc=$s_desc?$s_desc:"d1"; //$content_search.=" "; //排行模式 if(count($arr_ph_ms)>1){ $content_search.="".get_main_op($arr_op_ph_ms,$s_ph_ms)." "; } //区域 $op=""; $q="select * from ".$table_pre."client where face='9' and deep=1 order by ord"; $r=$db->query($q); $i=0; $arr_op=array(); $arr_op[""]="区域过滤"; while($m=$db->fetch_array($r)){$op.="1){ $search_select_no[$i1]="s_ph_ms"; $search_select_op[$i1]=$arr_op_ph_ms; $i1++; } //区域选项 if($i>0){ $search_select_no[$i1]="s_qy"; $search_select_op[$i1]=$arr_op; $i1++; } //选项前面 $select_qm=""; $arr_sz=array(); for($i=0;$i$value){ $tmp.="{\"no\":\"".$key."\",\"title\":\"".$value."\"},"; $arr_sz[$i]=$value; } $tmp=deel_end($tmp); $var=$search_select_no[$i]; $select_qm.="{\"no\":\"".$search_select_no[$i]."\",\"title\":\"".$search_select_op[$i][0]."\",\"value\":\"".$$var."\",\"op\":[".$tmp."]},"; } $select_qm=deel_end($select_qm); $json_data.="\"select_qm\":[".$select_qm."],"; //取得定制选项 $select_dz=""; for($i=0;$iquery("select no,title from ".$table_pre."keyword where cate='".$arr_select_no[$i]."' order by no"); while($m1=$db->fetch_array($r1)){ $tmp.="{\"no\":\"".$m1["no"]."\",\"title\":\"".$m1["title"]."\"},"; } $tmp=deel_end($tmp); $var="s_".$arr_select_no[$i]; $select_dz.="{\"no\":\"".$arr_select_no[$i]."\",\"title\":\"".$arr_select_title[$i]."\",\"value\":\"".$$var."\",\"op\":[".$tmp."]},"; } $select_dz=deel_end($select_dz); $json_data.="\"select_dz\":[".$select_dz."],"; $search_select_op=$search_select_no=array(); $i1=0; $search_select_no[$i1]="s_desc"; $search_select_op[$i1]=array("d1"=>"正序","d2"=>"倒序"); $i1++; $search_select_no[$i1]="s_order"; $search_select_op[$i1]=array("num"=>"数量排序","je"=>"金额排序"); $i1++; $order_ph=($s_desc=="d1")?" desc":""; //选项后 $select_hm=""; $arr_sz=array(); for($i=0;$i$value){ $tmp.="{\"no\":\"".$key."\",\"title\":\"".$value."\"},"; $arr_sz[$i]=$value; } $tmp=deel_end($tmp); $var=$search_select_no[$i]; $select_hm.="{\"no\":\"".$search_select_no[$i]."\",\"title\":\"".$search_select_op[$i][0]."\",\"value\":\"".$$var."\",\"op\":[".$tmp."]},"; } $select_hm=deel_end($select_hm); $json_data.="\"select_hm\":[".$select_hm."],\"jzsj\":\"截止".date("m-d日H:i")."\",\"s_kh\":\"".$s_kh."\",\"s_yph\":\"".$s_yph."\","; if($s_ph_ms=="ph_ds"){ $con_kc=""; foreach($sys_color_zd as $k1 => $v1){ $v="s_color_".$k1; if($$v) $con_kc.=" and kc.".$k1."='".$$v."'"; //$content_search.="-".$v1."-".op_select_cate_color($k1,$$v)." "; } } // $content_search.="".get_main_op(array("num"=>"数量排序","je"=>"金额排序"),$s_order)." 截止".date("m-d日H:i"); // $content="

"; $json_data.="\"table_top\":[\"|次序\",\"全国排名\",\"this|款号\","; if($s_ph_ms=="ph_ds"){ $content.=""; $group_by_ph1="no,color"; $json_data.="\"颜色\","; }else{ //取得色总排名 $arr_ph_color=array(); $q1="select sum(num) 'num',sum(je) 'je' from ".$table_pre."ph group by no,color order by ".$s_order." desc"; $r1=$db->query($q1); while($m1=$db->fetch_array($r1)){ $arr_ph_color[]=$m1[$s_order]; } $content.=""; $json_data.="\"颜色/色总排名\","; $group_by_ph1="no"; } //取得全国排名数组 $arr_ph=array(); $q1="select sum(num) 'num',sum(je) 'je',".$group_by_ph1." from ".$table_pre."ph group by ".$group_by_ph1." order by ".$s_order." ".$order_ph.""; $r1=$db->query($q1); $arr_qgdl=array(); while($m1=$db->fetch_array($r1)){ $arr_ph[]=$m1[$s_order]; if($s_ph_ms=="ph_ds"){ $arr_qgdl[$m1["no"]."_".$m1["color"]]=$m1["num"]; }else{ $arr_qgdl[$m1["no"]]=$m1["num"]; } } //$content.=""; if($sys_ver_hy=="xz"){ $json_data.="\"".d_translate("dpj")."\",\"件数\",\"箱数\",\"".d_translate("dpje")."\"],"; }else{ $json_data.="\"".d_translate("dpj")."\",\"件数\",\"".d_translate("dpje")."\"],"; } $json_data1=""; $con1=""; if($s_kh) $con1.=" and no like '%".$s_kh."%'"; if($s_yph){ if($xh_ms=="2"){ $tkh=get_db_msg("select * from ".$table_pre."kh_xh where xh='".$s_yph."'"); $con1.=" and no='".$tkh["kh"]."' and color='".$tkh["color"]."'"; }else{ $tkh=get_db_msg("select * from ".$table_pre."kh where xh='".$s_yph."'"); $con1.=" and no='".$tkh["no"]."'"; } } //if($s_qy) //$con1.=" and (qy='".$s_qy."')"; for($i=0;$i0 ".$con1.$con_kc." group by ".$con_group_by." order by ".$s_order." desc"; $q1="select sum(num) 'num',sum(je) 'je',iid,color from ".$table_pre."ph where id>0 ".$con1." group by ".$con_group_by." order by ".$s_order." ".$order_ph.""; $r1=$db->query($q1); while($m1=$db->fetch_array($r1)){ $page_total_num++; } if(!$page) $page=1; $pages=ceil($page_total_num/$page_num); $limit_con=($page-1)*$page_num; $count=$limit_con; //$q="select sum(num) 'num',sum(je) 'je',p.iid,p.color from ".$table_pre."ph p left join ".$table_pre."kh_color kc on kc.iid=p.iid and kc.color=p.color where p.id>0 ".$con1.$con_kc." group by ".$con_group_by." order by ".$s_order." desc limit ".$limit_con.",".$page_num.""; if($s_qy){ $q="select sum(case when qy='".$s_qy."' then num else 0 end) 'num' ,sum(case when qy='".$s_qy."' then je else 0 end) 'je',iid,color from ".$table_pre."ph where id>0 ".$con1." group by ".$con_group_by." order by ".$s_order." ".$order_ph." limit ".$limit_con.",".$page_num.""; }else{ $q="select sum(num) 'num',sum(je) 'je',iid,color from ".$table_pre."ph where id>0 ".$con1." group by ".$con_group_by." order by ".$s_order." ".$order_ph." limit ".$limit_con.",".$page_num.""; } //echo $q." "; $r=$db->query($q); $total_num=$total_money=$count_yd=0; while($m=$db->fetch_array($r)){ $c1=($count%2)?"td1":"td2"; $list=$count+1; $m1=get_db_msg("select id,no,main_pic,color,xh,size_group from ".$table_pre."kh where id='".$m["iid"]."'"); if($sys_ver_hy=="xz"){ $xs=0; if($s_ph_ms=="ph_ds"){ $tmpxs=get_db_msg("select sum(xs) xs from ".$table_pre."order_pm where iid='".$m["iid"]."' and color='".$m["color"]."'"); $xs=$tmpxs["xs"]; }else{ $tmpxs=get_db_msg("select sum(xs) xs from ".$table_pre."order_pm where iid='".$m["iid"]."' "); $xs=$tmpxs["xs"]; } } $num=$m["num"]; if($num>0) $count_yd++; $total_num+=$num; $money=$m["je"]; $total_money+=$money; //图片获取规则 if($s_ph_ms=="ph_ds"){ $pic=get_kh_color_picture($m1["no"],$m["color"],$flag_pad_offline); $pic2=get_kh_color_picture_big($m1["no"],$m["color"]); }else{ $pic=get_kh_picture($m1["no"],$m1["main_pic"],$m1["color"],$flag_pad_offline); $pic="'".$pic."' ".str_replace("\"","'",out_good_pic_set($pic,80,80))." border=0"; $pic2=get_kh_picture_big($m1["no"],$m1["main_pic"],$m1["color"],$flag_pad_offline); } if($s_ph_ms=="ph_ds"){ $dl=$arr_qgdl[$m1["no"]."_".$m["color"]]; }else{ $dl=$arr_qgdl[$m1["no"]]; } $pm=get_main_key($arr_ph,$dl)+1; if($s_ph_ms=="ph_ds"){ //到色 $tmp_arr=explode(",",$m1["color"]); $color_flag=""; if(count($tmp_arr)>1){ for($i1=0;$i1".$tmp_arr[$i1]."-".get_cate_title_no("color",$tmp_arr[$i1]).","; } if($color_flag) $color_flag=" (".substr($color_flag,0,-1).")"; } $content.=""; $content.=""; $href_color="&color=".$m["color"]; $json_data1.="[\"".$m1["id"]."\",\"".$list."\",\"pma|".$pm."\",\"this|".get_kh_xh($m1,$m["color"])."|".$m1["id"]."|".$pic."|".$m1["no"]."|".$pic2."\","; $json_data1.="\"".$m["color"]."-".get_cate_title_no("color",$m["color"])."\","; }else{ $json_data1.="[\"".$m1["id"]."\",\"".$list."\",\"pma|".$pm."\",\"this|".get_kh_xh($m1,$m["color"])."|".$m1["id"]."|".$pic."|".$m1["no"]."|".$pic2."\","; $content.=""; //取得颜色 $q2="select color,sum(num) 'num',sum(je) 'je' from ".$table_pre."ph where iid='".$m["iid"]."' group by color order by ".$s_order." desc"; $r2=$db->query($q2); $str_color=""; while($m2=$db->fetch_array($r2)){ $str_color.=$m2["color"]."-".get_cate_title_no("color",$m2["color"])." / ".(get_main_key($arr_ph_color,$m2[$s_order])+1)." "; } if($str_color) $str_color=substr($str_color,0,-4); $content.=""; $json_data1.="\"".$str_color."\","; $href_color=""; } if($s_ph_ms=="ph_ds") $colors=$m["color"]; else $colors=""; $content.=""; $content.=""; if($sys_ver_hy=="xz"){ $json_data1.="\"".get_price_dp($uid,$m1["id"])."\",\"jianshu|".$m["num"]."|".$m1["no"]."|".$colors."\",\"".deel_num($xs)."\",\"".deel_num($m["je"])."\"],"; }else{ if($m1["size_group"]==$child_sizegroup_id){ $qa="select * from ".$table_pre."size_bx where no='".$m1["no"]."' order by id"; $ra=$db->query($qa); $str_tzbx=""; while($ma=$db->fetch_array($ra)){ $str_tzbx.=$ma["bx"].":".$ma["price"]." "; } $json_data1.="\"".$str_tzbx."\",\"jianshu|".$m["num"]."|".$m1["no"]."|".$colors."\",\"".deel_num($m["je"])."\"],"; }else{ $json_data1.="\"".get_price_dp($uid,$m1["id"])."\",\"jianshu|".$m["num"]."|".$m1["no"]."|".$colors."\",\"".deel_num($m["je"])."\"],"; } } $count++; } $json_data.="\"pages\":\"".$pages."\",\"table_mid\":[".substr($json_data1,0,-1)."],"; $content.=" 次序 全国排名 ".d_translate("xh")." 款号 颜色 颜色/色总排名 ".d_translate("dpj")." 件数 ".d_translate("dpje")." ".$list." ".$pm." ".get_kh_xh($m1,$m["color"])." ".$m1["no"].$color_flag." ".$m["color"]."-".get_cate_title_no("color",$m["color"])." ".$list." ".$pm." ".get_kh_xh($m1)." ".$m1["no"]." ".$str_color." ".$m["num"]." ".deel_num($m["je"])."

"; break; case "2": if($arr_ph_ms[0]!=""){ $json_data.="\"is_ph_state\":\"ok\","; $arr_op_ph_ms=array(); for($i=0;$i0?$s_ph_num:0; if($s_ph_ms=="ph_ds"){ $con_group_by="no,color"; $hj_colspan=5; }else{ $con_group_by="no"; $hj_colspan=5; } $kh_ph_num=get_set("kh_ph_num"); $kh_ph_num=$kh_ph_num>0?$kh_ph_num:10; $s_order=$s_order?$s_order:"num"; //区域 $op=""; $q="select id,title from ".$table_pre."client where face='9' order by title"; $r=$db->query($q); $i=0; $arr_op=array(); $arr_op[""]="区域过滤"; while($m=$db->fetch_array($r)){ $arr_op[$m["id"]]=$m["title"]; $i++; } $i1=0; //排行模式 if(count($arr_ph_ms)>1){ $search_select_no[$i1]="s_ph_ms"; $search_select_op[$i1]=$arr_op_ph_ms; $i1++; } //区域选项 if($i>0){ $search_select_no[$i1]="s_qy"; $search_select_op[$i1]=$arr_op; $i1++; } //选项前面 $select_qm=""; $arr_sz=array(); for($i=0;$i$value){ $tmp.="{\"no\":\"".$key."\",\"title\":\"".$value."\"},"; $arr_sz[$i]=$value; } $tmp=deel_end($tmp); $var=$search_select_no[$i]; $select_qm.="{\"no\":\"".$search_select_no[$i]."\",\"title\":\"".$search_select_op[$i][0]."\",\"value\":\"".$$var."\",\"op\":[".$tmp."]},"; } $select_qm=deel_end($select_qm); $json_data.="\"select_qm\":[".$select_qm."],\"select_hm\":[],"; //取得定制选项 $select_dz=""; for($i=0;$iquery("select no,title from ".$table_pre."keyword where cate='".$arr_select_no[$i]."' order by no"); while($m1=$db->fetch_array($r1)){ $tmp.="{\"no\":\"".$m1["no"]."\",\"title\":\"".$m1["title"]."\"},"; } $tmp=deel_end($tmp); $var="s_".$arr_select_no[$i]; $select_dz.="{\"no\":\"".$arr_select_no[$i]."\",\"title\":\"".$arr_select_title[$i]."\",\"value\":\"".$$var."\",\"op\":[".$tmp."]},"; } $select_dz=deel_end($select_dz); $json_data.="\"select_dz\":[".$select_dz."],"; // $content="

"; $json_data.="\"table_top\":[\"|次序\",\"全国排名\",\"this|款号\","; //如果启用多品牌 if($s_brand && $is_brand=="y") $con_brand1=" where brand='".$s_brand."'"; else $con_brand1=""; // if($s_ph_ms=="ph_ds"){ $content.=""; $json_data.="\"颜色\","; $group_by_ph1="no,color"; }else{ //取得色总排名 $arr_ph_color=array(); $q1="select sum(num) 'num',sum(je) 'je' from ".$table_pre."ph ".$con_brand1." group by no,color order by ".$s_order." desc"; $r1=$db->query($q1); while($m1=$db->fetch_array($r1)){ $arr_ph_color[]=$m1[$s_order]; } $content.=""; $json_data.="\"颜色/色总排名\","; $group_by_ph1="no"; } //取得全国排名数组 $arr_ph=array(); $ctt=1; $q1="select sum(num) 'num',sum(je) 'je',".$group_by_ph1." from ".$table_pre."ph ".$con_brand1." group by ".$group_by_ph1." order by ".$s_order." desc"; $r1=$db->query($q1); $arr_qgdl=array(); while($m1=$db->fetch_array($r1)){ //$arr_ph[]=$m1[$s_order]; /*if($s_ph_ms=="ph_ds"){ $arr_qgdl[$m1["no"]."_".$m1["color"]]=$ctt; }else{ $arr_qgdl[$m1["no"]]=$ctt; } $ctt++;*/ $arr_ph[]=$m1[$s_order]; if($s_ph_ms=="ph_ds"){ $arr_qgdl[$m1["no"]."_".$m1["color"]]=$m1["num"]; }else{ $arr_qgdl[$m1["no"]]=$m1["num"]; } } $content.=""; $json_data.="\"".d_translate("dpj")."\"],"; $con1=""; if($s_no) $con1.="no like '%".$s_no."%' and "; //if($s_qy) //$con1.="qy='".$s_qy."' and "; for($i=0;$iquery($q1); while($m1=$db->fetch_array($r1)){ $page_total_num++; } if(!$page) $page=1; $pages=ceil($page_total_num/$page_num); $limit_con=($page-1)*$page_num; //$q="select sum(num) 'num',sum(je) 'je',iid,color from ".$table_pre."ph ".$con1." group by ".$con_group_by." order by ".$s_order." desc limit ".$limit_con.",".$page_num; if($s_qy){ $q="select sum(case when qy='".$s_qy."' then num else 0 end) 'num' ,sum(case when qy='".$s_qy."' then je else 0 end) 'je',iid,color from ".$table_pre."ph ".$con1." group by ".$con_group_by." order by ".$s_order." desc limit ".$limit_con.",".$page_num.""; }else{ $q="select sum(num) 'num',sum(je) 'je',iid,color from ".$table_pre."ph ".$con1." group by ".$con_group_by." order by ".$s_order." desc limit ".$limit_con.",".$page_num.""; } //echo $q." "; $r=$db->query($q); $total_num=$total_money=$count_yd=0; $count=$limit_con; while($m=$db->fetch_array($r)){ $m1=get_db_msg("select * from ".$table_pre."kh where id='".$m["iid"]."'"); if($s_ph_ms=="ph_ds"){ $dl=$arr_qgdl[$m1["no"]."_".$m["color"]]; }else{ $dl=$arr_qgdl[$m1["no"]]; } //$pm=$dl; $pm=get_main_key($arr_ph,$dl)+1; //if($pm<=$s_ph_num){ $c1=($count%2)?"td1":"td2"; $list=$count+1; $num=$m["num"]; if($num>0) $count_yd++; $total_num+=$num; $money=$m["je"]; $total_money+=$money; //图片获取规则 if($s_ph_ms=="ph_ds"){ $pic=get_kh_color_picture($m1["no"],$m["color"],$flag_pad_offline); $pic2=get_kh_color_picture_big($m1["no"],$m["color"]); }else{ $pic=get_kh_picture($m1["no"],$m1["main_pic"],$m1["color"],$flag_pad_offline); $pic="'".$pic."' ".str_replace("\"","'",out_good_pic_set($pic,80,80))." border=0"; $pic2=get_kh_picture_big($m1["no"],$m1["main_pic"],$m1["color"],$flag_pad_offline); } $json_data1.="[\"".$m1["id"]."\",\"".$list."\",\"pma|".$pm."\",\"this|".get_kh_xh($m1,$m["color"])."|".$m1["id"]."|".$pic."|".$m1["no"]."|".$pic2."\","; if($s_ph_ms=="ph_ds"){ $json_data1.="\"".$m["color"]."-".get_cate_title_no("color",$m["color"])."\","; }else{ //取得颜色 $q2="select color,sum(num) 'num',sum(je) 'je' from ".$table_pre."ph where iid='".$m["iid"]."' group by color order by ".$s_order." desc"; $r2=$db->query($q2); $str_color="color|"; while($m2=$db->fetch_array($r2)){ $str_color.=$m2["color"]."-".get_cate_title_no("color",$m2["color"])." / ".(get_main_key($arr_ph_color,$m2[$s_order])+1)."|"; } if($str_color) $str_color=substr($str_color,0,-1); $json_data1.="\"".$str_color."\","; } if($m1["size_group"]==$child_sizegroup_id){ $qa="select * from ".$table_pre."size_bx where no='".$m1["no"]."' order by id"; $ra=$db->query($qa); $str_tzbx=""; while($ma=$db->fetch_array($ra)){ $str_tzbx.=$ma["bx"].":".$ma["price"]." "; } $json_data1.="\"".$str_tzbx."\"],"; }else{ $json_data1.="\"".get_price_dp($uid,$m1["id"])."\"],"; } $count++; //} } $json_data.="\"pages\":\"".$pages."\",\"table_mid\":[".substr($json_data1,0,-1)."],"; }else{ $json_data.="\"is_ph_state\":\"nook\","; $json_data.="\"pages\":\"0\","; } break; case "3": if($arr_ph_ms[0]!=""){ $json_data.="\"is_ph_state\":\"ok\","; $arr_op_ph_ms=array(); for($i=0;$i0?$s_ph_num:0; if($s_ph_ms=="ph_ds"){ $con_group_by="no,color"; $hj_colspan=5; }else{ $con_group_by="no"; $hj_colspan=5; } $kh_ph_num=get_set("kh_ph_num"); $kh_ph_num=$kh_ph_num>0?$kh_ph_num:10; $s_order=$s_order?$s_order:"num"; //区域 $op=""; $q="select id,title from ".$table_pre."client where face='9' order by title"; $r=$db->query($q); $i=0; $arr_op=array(); $arr_op[""]="区域过滤"; while($m=$db->fetch_array($r)){ $arr_op[$m["id"]]=$m["title"]; $i++; } $i1=0; //排行模式 if(count($arr_ph_ms)>1){ $search_select_no[$i1]="s_ph_ms"; $search_select_op[$i1]=$arr_op_ph_ms; $i1++; } //区域选项 if($i>0){ $search_select_no[$i1]="s_qy"; $search_select_op[$i1]=$arr_op; $i1++; } //选项前面 $select_qm=""; $arr_sz=array(); for($i=0;$i$value){ $tmp.="{\"no\":\"".$key."\",\"title\":\"".$value."\"},"; $arr_sz[$i]=$value; } $tmp=deel_end($tmp); $var=$search_select_no[$i]; $select_qm.="{\"no\":\"".$search_select_no[$i]."\",\"title\":\"".$search_select_op[$i][0]."\",\"value\":\"".$$var."\",\"op\":[".$tmp."]},"; } $select_qm=deel_end($select_qm); $json_data.="\"select_qm\":[".$select_qm."],\"select_hm\":[],"; //取得定制选项 $select_dz=""; for($i=0;$iquery("select no,title from ".$table_pre."keyword where cate='".$arr_select_no[$i]."' order by no"); while($m1=$db->fetch_array($r1)){ $tmp.="{\"no\":\"".$m1["no"]."\",\"title\":\"".$m1["title"]."\"},"; } $tmp=deel_end($tmp); $var="s_".$arr_select_no[$i]; $select_dz.="{\"no\":\"".$arr_select_no[$i]."\",\"title\":\"".$arr_select_title[$i]."\",\"value\":\"".$$var."\",\"op\":[".$tmp."]},"; } $select_dz=deel_end($select_dz); $json_data.="\"select_dz\":[".$select_dz."],"; // $content=" 次序 全国排名 ".d_translate("xh")." 款号 颜色 颜色/色总排名 ".d_translate("dpj")." "; $json_data.="\"table_top\":[\"|次序\",\"全国排名\",\"this|款号\","; //如果启用多品牌 if($s_brand && $is_brand=="y") $con_brand1=" where brand='".$s_brand."'"; else $con_brand1=""; // if($s_ph_ms=="ph_ds"){ $content.=""; $json_data.="\"颜色\","; $group_by_ph1="no,color"; }else{ //取得色总排名 $arr_ph_color=array(); $q1="select sum(num) 'num',sum(je) 'je' from ".$table_pre."ph ".$con_brand1." group by no,color order by ".$s_order." desc"; $r1=$db->query($q1); while($m1=$db->fetch_array($r1)){ $arr_ph_color[]=$m1[$s_order]; } $content.=""; $json_data.="\"颜色/色总排名\","; $group_by_ph1="no"; } //取得全国排名数组 $arr_ph=array(); $ctt=1; $q1="select sum(num) 'num',sum(je) 'je',".$group_by_ph1." from ".$table_pre."ph ".$con_brand1." group by ".$group_by_ph1." order by ".$s_order." desc"; $r1=$db->query($q1); $arr_qgdl=array(); while($m1=$db->fetch_array($r1)){ //$arr_ph[]=$m1[$s_order]; /*if($s_ph_ms=="ph_ds"){ $arr_qgdl[$m1["no"]."_".$m1["color"]]=$ctt; }else{ $arr_qgdl[$m1["no"]]=$ctt; } $ctt++;*/ $arr_ph[]=$m1[$s_order]; if($s_ph_ms=="ph_ds"){ $arr_qgdl[$m1["no"]."_".$m1["color"]]=$m1["num"]; }else{ $arr_qgdl[$m1["no"]]=$m1["num"]; } } $content.=""; $json_data.="\"".d_translate("dpj")."\"],"; $con1=""; if($s_no) $con1.="no like '%".$s_no."%' and "; //if($s_qy) //$con1.="qy='".$s_qy."' and "; for($i=0;$iquery($q1); while($m1=$db->fetch_array($r1)){ $page_total_num++; } if(!$page) $page=1; $pages=ceil($page_total_num/$page_num); $limit_con=($page-1)*$page_num; //$q="select sum(num) 'num',sum(je) 'je',iid,color from ".$table_pre."ph ".$con1." group by ".$con_group_by." order by ".$s_order." desc limit ".$limit_con.",".$page_num; if($s_qy){ $q="select sum(case when qy='".$s_qy."' then num else 0 end) 'num' ,sum(case when qy='".$s_qy."' then je else 0 end) 'je',iid,color from ".$table_pre."ph ".$con1." group by ".$con_group_by." order by ".$s_order." desc limit ".$limit_con.",".$page_num.""; }else{ $q="select sum(num) 'num',sum(je) 'je',iid,color from ".$table_pre."ph ".$con1." group by ".$con_group_by." order by ".$s_order." desc limit ".$limit_con.",".$page_num.""; } //echo $q." "; $r=$db->query($q); $total_num=$total_money=$count_yd=0; $count=$limit_con; while($m=$db->fetch_array($r)){ $m1=get_db_msg("select * from ".$table_pre."kh where id='".$m["iid"]."'"); if($s_ph_ms=="ph_ds"){ $dl=$arr_qgdl[$m1["no"]."_".$m["color"]]; }else{ $dl=$arr_qgdl[$m1["no"]]; } //$pm=$dl; $pm=get_main_key($arr_ph,$dl)+1; if($pm<=$s_ph_num){ $c1=($count%2)?"td1":"td2"; $list=$count+1; $num=$m["num"]; if($num>0) $count_yd++; $total_num+=$num; $money=$m["je"]; $total_money+=$money; //图片获取规则 if($s_ph_ms=="ph_ds"){ $pic=get_kh_color_picture($m1["no"],$m["color"],$flag_pad_offline); $pic2=get_kh_color_picture_big($m1["no"],$m["color"]); }else{ $pic=get_kh_picture($m1["no"],$m1["main_pic"],$m1["color"],$flag_pad_offline); $pic="'".$pic."' ".str_replace("\"","'",out_good_pic_set($pic,80,80))." border=0"; $pic2=get_kh_picture_big($m1["no"],$m1["main_pic"],$m1["color"],$flag_pad_offline); } $json_data1.="[\"".$m1["id"]."\",\"".$list."\",\"pma|".$pm."\",\"this|".get_kh_xh($m1,$m["color"])."|".$m1["id"]."|".$pic."|".$m1["no"]."|".$pic2."\","; if($s_ph_ms=="ph_ds"){ $json_data1.="\"".$m["color"]."-".get_cate_title_no("color",$m["color"])."\","; }else{ //取得颜色 $q2="select color,sum(num) 'num',sum(je) 'je' from ".$table_pre."ph where iid='".$m["iid"]."' group by color order by ".$s_order." desc"; $r2=$db->query($q2); $str_color="color|"; while($m2=$db->fetch_array($r2)){ $str_color.=$m2["color"]."-".get_cate_title_no("color",$m2["color"])." / ".(get_main_key($arr_ph_color,$m2[$s_order])+1)."|"; } if($str_color) $str_color=substr($str_color,0,-1); $json_data1.="\"".$str_color."\","; } if($m1["size_group"]==$child_sizegroup_id){ $qa="select * from ".$table_pre."size_bx where no='".$m1["no"]."' order by id"; $ra=$db->query($qa); $str_tzbx=""; while($ma=$db->fetch_array($ra)){ $str_tzbx.=$ma["bx"].":".$ma["price"]." "; } $json_data1.="\"".$str_tzbx."\"],"; }else{ $json_data1.="\"".get_price_dp($uid,$m1["id"])."\"],"; } $count++; } } $json_data.="\"pages\":\"".$pages."\",\"table_mid\":[".substr($json_data1,0,-1)."],"; }else{ $json_data.="\"is_ph_state\":\"nook\","; $json_data.="\"pages\":\"0\","; } break; case "4": //-------------------------------------------------------------------------店铺角色 $is_spk=get_set("is_spk"); $con_spk=($is_spk=="y")?" and is_sp<>'y'":""; if($_a=="get_new"){ //获取完成率和已订件数，传递参数khid //完成率 //已订金额和件数 $tmp=get_db_msg("select sum(je) 'je',sum(jsje) 'jsje',sum(num) 'num' from ".$table_pre."order where ka<>'y'".$con_spk." and uid='".$uid."' and _key='".$_key."'"); $ydje=$tmp["je"]; $ydjsje=$tmp["jsje"]; $ydjs=$tmp["num"]; if($is_brand=="y"){ $tmp=get_db_msg("select sum(zb) 'zb',sum(zb_js) 'zb_js' from ".$table_pre."client_brand where cid='".$uid."'"); $zb1=$tmp["zb"]*10000; $zb=deel_num($tmp["zb"]); $zb_js=$tmp["zb_js"]; }else{ $zb1=$msg_login["zb"]*10000; $zb=deel_num($msg_login["zb"]); $zb_js=$msg_login["zb_js"]; } $wcl=deel_bfb1($ydje,$zb1,1); $wcl_js=deel_bfb1($ydjs,$zb_js,1); if($khid){ $tmp=get_db_msg("select sum(num) 'num' from ".$table_pre."order where uid='".$uid."' and iid='".$khid."' and _key='".$_key."'"); $k_ydjs=$tmp["num"]; }else{ $k_ydjs=0; } //该款已订件数 $zb_client_show=get_set("zb_client_show"); $json_data.="\"ydjs\":\"".$k_ydjs."\","; $json_data.="\"zb_client_show\":\"".$zb_client_show."\","; //订货信息 $json_data.="\"order_num\":\"".$ydjs."\",\"order_je\":\"".$ydje."\",\"order_jsje\":\"".$ydjsje."\","; //指标信息 $json_data.="\"zb_je\":\"".$zb."\",\"wcl_je\":\"".$wcl."\",\"zb_js\":\"".$zb_js."\",\"wcl_js\":\"".$wcl_js."\","; if($khid && $ms=="1"){ $num_my=get_order_num_kh($khid); $money1=get_order_je_kh($khid); $money_my=deel_0($money1[0]); //取得我的排行 $arr_my_ph_num=array(); $q1="select sum(num) 'num' from ".$table_pre."order where ka<>'y' and uid='".$uid."' group by no order by num desc"; //echo $q1." "; $r1=$db->query($q1); while($m1=$db->fetch_array($r1)){ $arr_my_ph_num[]=$m1["num"]; } $arr_my_ph_num=array_unique($arr_my_ph_num); if($num_my>0){ $ph_my2=get_main_key($arr_my_ph_num,$num_my); $ph_my2++; }else{ $ph_my2=""; } } if($khid && $ms=="2"){ //取得我的排行 $arr_my_ph_num=array(); $q1="select sum(num) 'num' from ".$table_pre."order where ka<>'y' and uid='".$uid."' group by no,color order by num desc"; //echo $q1." "; $r1=$db->query($q1); while($m1=$db->fetch_array($r1)){ $arr_my_ph_num[]=$m1["num"]; } $arr_my_ph_num=array_unique($arr_my_ph_num); $check=get_db_msg("select color from web_kh where id='".$khid."'"); $str=explode(",",$check["color"]); foreach($str as $value){ $num_my=get_order_num_kh_color($khid,$value); $money1=get_order_je_kh_color($khid,$value); $money_my=deel_0($money1[0]); if($num_my>0){ $ph_my2=get_main_key($arr_my_ph_num,$num_my); $ph_my2++; }else{ $ph_my2=""; } $json_data1.="\"".$value."\","; $json_data2.="\"".$num_my."\","; $json_data3.="\"".$money_my."\","; $json_data4.="\"".$ph_my2."\","; } } //该款已订件数,金额 echo $json_data.="\"ydjsa\":\"".$num_my."\",\"ydjea\":\"".$money_my."\",\"ph_my2\":\"".$ph_my2."\",\"ds_ph_my2\":[".substr($json_data4,0,-1)."],\"ds_color\":[".substr($json_data1,0,-1)."],\"ds_num\":[".substr($json_data2,0,-1)."],\"ds_je\":[".substr($json_data3,0,-1)."]}"; exit; } if($arr_ph_ms[0]!=""){ $json_data.="\"is_ph_state\":\"ok\","; // $arr_op_ph_ms=array(); for($i=0;$i0?$s_ph_num:0; if($s_ph_ms=="ph_ds"){ $con_group_by="no,color"; $hj_colspan=6; }else{ $con_group_by="no"; $hj_colspan=6; } $s_order=$s_order?$s_order:"num"; $s_desc=$s_desc?$s_desc:"d1"; //我的排行表过滤区域条件 if($s_qy && $s_qy!="-all-") $str1=" and qy='".$s_qy."'"; else $str1=""; $con112=str_replace($str1,"",$con); //区域 $op=""; $q="select id,title from ".$table_pre."client where face='9' order by title"; $r=$db->query($q); $i=0; $arr_op=array(); $arr_op["-all-"]="区域过滤"; while($m=$db->fetch_array($r)){ $arr_op[$m["id"]]=$m["title"]; $i++; } $i1=0; //排行模式 if(count($arr_ph_ms)>1){ $search_select_no[$i1]="s_ph_ms"; $search_select_op[$i1]=$arr_op_ph_ms; $i1++; } //区域选项 if($i>0){ $search_select_no[$i1]="s_qy"; $search_select_op[$i1]=$arr_op; $i1++; } //饰品款过滤 if($is_spk=="y"){ $search_select_no[$i1]="s_is_sp"; $search_select_op[$i1]=array(""=>"含".d_translate("spk"),"n"=>"不含".d_translate("spk"),"y"=>"仅".d_translate("spk")); $i1++; } //选项前面 $select_qm=""; $arr_sz=array(); for($i=0;$i$value){ $tmp.="{\"no\":\"".$key."\",\"title\":\"".$value."\"},"; $arr_sz[$i]=$value; } $tmp=deel_end($tmp); $var=$search_select_no[$i]; $select_qm.="{\"no\":\"".$search_select_no[$i]."\",\"title\":\"".$search_select_op[$i][0]."\",\"value\":\"".$$var."\",\"op\":[".$tmp."]},"; } $select_qm=deel_end($select_qm); $json_data.="\"select_qm\":[".$select_qm."],"; //取得定制选项 $select_dz=""; for($i=0;$iquery("select no,title from ".$table_pre."keyword where cate='".$arr_select_no[$i]."' order by no"); while($m1=$db->fetch_array($r1)){ $tmp.="{\"no\":\"".$m1["no"]."\",\"title\":\"".$m1["title"]."\"},"; } $tmp=deel_end($tmp); $var="s_".$arr_select_no[$i]; $select_dz.="{\"no\":\"".$arr_select_no[$i]."\",\"title\":\"".$arr_select_title[$i]."\",\"value\":\"".$$var."\",\"op\":[".$tmp."]},"; } $select_dz=deel_end($select_dz); $json_data.="\"select_dz\":[".$select_dz."],"; $i1=0; $search_select_no=array(); $search_select_op=array(); if($s_ph_ms=="ph_ds"){ $con_kc=""; foreach($sys_color_zd as $k1 => $v1){ $v="s_color_".$k1; if($$v) $con_kc.=" and kc.".$k1."='".$$v."'"; $r1=$db->query("select ".$k1." from ".$table_pre."kh_color where ".$k1."<>'' group by ".$k1." order by ".$k1); $search_select_no[$i1]=$v; $search_select_op[$i1][""]=$v1."过滤"; while($m1=$db->fetch_array($r1)){ $search_select_op[$i1][$m1[$k1]]=$m1[$k1]; } $i1++; } } // $search_select_no[$i1]="s_desc"; $search_select_op[$i1]=array("d1"=>"前".$s_ph_num."名","d2"=>"后".$s_ph_num."名"); $i1++; $search_select_no[$i1]="s_order"; $search_select_op[$i1]=array("num"=>"数量排序","je"=>"金额排序"); $i1++; //选项后 $select_hm=""; $arr_sz=array(); for($i=0;$i$value){ $tmp.="{\"no\":\"".$key."\",\"title\":\"".$value."\"},"; $arr_sz[$i]=$value; } $tmp=deel_end($tmp); $var=$search_select_no[$i]; $select_hm.="{\"no\":\"".$search_select_no[$i]."\",\"title\":\"".$search_select_op[$i][0]."\",\"value\":\"".$$var."\",\"op\":[".$tmp."]},"; } $select_hm=deel_end($select_hm); $json_data.="\"select_hm\":[".$select_hm."],"; // //表头 $json_data.="\"table_top\":[\"|全国排名\",\"this|款号\","; $content_thead[0]="\"w:40|序号\",\"w:60|全国 排名\",\"w:40|".d_translate("xh")."\",\"款号\","; //如果启用多品牌 if($s_brand && $is_brand=="y") $con_brand1=" where brand='".$s_brand."'"; else $con_brand1=""; // if($s_ph_ms=="ph_ds"){ $content_thead[0].="\"颜色\","; $json_data.="\"颜色\","; $group_by_ph1="no,color"; }else{ $content_thead[0].="\"颜色/色总排名\","; $json_data.="\"颜色/色总排名\","; //取得色总排名 $arr_ph_color=array(); $q1="select sum(num) 'num',sum(je) 'je' from ".$table_pre."ph ".$con_brand1." group by no,color order by ".$s_order." desc"; $r1=$db->query($q1); while($m1=$db->fetch_array($r1)){ $arr_ph_color[]=$m1[$s_order]; } $group_by_ph1="no"; } //取得全国排名数组 $arr_ph=array(); $ctt=1; $q1="select sum(num) 'num',sum(je) 'je',".$group_by_ph1." from ".$table_pre."ph ".$con_brand1." group by ".$group_by_ph1." order by ".$s_order." desc"; $r1=$db->query($q1); $arr_qgdl=array(); while($m1=$db->fetch_array($r1)){ //$arr_ph[]=$m1[$s_order]; /*if($s_ph_ms=="ph_ds"){ $arr_qgdl[$m1["no"]."_".$m1["color"]]=$ctt; }else{ $arr_qgdl[$m1["no"]]=$ctt; } $ctt++;*/ $arr_ph[]=$m1[$s_order]; if($s_ph_ms=="ph_ds"){ $arr_qgdl[$m1["no"]."_".$m1["color"]]=$m1["num"]; }else{ $arr_qgdl[$m1["no"]]=$m1["num"]; } } $content_thead[0].="\"w:50|".d_translate("dpj")."\",\"w:60|我的排名\",\"w:60|我的数量\",\"w:60|".d_translate("dpje")."\""; $json_data.="\"".d_translate("dpj")."\",\"我的排名\",\"我的数量\",\"".d_translate("dpje")."\"],"; // $content_tbody=array(); $ds_tbody=array(); $json_data.="\"table_mid\":["; $order_ph=($s_desc=="d1")?" desc":""; //取得款号总数 $tmp=get_db_msg("select count(distinct ".$con_group_by.") 'num' from ".$table_pre."ph where no<>'' ".$con); $total_kh=$tmp["num"]; //取得我的排行 $ctt2=1; $arr_my_ph_num=array(); $q1="select sum(num) 'num',sum(je) 'je',".$con_group_by." from ".$table_pre."order where ka<>'y' and uid='".$uid."' and _key='".$_key."' ".$con112." group by ".$con_group_by." order by ".$s_order." desc"; //echo $q1." "; $r1=$db->query($q1); while($m1=$db->fetch_array($r1)){ //$arr_my_ph_num[]=$m1["num"]; if($s_ph_ms=="ph_ds"){ $arr_my_ph_num[$m1["no"]."_".$m1["color"]]=$ctt2; }else{ $arr_my_ph_num[$m1["no"]]=$ctt2; } $ctt2++; } //$arr_my_ph_num=array_unique($arr_my_ph_num); // //$q1="select iid,no,color,sum(num) 'num',sum(je) 'je' from (select p.iid,p.no,p.color,num,je from ".$table_pre."ph p left join ".$table_pre."kh_color kc on kc.iid=p.iid and kc.color=p.color where num>0 ".$con.$con_kc." group by no,color) b group by ".$con_group_by." order by ".$s_order.$order_ph." limit 0,".$s_ph_num; $q1="select iid,no,color,sum(num) 'num',sum(je) 'je' from ".$table_pre."ph where num>0 ".$con." group by ".$con_group_by." order by ".$s_order.$order_ph." limit 0,".$s_ph_num; $r1=$db->query($q1); while($m1=$db->fetch_array($r1)){ $page_total_num++; } if($page_total_num>=$s_ph_num) $page_total_num=$s_ph_num; $pages=ceil($page_total_num/$page_num); if(!$page) $page=1; $limit_con=($page-1)*$page_num; //$q="select iid,no,color,sum(num) 'num',sum(je) 'je' from (select p.iid,p.no,p.color,num,je from ".$table_pre."ph p left join ".$table_pre."kh_color kc on kc.iid=p.iid and kc.color=p.color where num>0 ".$con.$con_kc." group by no,color) b group by ".$con_group_by." order by ".$s_order.$order_ph." limit ".$limit_con.",".$page_num.""; $q="select iid,no,color,sum(num) 'num',sum(je) 'je' from ".$table_pre."ph where num>0 ".$con." group by ".$con_group_by." order by ".$s_order.$order_ph." limit ".$limit_con.",".$page_num.""; //echo $q." "; $total_num=$total_money=$count=0; $count_my=$count_total=0; $r=$db->query($q); while($m=$db->fetch_array($r)){ $m1=get_db_msg("select id,no,xh,main_pic,color,size_group from ".$table_pre."kh where id='".$m["iid"]."'"); if($s_ph_ms=="ph_ds"){ $dl=$arr_qgdl[$m1["no"]."_".$m["color"]]; }else{ $dl=$arr_qgdl[$m1["no"]]; } //$pm=$dl; $pm=get_main_key($arr_ph,$dl)+1; if($s_desc=="d2" || ($pm<=$s_ph_num && $s_desc=="d1")){ $sty2=($count%2)?"td2":"td1"; $list=$page_num*($page-1)+$count+1; $price1=get_price_dp($uid,$m1["id"]); if($s_ph_ms=="ph_ds"){ $num_my=get_order_num_kh_color($m["iid"],$m["color"]); $money1=get_order_je_kh_color($m["iid"],$m["color"]); $money_my=$money1[0]; }else{ $num_my=get_order_num_kh($m1["id"]); $money1=get_order_je_kh($m["iid"]); $money_my=$money1[0]; } $total_num+=$num_my; $total_money+=$money_my; $ph_my=""; if($num_my>0){ if($s_ph_ms=="ph_ds"){ $ph_my=$arr_my_ph_num[$m1["no"]."_".$m["color"]]; }else{ $ph_my=$arr_my_ph_num[$m1["no"]]; } //$ph_my++; $count_my++; } if($list<11){ if($s_ph_ms=="ph_ds"){ $pic=get_kh_color_picture($m1["no"],$m["color"],$flag_pad_offline); $pic2=get_kh_color_picture_big($m1["no"],$m["color"]); }else{ $pic=get_kh_picture($m1["no"],$m1["main_pic"],$m1["color"],$flag_pad_offline); $pic="'".$pic."' ".str_replace("\"","'",out_good_pic_set($pic,80,80))." border=0"; $pic2=get_kh_picture_big($m1["no"],$m1["main_pic"],$m1["color"],$flag_pad_offline); } }else{ if($s_ph_ms=="ph_ds"){ $pic=get_kh_color_picture($m1["no"],$m["color"],$flag_pad_offline); $pic2=get_kh_color_picture_big($m1["no"],$m["color"]); }else{ $pic=get_kh_picture($m1["no"],$m1["main_pic"],$m1["color"],$flag_pad_offline); $pic="'".$pic."' ".str_replace("\"","'",out_good_pic_set($pic,80,80))." border=0"; $pic2=get_kh_picture_big($m1["no"],$m1["main_pic"],$m1["color"],$flag_pad_offline); } } if($s_ph_ms=="ph_ds"){ //排行到色 $tmp_arr=explode(",",$m1["color"]); $color_flag=""; if(count($tmp_arr)>1){ for($i1=0;$i1query($q2); $str_color=""; while($m2=$db->fetch_array($r2)){ $str_color.=$m2["color"]."-".get_cate_title_no("color",$m2["color"])." / ".(get_main_key($arr_ph_color,$m2[$s_order])+1)."|"; } if($str_color) $str_color=substr($str_color,0,-1); $content_tbody[$count_total].="\"color|".$str_color."\","; } if($m1["size_group"]==$child_sizegroup_id){ $qa="select * from ".$table_pre."size_bx where no='".$m1["no"]."' order by id"; $ra=$db->query($qa); $str_tzbx=""; while($ma=$db->fetch_array($ra)){ $str_tzbx.=$ma["bx"].":".$ma["price"]." "; } $content_tbody[$count_total].="\"".$str_tzbx."\",\"my_pm|".$ph_my."\",\"bianhua|".$num_my."\",\"je|".deel_num($money_my)."\""; }else{ $content_tbody[$count_total].="\"".deel_num($price1)."\",\"my_pm|".$ph_my."\",\"bianhua|".$num_my."\",\"je|".deel_num($money_my)."\""; } $count++; $count_total++; } } //var_dump($content_tbody); foreach($content_tbody as $value){ $json_data1.="[".$value."],"; } foreach($ds_tbody as $value){ $json_data2.="[".$value."],"; $ds_num++; } $json_data.=substr($json_data1,0,-1)."],"; if($ds_num) $json_data.="\"ds\":\"1\",\"ds_color\":[".substr($json_data2,0,-1)."],"; $json_data.="\"pages\":\"".$pages."\","; $json_data.="\"table_hj\":["; $content_tbody[$count_total]="\"cs:".$hj_colspan." a:r|合计\",\" a:r|".deel_bfb1($count_my,$count_total,1)."\",\"a:r|".$total_num."\",\"a:r|".$total_money."\""; $json_data.="\"".$hj_colspan."\",\"".deel_bfb1($count_my,$count_total,1)."\",\"".$total_num."\",\"".$total_money."\"],"; $js_body="$(function () { $(\".fix1\").fixedtableheader(); });"; }else{ $json_data.="\"is_ph_state\":\"nook\","; $json_data.="\"pages\":\"0\","; } break; } $json_data=substr($json_data,0,-1)."}"; echo $json_data; ?> 次序 全国排名 ".d_translate("xh")." 款号 颜色 颜色/色总排名 ".d_translate("dpj")."