0?$tid:0;//$tid来自于浏览器URL$tid
//取得当前展示号
$tmp=get_db_msg("select zsh from ".$table_pre."kh_zblist where is_show='y' order by zsh");
if($tmp["zsh"]>0){
$dq_zsh=$tmp['zsh'];
//大于当前展示号的顺延
$db->query("update ".$table_pre."kh_zblist set zsh=zsh+1 where zsh>'".$dq_zsh."' ");
}else{
$tmp=get_db_msg("select MAX(zsh) 'zsh' from ".$table_pre."kh_zblist ");
$dq_zsh=$tmp['zsh']?$tmp['zsh']:0;
}*/
$this_zsh=create_guid();
//
$ord=1;
$sql="insert into ".$table_pre."kh_zblist (zsh,kh,color,ord,is_show) values ";
foreach($arr_khno as $khno){
$arr_tmp=explode("|",$khno);
$sql.="('".($this_zsh)."','".$arr_tmp[0]."','".$arr_tmp[1]."',".$ord++.",'y'),";
}
$sql=substr($sql,0,-1).";";
$json_data.="\"q\":\"".$sql."\",";
$db->query($sql);
if($tid>0){
$db->query("update ".$table_pre."kh_zblist set is_show='n' where zsh<>'".($this_zsh)."' ");
}else{
$db->query("update ".$table_pre."kh_zblist set is_show='n' where zsh<>'".($this_zsh)."'");
}
$str="y";
$json_data.="\"code\":101,";
break;
case "tb_search":
$w2=$tmpl_m5_pic_width;
$h2=$tmpl_m5_pic_height;
$arr_ksh=explode(",",$wanted_kh);
//默认展厅后新添加自定义推送的单款
$sql="select * from ".$table_pre."kh where no='".$arr_ksh[0]."'";
$str="";
$str_dk="";
$msg=get_db_msg($sql);
if($msg['id']>0){
if($msg["ka"]=="y"){
$c=$ka_color;
}else{
$c=get_set_value_dote($style_title_color,$msg["kh_dj"]);
}
//取得搜索结果的款号图片
if($arr_ksh[1]){
$pic=get_kh_color_picture($msg["no"],$arr_ksh[1]);
}else{
$pic=get_kh_picture($msg["no"],$msg["main_pic"],$msg["color"],$flag_pad_offline);
}
//单款信息拼接
$str.=$msg["id"].",".get_kh_xh($msg).",".$msg["no"].",".$arr_ksh[1].",".$msg["price"].",".$pic.",".str_replace("\"","'",out_good_pic_set($pic,$w2,$h2));
$tmpwh=out_good_pic_set_arr($pic,$w2,$h2);
$str_dk.="{\"khid\":\"".$msg["id"]."\",\"xh\":\"".get_kh_xh($msg)."\",\"kh\":\"".$msg["no"]."\",\"color\":\"".$arr_ksh[1]."\",\"colort\":\"".get_cate_title_no("color",$arr_ksh[1])."\",\"price\":\"".$msg["price"]."\",\"pic\":\"".$pic."\",\"pic_w\":".deel_num($tmpwh[0]).",\"pic_h\":".deel_num($tmpwh[1])."},";
}
$str_dk=substr($str_dk,0,-1);
$json_data.="\"arr_dk\":[".$str_dk."],";
//------------------------------
break;
case "tb_search_dp":
$w2=$tmpl_m5_pic_width;
$h2=$tmpl_m5_pic_height;
if($s_zsh){
$dph=$s_zsh;
}
$arr_ksh=explode(",",$wanted_kh);
//默认展厅后新添加自定义推送的单款
$query="select * from ".$table_pre."kh_dp where zsh='".$dph."'";
//echo $query."
";
$res=$db->query($query);
$str="";
$str_dp="";
$dp_pic="";
while($msg1=$db->fetch_array($res)){
$dp_pic=$msg1["pic"];
$msg=get_db_msg("select * from ".$table_pre."kh where no='".$msg1["kh"]."' ");
if($msg["ka"]=="y"){
$c=$ka_color;
}else{
$c=get_set_value_dote($style_title_color,$msg["kh_dj"]);
}
//取得搜索结果的款号图片
$pic=get_kh_color_picture($msg["no"],$msg1["color"]);
//单款信息拼接
//$str.=$msg["id"].",".get_kh_xh($msg).",".$msg["no"].",".$arr_ksh[1].",".$msg["price"].",".$pic.",".str_replace("\"","'",out_good_pic_set($pic,$w2,$h2));
$tmpwh=out_good_pic_set_arr($pic,$w2,$h2);
$str_dp.="{\"khid\":\"".$msg["id"]."\",\"xh\":\"".get_kh_xh($msg)."\",\"kh\":\"".$msg["no"]."\",\"color\":\"".$msg1["color"]."\",\"colort\":\"".get_cate_title_no("color",$msg1["color"])."\",\"price\":\"".$msg["price"]."\",\"pic\":\"".$pic."\",\"pic_w\":".deel_num($tmpwh[0]).",\"pic_h\":".deel_num($tmpwh[1])."},";
}
$str_dp=substr($str_dp,0,-1);
$json_data.="\"arr_dk\":[".$str_dp."],";
//------------------------------
break;
case "tb_pre":
//设置上一组同步
$tmp=get_db_msg("select zsh from ".$table_pre."kh_zblist where is_show='y' group by zsh order by zsh+1 desc limit 0,1");
if($tmp["zsh"]>0){
$tmp1=get_db_msg("select zsh from ".$table_pre."kh_zblist where zsh<'".$tmp["zsh"]."' group by zsh order by zsh+1 desc limit 0,1");
}else{
$tmp1=get_db_msg("select zsh from ".$table_pre."kh_zblist group by zsh order by zsh+1 limit 0,1");
}
if($tmp1["zsh"]){
$db->query("update ".$table_pre."kh_zblist set is_show='y' where zsh='".$tmp1["zsh"]."'");
$db->query("update ".$table_pre."kh_zblist set is_show='n' where zsh<>'".$tmp1["zsh"]."' and is_show='y'");
$str="y";
$json_data.="\"code\":101,";
}else{
$str="n";
$json_data.="\"code\":0,";
}
break;
case "tb_next":
//设置下一组同步
$tmp=get_db_msg("select zsh from ".$table_pre."kh_zblist where is_show='y' group by zsh order by zsh+1 desc limit 0,1");
if($tmp["zsh"]>0){
$tmp1=get_db_msg("select zsh from ".$table_pre."kh_zblist where zsh>'".$tmp["zsh"]."' group by zsh order by zsh+1 limit 0,1");
}else{
$tmp1=get_db_msg("select zsh from ".$table_pre."kh_zblist group by zsh order by zsh+1 limit 0,1");
}
if($tmp1["zsh"]){
$db->query("update ".$table_pre."kh_zblist set is_show='y' where zsh='".$tmp1["zsh"]."'");
$db->query("update ".$table_pre."kh_zblist set is_show='n' where zsh<>'".$tmp1["zsh"]."' and is_show='y'");
$str="y";
$json_data.="\"code\":101,";
}else{
$str="n";
$json_data.="\"code\":0,";
}
break;
case "tb_zsh":
//设置特定展示号同步
$tmp=get_db_msg("select id from ".$table_pre."kh_zblist where zsh='".$zsh."' limit 0,1");
if($tmp["id"]>0){
$db->query("update ".$table_pre."kh_zblist set is_show='y' where zsh='".$zsh."'");
$db->query("update ".$table_pre."kh_zblist set is_show='n' where zsh<>'".$zsh."' and is_show='y'");
$str="y";
$json_data.="\"code\":101,";
}else{
$str="n";
$json_data.="\"code\":0,";
}
break;
case "del_zsh":
//删除特定展示组
$tmp=get_db_msg("select id from ".$table_pre."kh_zblist where zsh='".$zsh."' limit 0,1");
if($tmp["id"]>0){
$db->query("delete from ".$table_pre."kh_zblist where zsh='".$zsh."'");
$str="y";
$json_data.="\"code\":101,";
}else{
$str="不存在";
$json_data.="\"code\":0,";
$json_data.="\"msg\":\"不存在\",";
}
break;
case "kh_color" :
//
$sql_con="";
if($q){
$sql_con.=" and no like '%".$q."%'";
}
//$json_data.="\"q\":\"".$q."\",";
$query="select * from ".$table_pre."kh where id>0 ".$sql_con." order by no";
//echo $query."
";
$res=$db->query($query);
$count=0;
$data=array();
$str_tmp="";
$i=0;
while($msg=$db->fetch_array($res)){
$color=explode(",",$msg["color"]);
$colork=explode(",",$msg["color_ka"]);
$str_tmp.="{\"id\":\"".$msg["id"]."\",\"no\":\"".$msg["no"]."\",\"xh\":\"".get_kh_xh($msg)."\"},";
foreach($color as $k => $v){
if(!in_array($v,$colork)){
$str_tmp.="{\"id\":\"".$msg["id"]."\",\"no\":\"".$msg["no"]."\",\"xh\":\"".get_kh_xh($msg,$v)."\",\"color\":\"".$v."\",\"colort\":\"".get_cate_title_no("color",$v)."\"},";
}
}
$i++;
}
$json_data.="\"data\":[".deel_end($str_tmp)."],";
break;
case "kh_color1" :
//
$sql_con="";
if($q){
$sql_con.=" and xh='".$q."'";
}
//$json_data.="\"q\":\"".$q."\",";
$query="select * from ".$table_pre."kh where id>0 ".$sql_con." order by no";
//echo $query."
";
$res=$db->query($query);
$count=0;
$data=array();
$str_tmp="";
$i=0;
while($msg=$db->fetch_array($res)){
$color=explode(",",$msg["color"]);
$colork=explode(",",$msg["color_ka"]);
$str_tmp.="{\"id\":\"".$msg["id"]."\",\"no\":\"".$msg["no"]."\",\"xh\":\"".get_kh_xh($msg)."\"},";
foreach($color as $k => $v){
if(!in_array($v,$colork)){
$str_tmp.="{\"id\":\"".$msg["id"]."\",\"no\":\"".$msg["no"]."\",\"xh\":\"".get_kh_xh($msg,$v)."\",\"color\":\"".$v."\",\"colort\":\"".get_cate_title_no("color",$v)."\"},";
}
}
$i++;
}
$json_data.="\"data\":[".deel_end($str_tmp)."],";
break;
case "get_dph" :
//
$sql_con="";
if($q){
$sql_con.=" and zsh like '%".$q."%'";
}
$query="select DISTINCT zsh,title from ".$table_pre."kh_dp where id>0 ".$sql_con." order by zsh";
//echo $query."
";
$res=$db->query($query);
$count=0;
$data=array();
$str_tmp="";
$i=0;
while($msg=$db->fetch_array($res)){
$str_tmp.="{\"zsh\":\"".$msg["zsh"]."\",\"title\":\"".$msg["title"]."\"},";
$i++;
}
$json_data.="\"data\":[".deel_end($str_tmp)."],";
break;
case "client":
$json_data.="\"s_online\":\"".$s_online."\",";
$q1="select * from ".$table_pre."session where action like 'zbuser|%' and uid in (select id from web_client where face='4' and available='y')";
$r1=$db->query($q1);
$zxkh="";
while($m1=$db->fetch_array($r1)){
$zxkh.="'".$m1["uid"]."',";
}
$zxkh=deel_end($zxkh);
if($zxkh){
$q1="select * from ".$table_pre."client where face='4' and available='y' and id not in (".$zxkh.")";
}else{
$q1="select * from ".$table_pre."client where face='4' and available='y'";
}
$r1=$db->query($q1);
$bzxkh="";
while($m1=$db->fetch_array($r1)){
$bzxkh.="'".$m1["id"]."',";
}
$bzxkh=deel_end($bzxkh);
if($zxkh){
$q1="select * from ".$table_pre."client where id in (".$zxkh.") order by path";
$r1=$db->query($q1);
$ct1=1;
while($m1=$db->fetch_array($r1)){
$tbyd.="";
$tbyd.="| ".$ct1." | ";
$qyt=get_qy_title($m1["path"]);
$tbyd.="".$qyt." | ";
$dlt=get_dl_title($m1["path"]);
$tbyd.="".$dlt." | ";
$tbyd.="".$m1["title"]." | ";
$tbyd.="
";
$ct1++;
}
}else{
$tbyd="";
}
$q1="select * from ".$table_pre."client where id in (".$bzxkh.") order by path";
//echo $bzxkh;
$r1=$db->query($q1);
$ct2=1;
while($m1=$db->fetch_array($r1)){
$tbwd.="";
$tbwd.="| ".$ct2." | ";
$qyt=get_qy_title($m1["path"]);
$tbwd.="".$qyt." | ";
$dlt=get_dl_title($m1["path"]);
$tbwd.="".$dlt." | ";
$tbwd.="".$m1["title"]." | ";
$tbwd.="
";
$ct2++;
}
$tbyd="在线客户";
$tbwd="未在线客户";
$json_data.="\"tbyd\":\"".$tbyd."\",";
$json_data.="\"tbwd\":\"".$tbwd."\",";
break;
case "zxmx":
$q="select * from ".$table_pre."client where face='4' and available='y'";
$r=$db->query($q);
$bzxkh="";
$dps_all=$dps_zx=$dps_bzx=0;
$arr_all=$arr_zx=$arr_bzx=array();
while($m=$db->fetch_array($r)){
$sfzb=get_db_msg("select * from ".$table_pre."session where action like 'zbuser|%' and uid='".$m["id"]."'");
$qyinfo=get_qy_info($m["path"]);
$dlinfo=get_dl_info($m["path"]);
if($sfzb["id"]){
if($qyinfo["id"]){
$arr_zx[$qyinfo["id"]][$dlinfo["id"]]["qyt"]=$qyinfo["title"]."(".$qyinfo["username"].")";
}else{
$arr_zx[$qyinfo["id"]][$dlinfo["id"]]["qyt"]="";
}
if($dlinfo["id"]){
$arr_zx[$qyinfo["id"]][$dlinfo["id"]]["dlt"]=$dlinfo["title"]."(".$dlinfo["username"].")";
}else{
$arr_zx[$qyinfo["id"]][$dlinfo["id"]]["dlt"]="";
}
$arr_zx[$qyinfo["id"]][$dlinfo["id"]]["num"]++;
$dps_zx++;
}else{
if($qyinfo["id"]){
$arr_bzx[$qyinfo["id"]][$dlinfo["id"]]["qyt"]=$qyinfo["title"]."(".$qyinfo["username"].")";
}else{
$arr_bzx[$qyinfo["id"]][$dlinfo["id"]]["qyt"]="";
}
if($dlinfo["id"]){
$arr_bzx[$qyinfo["id"]][$dlinfo["id"]]["dlt"]=$dlinfo["title"]."(".$dlinfo["username"].")";
}else{
$arr_bzx[$qyinfo["id"]][$dlinfo["id"]]["dlt"]="";
}
//$arr_bzx[$qyinfo["id"]][$dlinfo["id"]]["qyt"]=$qyinfo["title"]."(".$qyinfo["username"].")";
//$arr_bzx[$qyinfo["id"]][$dlinfo["id"]]["dlt"]=$dlinfo["title"]."(".$dlinfo["username"].")";
$arr_bzx[$qyinfo["id"]][$dlinfo["id"]]["num"]++;
$dps_bzx++;
}
if($qyinfo["id"]){
$arr_all[$qyinfo["id"]][$dlinfo["id"]]["qyt"]=$qyinfo["title"]."(".$qyinfo["username"].")";
}else{
$arr_all[$qyinfo["id"]][$dlinfo["id"]]["qyt"]="";
}
if($dlinfo["id"]){
$arr_all[$qyinfo["id"]][$dlinfo["id"]]["dlt"]=$dlinfo["title"]."(".$dlinfo["username"].")";
}else{
$arr_all[$qyinfo["id"]][$dlinfo["id"]]["dlt"]="";
}
//$arr_all[$qyinfo["id"]][$dlinfo["id"]]["qyt"]=$qyinfo["title"]."(".$qyinfo["username"].")";
//$arr_all[$qyinfo["id"]][$dlinfo["id"]]["dlt"]=$dlinfo["title"]."(".$dlinfo["username"].")";
$arr_all[$qyinfo["id"]][$dlinfo["id"]]["num"]++;
$dps_all++;
}
//print_r($arr_all);
$tb="";
$xh=1;
foreach($arr_all as $k1 => $v1){
foreach($v1 as $k2 => $v2){
$tb.="";
$tb.="| ".$xh." | ";
$tb.="".$v2["qyt"]." | ";
$tb.="".$v2["dlt"]." | ";
$tb.="".$v2["num"]." | ";
if(!$k1){
$qyid=0;
}else{
$qyid=$k1;
}
if(!$k2){
$dlid=0;
}else{
$dlid=$k2;
}
$tb.="".$arr_zx[$k1][$k2]["num"]." | ";
$tb.="".$arr_bzx[$k1][$k2]["num"]." | ";
$tb.="
";
$xh++;
}
}
$tb="| 序号 | 区域 | 代理商 | 店铺数 | 在线店铺数量 | 未在线店铺数 |
".$tb."| 合计 | ".$dps_all." | ".$dps_zx." | ".$dps_bzx." |
";
$json_data.="\"tb\":\"".$tb."\",";
break;
case "zxbb":
if($dlid!=0){
$dl=get_db_msg("select * from ".$table_pre."client where id='".$dlid."'");
$dlcon=" and (path='".$dl["path"]."-".$dl["id"]."' or path like '".$dl["path"]."-".$dl["id"]."%')";
}else{
if($qyid!=0){
$qy=get_db_msg("select * from ".$table_pre."client where id='".$qyid."'");
$qycon=" and (path='".$qy["path"]."-".$qy["id"]."' or path like '".$qy["path"]."-".$qy["id"]."%')";
$q1="select * from ".$table_pre."client where face='4' and available='y'".$qycon."";
}else{
$q1="select * from ".$table_pre."client where face='4' and available='y'";
}
$tmpdl="";
$r1=$db->query($q1);
while($m1=$db->fetch_array($r1)){
$dlt=get_dl_title($m1["path"]);
if(!$dlt){
if($qyid!=0){
$tmpdl.="'".$m1["id"]."',";
}else{
$qyt=get_qy_title($m1["path"]);
if(!$qyt){
$tmpdl.="'".$m1["id"]."',";
}
}
}
}
if($tmpdl){
$dlcon=" and id in (".deel_end($tmpdl).")";
}else{
$dlcon=" and id=0";
}
}
$q1="select * from ".$table_pre."session where action like 'zbuser|%' and uid in (select id from web_client where face='4' and available='y'".$dlcon.")";
$r1=$db->query($q1);
$zxkh="";
while($m1=$db->fetch_array($r1)){
$zxkh.="'".$m1["uid"]."',";
}
$zxkh=deel_end($zxkh);
if($zxkh){
$q1="select * from ".$table_pre."client where face='4' and available='y' and id not in (".$zxkh.")".$dlcon."";
}else{
$q1="select * from ".$table_pre."client where face='4' and available='y'".$dlcon."";
}
$r1=$db->query($q1);
$bzxkh="";
while($m1=$db->fetch_array($r1)){
$bzxkh.="'".$m1["id"]."',";
}
$bzxkh=deel_end($bzxkh);
$json_data.="\"dlcon\":\"".$dlcon."\",";
$json_data.="\"bzxkh\":\"".$bzxkh."\",";
$json_data.="\"zxkh\":\"".$zxkh."\",";
if($zxkh){
$q1="select * from ".$table_pre."client where id in (".$zxkh.")".$dlcon." order by path";
$r1=$db->query($q1);
$ct1=1;
while($m1=$db->fetch_array($r1)){
$tbyd.="";
$tbyd.="| ".$ct1." | ";
$qyt=get_qy_title($m1["path"]);
$tbyd.="".$qyt." | ";
$dlt=get_dl_title($m1["path"]);
$tbyd.="".$dlt." | ";
$tbyd.="".$m1["title"]." | ";
$tbyd.="
";
$ct1++;
}
}else{
$tbyd="";
}
if($bzxkh){
$q1="select * from ".$table_pre."client where id in (".$bzxkh.")".$dlcon." order by path";
//echo $bzxkh;
$r1=$db->query($q1);
$ct2=1;
while($m1=$db->fetch_array($r1)){
$tbwd.="";
$tbwd.="| ".$ct2." | ";
$qyt=get_qy_title($m1["path"]);
$tbwd.="".$qyt." | ";
$dlt=get_dl_title($m1["path"]);
$tbwd.="".$dlt." | ";
$tbwd.="".$m1["title"]." | ";
$tbwd.="
";
$ct2++;
}
}else{
$tbwd="";
}
$tbyd="在线客户";
$tbwd="未在线客户";
$json_data.="\"tbyd\":\"".$tbyd."\",";
$json_data.="\"tbwd\":\"".$tbwd."\",";
break;
case "pj":
$q1="select * from ".$table_pre."client_pj where khid='".$khid."'";
$r1=$db->query($q1);
$ct1=1;
while($m1=$db->fetch_array($r1)){
$client=get_db_msg("select * from web_client where id='".$m1["cid"]."'");
$tbyd.="";
$tbyd.="| ".$ct1." | ";
$tbyd.="".$client["title"]." | ";
$tbyd.="".$m1["race"]."星 | ";
$tbyd.="".$m1["remark"]." | ";
$tbyd.="
";
$ct1++;
}
$tbyd="";
$json_data.="\"tbyd\":\"".$tbyd."\",";
break;
default:
//----------------------------同步
$w2=$tmpl_m5_pic_width;
$h2=$tmpl_m5_pic_height;
/*if($s_tid){
$tid=$s_tid;
}
//取得默认展厅
$tmp=get_db_msg("select id from ".$table_pre."kh_zblist_t limit 0,1");
$tid=$tid?$tid:$tmp["id"];
if($tid){
$tid_con="";
}else{
$tid_con='';
}
$json_data.="\"tid\":\"".$tid."\",";
$q1="select * from ".$table_pre."kh_zblist_t ";
$r1=$db->query($q1);
$arr_tid="";
while($m1=$db->fetch_array($r1)){
$arr_tid.="{\"no\":\"".$m1["id"]."\",\"value\":\"".$m1["title"]."\"},";
}
$arr_tid=deel_end($arr_tid);
$json_data.="\"zt\":[".$arr_tid."],";*/
//
//$m=get_db_msg("select zsh,pic from ".$table_pre."kh_zblist where is_show='y' group by zsh order by zsh+1 desc limit 0,1");
$m=get_db_msg("select zsh from ".$table_pre."kh_zblist where is_show='y' ".$tid_con." group by zsh order by zsh+1 desc limit 0,1");
//$json_data.="\"q\":\"select zsh,pic from ".$table_pre."kh_zblist where is_show='y' ".$tid_con." group by zsh order by zsh+1 desc limit 0,1\",";
if($m["zsh"]){
//$str=$m["zsh"]."||";
$json_data.="\"zsh\":\"".$m["zsh"]."\",";
//图片
$pic1="";
if(trim($m["pic"])){
$pic1=get_picture($m["pic"],$flag_pad_offline);
if(!$pic1){
$pic1="images/no_pic.png";
}
//$str.=$pic1."|".str_replace("\"","'",out_good_pic_set($pic1,$tmpl_m5_cl_pic_width,$tmpl_m5_cl_pic_height));
$tmpwh=out_good_pic_set_arr($pic1,$tmpl_m5_cl_pic_width,$tmpl_m5_cl_pic_height);
$json_data.="\"pic\":\"".$pic1."\",";
$json_data.="\"pic_w\":".deel_num($tmpwh[0]).",";
$json_data.="\"pic_h\":".deel_num($tmpwh[1]).",";
}
//$str.="||";
//$query="select kh from ".$table_pre."kh_zblist where zsh='".$m["zsh"]."' order by ord";
$query="select kh,color from ".$table_pre."kh_zblist where zsh='".$m["zsh"]."' ".$tid_con." order by ord";
$res=$db->query($query);
$style_title_color=get_set("style_title_color");
$ka_color=get_set("ka_color");
//$str.="var arr_content=[";
$str_arr_content="";
while($msg=$db->fetch_array($res)){
$m_kh=get_db_msg("select * from ".$table_pre."kh where no='".$msg["kh"]."'");
if($m_kh["ka"]=="y"){
$c=$ka_color;
}else{
$c=get_set_value_dote($style_title_color,$m_kh["kh_dj"]);
}
if($msg["kh"]){
//图片获取规则
if($msg["color"]){
$pic=get_kh_color_picture($m_kh["no"],$msg["color"]);
$con_color_tmp=" and color='".$msg["color"]."'";
$color_str=",".$msg["color"];
}else{
$pic=get_kh_picture($m_kh["no"],$m_kh["main_pic"],$m_kh["color"],$flag_pad_offline);
$con_color_tmp="";
$color_str="";
}
$n1=0;
//----取得评价
$tmp=get_db_msg("select sum(race) 'num' from ".$table_pre."client_pj where khid='".$m_kh["id"]."' ");
$pj_num=add_0($tmp["num"]);
$tmp=get_db_msg("select count(*) 'num' from ".$table_pre."client_pj where khid='".$m_kh["id"]."' ");
$pj_clients=add_0($tmp["num"]);
//----取得订单
$tmp=get_db_msg("select sum(num) 'num' from ".$table_pre."order where no='".$msg["kh"]."' and _key='".$_key."'".$con_color_tmp);
$order_num=add_0($tmp["num"]);
$tmp=get_db_msg("select count(distinct uid) 'num' from ".$table_pre."order where no='".$msg["kh"]."' and _key='".$_key."'".$con_color_tmp);
$order_clients=add_0($tmp["num"]);
//
$ppf=$pj_clients>0?keep_float($pj_num/$pj_clients,1):0;
//$str.="".$m_kh["id"].",\"".get_kh_xh($m_kh,$msg["color"])."\",\"".$m_kh["no"].$color_str."\",".deel_num($m_kh["price"]).",\"".$pic."\",\"".str_replace("\"","'",out_good_pic_set($pic,$w2,$h2))."\",".$n1.",\"".$c."\",\"".$order_num."|".$order_clients."|".$ppf."|".$pj_clients."\",";
$tmpwh=out_good_pic_set_arr($pic,$w2,$h2);
$str_arr_content.="{\"khid\":\"".$m_kh["id"]."\",\"xh\":\"".get_kh_xh($m_kh,$msg["color"])."\",\"kh\":\"".$m_kh["no"]."\",\"color\":\"".$msg["color"]."\",\"colort\":\"".get_cate_title_no("color",$msg["color"])."\",\"price\":\"".deel_num($m_kh["price"])."\",\"pic\":\"".$pic."\",\"pic_w\":".deel_num($tmpwh[0]).",\"pic_h\":".deel_num($tmpwh[1]).",\"num\":".$n1.",\"style_color\":\"".$c."\",\"order_num\":".$order_num.",\"order_clients\":\"".$order_clients."\",\"ppf\":\"".$ppf."\",\"pj_clients\":\"".$pj_clients."\"},";
}
}
//$str.="]||";
$str_arr_content=substr($str_arr_content,0,-1);
$json_data.="\"tsz\":[".$str_arr_content."],";
}else{
//$str="0||pic||kh||";
$json_data.="\"msg\":\"暂无数据\",";
}
//--------------------------候选
$this_zsh=$m["zsh"]>0?$m["zsh"]:0;
$arr_zsh1=array();
$q1="select zsh from ".$table_pre."kh_zblist where zsh<".$this_zsh." group by zsh order by zsh+1 desc limit 0,2";
$r1=$db->query($q1);
while($m1=$db->fetch_array($r1)){
$arr_zsh1[]=$m1["zsh"];
}
$arr_zsh2=array();
$q1="select zsh from ".$table_pre."kh_zblist where zsh>".$this_zsh." group by zsh order by zsh+1 limit 0,2";
$r1=$db->query($q1);
while($m1=$db->fetch_array($r1)){
$arr_zsh2[]=$m1["zsh"];
}
if(count($arr_zsh1)<2 && count($arr_zsh2)<2){
$query="select zsh,title from ".$table_pre."kh_zblist group by zsh order by zsh";
}else if(count($arr_zsh1)<2){
if($arr_zsh1[0]>0)
$query="select zsh,title from ".$table_pre."kh_zblist where zsh>='".$arr_zsh1[0]."' group by zsh order by zsh+1 limit 0,5";
else
$query="select zsh,title from ".$table_pre."kh_zblist group by zsh order by zsh+1 limit 0,5";
}else if(count($arr_zsh2)<2){
if($arr_zsh2[0]>0)
$q1="select count(distinct zsh) 'num' from ".$table_pre."kh_zblist where zsh<='".$arr_zsh2[0]."'";
else
$q1="select count(distinct zsh) 'num' from ".$table_pre."kh_zblist ";
$m1=get_db_msg($q1);
$limit_s=($m1["num"]-5)>0?($m1["num"]-5):0;
if($arr_zsh2[0]>0)
$query="select zsh,title from ".$table_pre."kh_zblist where zsh<='".$arr_zsh2[0]."' group by zsh order by zsh+1 limit ".$limit_s.",5";
else
$query="select zsh,title from ".$table_pre."kh_zblist group by zsh order by zsh+1 limit ".$limit_s.",5";
}else{
$query="select zsh,title from ".$table_pre."kh_zblist where zsh>='".$arr_zsh1[1]."' group by zsh order by zsh+1 limit 0,5";
}
//echo $query."--
";
$re=$db->query($query);
//$str.="arr_content_yl=[";
$arr_content_yl="";
while($rows=$db->fetch_array($re)){
$arr_tmp=array();
$tmp=get_db_msg("select count(distinct kh,color) 'num' from ".$table_pre."kh_zblist where zsh='".$rows['zsh']."' ");
$r=$db->query("select * from ".$table_pre."kh_zblist where zsh='".$rows['zsh']."' ");
$i=0;
while($m1=$db->fetch_array($r)){
$arr_tmp[$i]['title']=$m1['title'];
$arr_tmp[$i]['pic']=$m1['pic'];
$arr_tmp[$i]['kh']=$m1['kh'];
$arr_tmp[$i]['color']=$m1['color'];
$i++;
}
$pic="";
$pic_w=$pic_h=0;
$tmp2=get_db_msg("select * from ".$table_pre."kh where no='".$arr_tmp[0]["kh"]."' limit 0,1");
if($rows['pic']!=""){
//$rows['pic']=str_replace("\"","'",out_good_pic("../attachments/".$rows['pic'],110,110));
$pic="../attachments/".$rows['pic'];
$ck=out_good_pic_set_arr($pic,110,110);
$pic_w=$ck[0];
$pic_h=$ck[1];
}
if($rows['pic']==""){
//$rows['pic']="";
$pic="images/no_pic.png";
//$pic="";
$pic_w=110;
$pic_h=110;
}
//if($tmp['num']==1 && $rows['pic']==""){
if($arr_tmp[0]["color"]){
//$rows['pic']=str_replace("\"","'",out_good_pic(get_kh_color_picture($tmp2["no"],$arr_tmp[0]["color"]),110,110));
$pic=get_kh_color_picture($tmp2["no"],$arr_tmp[0]["color"]);
$ck=out_good_pic_set_arr($pic,110,110);
$pic_w=$ck[0];
$pic_h=$ck[1];
}else{
//$rows['pic']=str_replace("\"","'",out_good_pic(get_kh_picture($tmp2["no"],$tmp2["main_pic"],$tmp2["color"]),110,110));
$pic=get_kh_picture($tmp2["no"],$tmp2["main_pic"],$tmp2["color"]);
$ck=out_good_pic_set_arr($pic,110,110);
$pic_w=$ck[0];
$pic_h=$ck[1];
}
//}
$info="
";
foreach($arr_tmp as $key => $value){
$tmp=get_db_msg("select no from ".$table_pre."kh where no='".$value["kh"]."'");
$info.=$tmp['no'];
if ($value['color']) {
$info.=",".$value['color'];
}else{
$info.="";
}
$info.="
";
}
//$str.="\"".$rows['zsh']."-".$rows['pic']."-".$info;
//$str.="\",";
$arr_content_yl.="{\"tsh\":\"".$rows['zsh']."\",\"title\":\"".$rows['title']."\",\"pic\":\"".$pic."\",\"pic_w\":".deel_num($pic_w).",\"pic_h\":".deel_num($pic_h).",\"info\":\"".$info."\"},";
}
$arr_content_yl=substr($arr_content_yl,0,-1);
$json_data.="\"zjs\":[".$arr_content_yl."],";
//$str=substr($str, 0, -1);
//$str.="]";
break;
}
$json_data=substr($json_data,0,-1)."}";
echo $json_data;
//取得上级区域
function get_qy_title($path){
global $db,$table_pre;
$arr_path=explode("-",$path);
for($i=count($arr_path)-1;$i>=0;$i--){
if($arr_path[$i]>0){
$m1=get_db_msg("select id,face,title from ".$table_pre."client where id='".$arr_path[$i]."'");
if($m1["face"]=="9"){
return $m1["title"];
}
}
}
return "";
}
//取得上级代理
function get_dl_title($path){
global $db,$table_pre;
$arr_path=explode("-",$path);
for($i=count($arr_path)-1;$i>=0;$i--){
if($arr_path[$i]>0){
$m1=get_db_msg("select id,face,title from ".$table_pre."client where id='".$arr_path[$i]."'");
if($m1["face"]=="3"){
return $m1["title"];
}
}
}
return "";
}
//取得上级区域
function get_qy_info($path){
global $db,$table_pre;
$arr_path=explode("-",$path);
for($i=count($arr_path)-1;$i>=0;$i--){
if($arr_path[$i]>0){
$m1=get_db_msg("select id,face,title,username from ".$table_pre."client where id='".$arr_path[$i]."'");
if($m1["face"]=="9"){
return $m1;
}
}
}
return "";
}
//取得上级代理
function get_dl_info($path){
global $db,$table_pre;
$arr_path=explode("-",$path);
for($i=count($arr_path)-1;$i>=0;$i--){
if($arr_path[$i]>0){
$m1=get_db_msg("select id,face,title,username from ".$table_pre."client where id='".$arr_path[$i]."'");
if($m1["face"]=="3"){
return $m1;
}
}
}
return "";
}
?>