'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"]; } $is_sy=get_set("is_sy"); $json_data.="\"username\":\"".$msg_client["username"]."\","; $json_data.="\"is_sy\":\"".$is_sy."\","; $s_uid=$s_uid?$s_uid:$uid; $s_ka=$s_ka?$s_ka:"n"; $con=""; $con_u=""; if($s_uid){ if($s_uid=="_ALL_"){ $con.=$cou_u_all; $con_u.=$cou_u_all; }else{ $m1=get_db_msg("select * from ".$table_pre."client where id='".$s_uid."'"); if($m1["face"]=="4"){ $con.=" and uid='".$s_uid."'"; $con_u.=" and uid='".$s_uid."'"; }else{ $con.=" and (upath='".$m1["path"]."-".$m1["id"]."' or upath like '".$m1["path"]."-".$m1["id"]."-%')"; $con_u.=" and (upath='".$m1["path"]."-".$m1["id"]."' or upath like '".$m1["path"]."-".$m1["id"]."-%')"; } } }else{ $con.=" and uid=0"; $con_u.=" and uid=0"; } for($i=0;$iquery("select * from ".$table_pre."client where face='4' order by concat(path,'-',id)"); while($m=$db->fetch_array($r)){ $op_client.=""; $search_select_op[$i1][$m["id"]]="".$m["title"]."(".$m["username"].")-".$m["order_num"]."件"; } $i1++; //删除款过滤 $search_select_no[$i1]="s_ka"; $search_select_op[$i1]=array("n"=>"非删除款","y"=>"删除款"); $i1++; //选项过滤 for($i=0;$iquery("select no,title from ".$table_pre."keyword where cate='".$arr_select_no[$i]."' order by no"); $search_select_no[$i1]=$v; $search_select_op[$i1][""]=$arr_select_title[$i]."过滤"; while($m1=$db->fetch_array($r1)){ $search_select_op[$i1][$m1["no"]]=$m1["title"]; } $i1++; } $i++; //排序 $search_select_no[$i1]="s_order"; $search_select_op[$i1]=array("num"=>"数量排序","no"=>"款号排序","je"=>"金额排序"); //选项前面 $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."],"; //$content_search.=" "; //----------------------------------------------取得订单记录 break; case "2": //-------------------------------------------------------------------------区经 $op_client=""; $i1=0; $search_select_no[$i1]="s_uid"; $search_select_op[$i1][]="-请选择客户-"; $search_select_op[$i1]["_ALL_"]="所有客户"; for($i=0;$i0) $this_js="-".$m1["order_num"]."件"; $op_client.=">".$m1["title"]."(".$m1["username"].")".$this_js.""; $search_select_op[$i1][$v]="".$m1["title"]."(".$m1["username"].")".$this_js.""; } } $i1++; //删除款过滤 $search_select_no[$i1]="s_ka"; $search_select_op[$i1]=array("n"=>"非删除款","y"=>"删除款"); $i1++; //选项过滤 for($i=0;$iquery("select no,title from ".$table_pre."keyword where cate='".$arr_select_no[$i]."' order by no"); $search_select_no[$i1]=$v; $search_select_op[$i1][""]=$arr_select_title[$i]."过滤"; while($m1=$db->fetch_array($r1)){ $search_select_op[$i1][$m1["no"]]=$m1["title"]; } $i1++; } $i++; //排序 $search_select_no[$i1]="s_order"; $search_select_op[$i1]=array("num"=>"数量排序","no"=>"款号排序","je"=>"金额排序"); //选项前面 $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."],"; //$content_search.=" "; //----------------------------------------------取得订单记录 break; case "3": //-------------------------------------------------------------------------代理 $op_client=""; $i1=0; $search_select_no[$i1]="s_uid"; $search_select_op[$i1][]="-请选择客户-"; $r=$db->query("select id,title,username,order_num from ".$table_pre."client where path='".$p."' or path like '".$p."-%' order by path,ord"); while($m=$db->fetch_array($r)){ $op_client.=""; $search_select_op[$i1][$m["id"]]="".$m["title"]."(".$m["username"].")-".$m["order_num"]."件"; } $i1++; //删除款过滤 $search_select_no[$i1]="s_ka"; $search_select_op[$i1]=array("n"=>"非删除款","y"=>"删除款"); $i1++; //选项过滤 for($i=0;$iquery("select no,title from ".$table_pre."keyword where cate='".$arr_select_no[$i]."' order by no"); $search_select_no[$i1]=$v; $search_select_op[$i1][""]=$arr_select_title[$i]."过滤"; while($m1=$db->fetch_array($r1)){ $search_select_op[$i1][$m1["no"]]=$m1["title"]; } $i1++; } $i++; //排序 $search_select_no[$i1]="s_order"; $search_select_op[$i1]=array("num"=>"数量排序","no"=>"款号排序","je"=>"金额排序"); //选项前面 $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."],"; //$content_search.=" "; //----------------------------------------------取得订单记录 break; case "4": //-------------------------------------------------------------------------店铺角色 //包含定制模块 //删除款过滤 $i1=0; $search_select_no[$i1]="s_ka"; $search_select_op[$i1]=array("n"=>"非删除款","y"=>"删除款"); $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++; } //选项过滤 for($i=0;$iquery("select no,title from ".$table_pre."keyword where cate='".$arr_select_no[$i]."' order by no"); $search_select_no[$i1]=$v; $search_select_op[$i1][""]=$arr_select_title[$i]."过滤"; while($m1=$db->fetch_array($r1)){ $search_select_op[$i1][$m1["no"]]=$m1["title"]; } $i1++; } //排序 $search_select_no[$i1]="s_order"; $search_select_op[$i1]=array("date"=>"时间排序","num"=>"数量排序"); //选项前面 $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."],"; break; } if($sys_ver_hy=="tz"){ include_once $path_dz."/dp/detail_tz.php"; }elseif($sys_ver_hy=="xz"){ include_once $path_dz."/dp/detail_xz.php"; }else{ include_once $path_dz."/dp/detail.php"; } $json_data=substr($json_data,0,-1)."}"; echo $json_data; ?>