This repository has been archived on 2026-06-20. You can view files and clone it. You cannot open issues or pull requests or push a commit.
Files
wsh5485 7e47ce238b chore: 添加多个图片和资源文件
添加了管理后台所需的图片资源、Excel文件、安装程序以及设计相关的图片文件
2025-06-15 13:04:37 +08:00

232 lines
8.8 KiB
PHP

<?php
//-------------------------------设计师-界面
header("Content-type: text/html; charset=utf-8");
$json_data="{";
if(THIS_IN!="edt_ipad")
exit("错误的访问!");
$uid=check_cookie_jxs();
$json_data.="\"uid\":\"".$uid."\",";
switch($_a){
case "tb_pre":
//取得上一组展示号
$tmp=get_db_msg("select zsh from ".$table_pre."kh_tb where tid='".$tid."' and zsh<'".$s_zsh."' group by zsh order by zsh desc limit 0,1");
if($tmp["zsh"]){
$json_data.="\"code\":100,";
$json_data.="\"zsh\":\"".$tmp["zsh"]."\",";
$json_data.="\"tid\":\"".$tid."\",";
}else{
$json_data.="\"code\":0,\"msg\":\"数据准备中,请稍后......\",";
}
break;
case "tb_next":
//取得上一组展示号
$tmp=get_db_msg("select zsh from ".$table_pre."kh_tb where tid='".$tid."' and zsh>'".$s_zsh."' group by zsh order by zsh limit 0,1");
if($tmp["zsh"]){
$json_data.="\"code\":100,";
$json_data.="\"zsh\":\"".$tmp["zsh"]."\",";
$json_data.="\"tid\":\"".$tid."\",";
}else{
$json_data.="\"code\":0,\"msg\":\"数据准备中,请稍后......\",";
}
break;
default:
//取得默认展厅
if(!$s_tid){
$tmp=get_db_msg("select id from ".$table_pre."kh_tb_t limit 0,1");
$s_tid=$tmp["id"];
}
$s_tid=$s_tid>0?$s_tid:0;
if($s_tid){
$tid_con="and tid='".$s_tid."'";
}else{
$tid_con='';
}
//取得展厅选项信息
$tmp_tid="";
$tid_ct=0;
$q="select * from ".$table_pre."kh_tb_t";
$r=$db->query($q);
while($m=$db->fetch_array($r)){
$tmp_tid.="{\"no\":\"".$m["id"]."\",\"title\":\"".$m["title"]."\"},";
$tid_ct++;
}
$tmp_tid=deel_end($tmp_tid);
$json_data.="\"select_tid_ct\":\"".$tid_ct."\",\"select_tid\":{\"no\":\"s_tid\",\"title\":\"选择展厅\",\"value\":\"".$s_tid."\",\"op\":[".$tmp_tid."]},";
//展示号选项
$tmp_zsh="";
$q="select zsh from ".$table_pre."kh_tb where tid=".$s_tid." group by zsh order by zsh";
$r=$db->query($q);
while($m=$db->fetch_array($r)){
$tmp_zsh.="{\"no\":\"".$m["zsh"]."\",\"title\":\"".$m["zsh"]."\"},";
}
$tmp_zsh=deel_end($tmp_zsh);
$json_data.="\"select_zsh\":{\"no\":\"s_zsh\",\"title\":\"选择展示号\",\"value\":\"".$s_zsh."\",\"op\":[".$tmp_zsh."]},";
//是否启用设计师
if($sys_enable_tb=="y"){
$json_data.="\"code_enable\":\"y\",";
if($s_zsh){
$m=get_db_msg("select zsh,pic from ".$table_pre."kh_tb where zsh='".$s_zsh."' ".$tid_con." group by zsh order by zsh desc limit 0,1");
}else{
$m=get_db_msg("select zsh,pic from ".$table_pre."kh_tb where is_show='y' ".$tid_con." group by zsh order by zsh desc limit 0,1");
$s_zsh=0;
}
//当前展示号
$this_zsh=$m["zsh"]>0?$m["zsh"]:0;
$json_data.="\"this_zsh\":\"".$this_zsh."\",";
$json_data.="\"this_tid\":\"".$s_tid."\",";
$str="";
if($m["zsh"]>0){
$query="select iid,color from ".$table_pre."kh_tb 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");
while($msg=$db->fetch_array($res)){
$m_kh=get_db_msg("select * from ".$table_pre."kh where id='".$msg["iid"]."'");
if($m_kh["ka"]=="y"){
$c=$ka_color;
}else{
$c=get_set_value_dote($style_title_color,$m_kh["kh_dj"]);
}
if($msg["iid"]>0){
//图片获取规则
if($msg["color"]){
$pic=get_kh_color_picture($m_kh["no"],$msg["color"]);
$con_color_tmp=" and color='".$msg["color"]."'";
$color_str=$msg["color"]."-".get_cate_title_no("color",$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="";
}
if($pic){
$arr_pic_set=out_good_pic_set_arr($pic,140,140);
$pic_w=$arr_pic_set[0];
$pic_h=$arr_pic_set[1];
}else{
$pic_w=$pic_h=0;
}
$n1=0;
//----取得评价
$tmp=get_db_msg("select sum(race) 'num' from ".$table_pre."client_pj where khid='".$msg["iid"]."' ");
$pj_num=add_0($tmp["num"]);
$tmp=get_db_msg("select count(*) 'num' from ".$table_pre."client_pj where khid='".$msg["iid"]."' ");
$pj_clients=add_0($tmp["num"]);
//----取得订单
$tmp=get_db_msg("select sum(num) 'num' from ".$table_pre."order where iid='".$msg["iid"]."' 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 iid='".$msg["iid"]."' 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.="{\"id\":\"".$m_kh["id"]."\",\"xh\":\"".get_kh_xh($m_kh,$msg["color"])."\",\"kh\":\"".$m_kh["no"]."\",\"color\":\"".$color_str."\",\"price\":\"".deel_num($m_kh["price"])."\",\"picsrc\":\"".$pic."\",\"pic_w\":\"".$pic_w."\",\"pic_h\":\"".$pic_h."\",\"fontcolor\":\"".$c."\",\"js\":\"".$order_num."\",\"jsrs\":\"".$order_clients."\",\"ppf\":\"".$ppf."\",\"ppfrs\":\"".$pj_clients."\"},";
}
}
if($str)
$str=substr($str,0,-1);
}
$json_data.="\"all_kh\":[".$str."],";
//
$arr_zsh1=array();
$q1="select zsh from ".$table_pre."kh_tb where tid='".$s_tid."' and zsh<".$this_zsh." group by zsh order by zsh 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_tb where tid='".$s_tid."' and zsh>".$this_zsh." group by zsh order by zsh 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,pic,title from ".$table_pre."kh_tb where tid='".$s_tid."' group by zsh order by zsh";
}else if(count($arr_zsh1)<2){
if($arr_zsh1[0]>0)
$query="select zsh,pic,title from ".$table_pre."kh_tb where tid='".$s_tid."' and zsh>='".$arr_zsh1[0]."' group by zsh order by zsh limit 0,5";
else
$query="select zsh,pic,title from ".$table_pre."kh_tb where tid='".$s_tid."' group by zsh order by zsh limit 0,5";
}else if(count($arr_zsh2)<2){
if($arr_zsh2[0]>0)
$q1="select count(distinct zsh) 'num' from ".$table_pre."kh_tb where tid='".$s_tid."' and zsh<='".$arr_zsh2[0]."'";
else
$q1="select count(distinct zsh) 'num' from ".$table_pre."kh_tb where tid='".$s_tid."'";
$m1=get_db_msg($q1);
$limit_s=($m1["num"]-5)>0?($m1["num"]-5):0;
if($arr_zsh2[0]>0)
$query="select zsh,pic,title from ".$table_pre."kh_tb where tid='".$s_tid."' and zsh<='".$arr_zsh2[0]."' group by zsh order by zsh limit ".$limit_s.",5";
else
$query="select zsh,pic,title from ".$table_pre."kh_tb where tid='".$s_tid."' group by zsh order by zsh limit ".$limit_s.",5";
}else{
$query="select zsh,pic,title from ".$table_pre."kh_tb where tid='".$s_tid."' and zsh>='".$arr_zsh1[1]."' group by zsh order by zsh limit 0,5";
}
//
$strzsh="";
$count=0;
$re=$db->query($query);
while ($rows=$db->fetch_array($re)) {
$arr_tmp=array();
$tmp=get_db_msg("select count(distinct iid,color) 'num' from ".$table_pre."kh_tb where zsh=".$rows['zsh']." and tid=".$s_tid);
$r=$db->query("select * from ".$table_pre."kh_tb where zsh=".$rows['zsh']." and tid=".$s_tid);
$i=0;
while ($m1=$db->fetch_array($r)) {
$arr_tmp[$i]['titile']=$m1['titile'];
$arr_tmp[$i]['pic']=$m1['pic'];
$arr_tmp[$i]['iid']=$m1['iid'];
$arr_tmp[$i]['color']=$m1['color'];
$i++;
}
$tmp2=get_db_msg("select * from ".$table_pre."kh where id='".$arr_tmp[0]["iid"]."' limit 0,1");
if($rows['pic']!=""){
$pic2="../attachments/".$rows['pic'];
}
if($tmp['num']==1 && $rows['pic']==""){
if($arr_tmp[0]["color"]){
$pic2=get_kh_color_picture($tmp2["no"],$arr_tmp[0]["color"]);
}else{
$pic2=get_kh_picture($tmp2["no"],$tmp2["main_pic"],$tmp2["color"]);
}
}
$info="";
foreach ($arr_tmp as $key => $value) {
$tmp=get_db_msg("select no from ".$table_pre."kh where id=".$value["iid"]);
$info.=$tmp['no'];
if ($value['color']) {
$info.=",".get_cate_title_no("color",$value['color']);
}else{
$info.="";
}
$info.="|";
}
if($info)
$info=substr($info,0,-1);
if($pic2){
$arr_pic_set2=out_good_pic_set_arr($pic2,120,120);
$pic_w2=$arr_pic_set2[0];
$pic_h2=$arr_pic_set2[1];
}else{
$pic_w2=$pic_h2=0;
}
$strzsh.="{\"zsh\":\"".$rows['zsh']."\",\"picsrc\":\"".$pic2."\",\"pic_w\":\"".$pic_w2."\",\"pic_h\":\"".$pic_h2."\",\"kh_detail\":\"".$info."\"},";
$count++;
}
$json_data.="\"zshcount\":\"".$count."\",\"all_zsh\":[".substr($strzsh,0,-1)."],";
$json_data.="\"code\":100,";
}else{
$json_data.="\"code\":\"0\",\"msg\":\"对不起,目前只有IPAD支持该功能!\",";
}
break;
}
$json_data=substr($json_data,0,-1)."}";
echo $json_data;
?>