<?php
header("Content-type: text/html; charset=utf-8");
//短消息管理
if(THIS_IN!="edt_admin")
	exit("错误的访问!");
//require THIS_FILE_ROOT."/include/excel_class.php";
//require THIS_FILE_ROOT."/include/excel_fun.php";
$uid=check_cookie();
$db=_mysql_connect();
$msg_login_user=get_db_msg("select * from ".$table_pre."user where id='".$uid."'");
//$_title_=$_title_?$_title_:"短消息管理";
//---------priv
//权限判断
$priv=return_priv($_m,$msg_login_user["priv"]);
$json_data="{";
if($priv[0]=="n"){
	//没有操作权限
	$json_data.="\"error\":\"没有操作权限\",\"code\":0,\"msg\":\"\",\"count\":0,\"data\":[],";
}else{
	$json_data.="\"uid\":".$uid.",";
	switch($_a){
		case "add" :
			//--------------------------新增
			if($id){
				$msg=get_db_msg("select * from ".$table_pre."msg where id='".$id."'");
				//
				$tmp=get_db_msg("select * from ".$table_pre."client where id='".$msg["from_cid"]."'");
				$s_dp_from=$tmp["username"];
				$from_cid=$tmp["id"];
				
				//
				$tmp=get_db_msg("select * from ".$table_pre."client where id='".$msg["to_cid"]."'");
				$s_dp_to=$tmp["username"];
				$to_cid=$tmp["id"];
				
				$add_date=date("Y-m-d H:i:s",$msg["add_date"]);
				$is_read=$msg["is_read"];

				$json_data.="\"id\":\"".$msg["id"]."\",";
				$json_data.="\"s_dp_from\":\"".$s_dp_from."\",";
				$json_data.="\"s_from_cid\":\"".$from_cid."\",";
				$json_data.="\"s_dp_to\":\"".$s_dp_to."\",";
				$json_data.="\"s_to_cid\":\"".$to_cid."\",";
				$json_data.="\"add_date\":\"".$add_date."\",";
				$json_data.="\"is_read\":\"".$is_read."\",";
				$json_data.="\"qf\":\"y\",";
				$json_data.="\"text\":\"".$msg["text"]."\",";
				//
				
			}else{
				$add_date=date("Y-m-d H:i:s");
				$is_read="n";
				if($from_cid>0){
					$tmp=get_db_msg("select * from ".$table_pre."client where id='".$from_cid."'");
					$s_dp_from=$tmp["username"];
				}else{
					$from_cid=0;
					$s_dp_from="";
				}
				if($to_cid>0){
					$tmp=get_db_msg("select * from ".$table_pre."client where id='".$to_cid."'");
					$s_dp_to=$tmp["username"];
				}else{
					$to_cid=0;
					$s_dp_to="";
				}
				$json_data.="\"id\":\"".$msg["id"]."\",";
				$json_data.="\"s_dp_from\":\"".$s_dp_from."\",";
				$json_data.="\"s_from_cid\":\"".$from_cid."\",";
				$json_data.="\"s_dp_to\":\"".$s_dp_to."\",";
				$json_data.="\"s_to_cid\":\"".$to_cid."\",";
				$json_data.="\"add_date\":\"".$add_date."\",";
				$json_data.="\"is_read\":\"".$is_read."\",";
				$json_data.="\"qf\":\"y\",";
				$json_data.="\"text\":\"\",";
			}
		break;
		case "save_add" :
			if($text){
				$add_date=day_to_time($add_date);
				$is_read=($is_read=="on")?"y":"n";
				$qf=($qf=="on")?"y":"n";
				if($id){
					$msg=get_db_msg("select * from ".$table_pre."msg where id='".$id."'");
					$log_action="修改";
					$query="update ".$table_pre."msg set is_read='".$is_read."',from_cid='".$s_from_cid."',to_cid='".$s_to_cid."',text='".mysql_escape_string($text)."',add_date='".$add_date."' where id='".$id."'";
					$db->query($query);
				}else{
					$log_action="新增";
					if($s_dp_to){
						$arr_dp_to=explode(",",$s_dp_to);
						for($i=0;$i<count($arr_dp_to);$i++){
							if(trim($arr_dp_to[$i])){
								$tmp=get_db_msg("select id from ".$table_pre."client where username='".$arr_dp_to[$i]."'");
								if($tmp["id"]>0){
									$s_to_cid=$tmp["id"];
									$query="insert into ".$table_pre."msg (from_cid,to_cid,text,add_date) values ('".$s_from_cid."','".$s_to_cid."','".mysql_escape_string($text)."','".$add_date."')";
									$db->query($query);
									$msg=get_db_msg("select * from ".$table_pre."client where id='".$s_to_cid."'");
									if($qf=="y"){
										//群发下级客户
										$q="select * from ".$table_pre."client where path='".$msg["path"]."-".$msg["id"]."' or path like '".$msg["path"]."-".$msg["id"]."-%'";
										$r=$db->query($q);
										while($m=$db->fetch_array($r)){
											$query="insert into ".$table_pre."msg (from_cid,to_cid,text,add_date) values ('".$s_from_cid."','".$m["id"]."','".mysql_escape_string($text)."','".$add_date."')";
											$db->query($query);
										}
									}
								}
							}
						}
					}else{
						//群发所有客户
						$q="select * from ".$table_pre."client where id<>'".$s_from_cid."'";
						$r=$db->query($q);
						while($m=$db->fetch_array($r)){
							$query="insert into ".$table_pre."msg (from_cid,to_cid,text,add_date) values ('".$s_from_cid."','".$m["id"]."','".mysql_escape_string($text)."','".$add_date."')";
							$db->query($query);
						}
					}
				}
				//echo $query."<br>";
				set_log($log_action."短消息",$text);
				$json_data.="\"code\":1,";
			}else{
				$json_data.="\"code\":0,\"msg\":\"缺少内容\",";
			}
		break;
		case "del" :
			$num=count($id);
			
			$json_data.="\"num\":".$num.",";
			if($num==0)
				alert_and_back("请至少选择一条记录!");
			for($i=0;$i<$num;$i++){
				$json_data.="\"".$id[$i]."\":".$id[$i].",";
				$tmp=get_db_msg("select * from ".$table_pre."msg where id='".$id[$i]."'");
				//
				$db->query("delete from ".$table_pre."msg where id='".$id[$i]."'");
				set_order_total($tmp["uid"]);
				$lid.=$tmp["text"]."<br>|||<Br>";
			}
			$lid=substr($lid,0,-2);
			set_log("删除短消息",$lid);
			//var_dump($id);
			//url_redirect();
			//$json_data.="\"code\":1,";
		break;
		//-------------主界面
		default :
			//
			$page=$page>0?$page:1;
			$limit=$limit>0?$limit:50;
			$start=($page-1)*$limit;
			$end=$limit;

			$arr_yn=array("y"=>"是","n"=>"否");

			$order=$order?$order:"add_date!";
			//$tran_var=array("offset"=>$offset,"page_size"=>$page_size,"s_is_read"=>$s_is_read,"s_from_cid"=>$s_from_cid,"s_to_cid"=>$s_to_cid,"_cid"=>$_cid,"_m"=>$_m);
			//$pagesize_option=array(10,20,30,40,50,100);
			$sql_con="";
			if($s_is_read || $s_from_cid || $s_to_cid){
				if($s_is_read)
					$sql_con.="is_read='".$s_is_read."' and ";
				if($s_from_cid)
					$sql_con.="from_cid='".$s_from_cid."' and ";
				if($s_to_cid)
					$sql_con.="to_cid='".$s_to_cid."' and ";
			}
			if($sql_con)
				$sql_con="where ".substr($sql_con,0,-4);
			$sql_order=str_replace("!"," desc",$order);
			$query="select count(*) 'total' from ".$table_pre."msg ".$sql_con;
			$res=$db->query($query);
			$msg=$db->fetch_array($res);
			$total=$msg["total"];
			//page class
			//-----------------------search

			//取得定制选项
			$select_dz="";
			$tmp="";
			foreach($arr_yn as $k1 => $v1){
				$tmp.="{\"no\":\"".$k1."\",\"title\":\"".$v1."\"},";
			}
			$tmp=deel_end($tmp);
			$select_dz.="{\"no\":\"is_read\",\"title\":\"是否已读\",\"value\":\"is_read\",\"op\":[".$tmp."]},";

			$select_dz=deel_end($select_dz);
			$json_data.="\"select_dz\":[".$select_dz."],";


			/*$search_content="";
			$search_content.="<select name=\"s_is_read\" class=\"slt_list\"><option value=''>-是否已读-</option>".get_main_op($arr_yn,$s_is_read)."</select> ";
			$login_by_select=get_set("login_by_select");
			if($login_by_select=="y"){
				$search_content.="<select name=\"s_from_cid\" class=\"slt_list\"><option value=\"\">-来自-</option>".op_client_all_id($s_from_cid)."</select> <select name=\"s_to_cid\" class=\"slt_list\"><option value=\"\">-送往-</option>".op_client_all_id($s_to_cid)."</select> ";
			}else{
				//取得店铺框
				$js_function=get_client_autocompelete("","n")."\n";
				$js_function.="$(function() {
					$('#s_dp_from').autocomplete(clients, {
					max: 20, //列表里的条目数
					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) {
						document.search.s_from_cid.value=row.id;
						$('#s_dp_from').value=row.u;
					});
					$('#s_dp_to').autocomplete(clients, {
					max: 20, //列表里的条目数
					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) {
						document.search.s_to_cid.value=row.id;
						$('#s_dp_to').value=row.u;
					});
				});";
				$search_content.="<span style=\"font-family:黑体;padding-left:15px;font-size:14px;font-weight:bold;\">来自:</span><input type=text name=\"s_dp_from\" id=\"s_dp_from\" style=\"width:80px;height:21px;\" onfocus=\"this.select()\" value=\"".$s_dp_from."\"><input type=\"hidden\" value=\"\" name=\"s_from_cid\" id=\"s_from_cid\"> <span style=\"font-family:黑体;padding-left:15px;font-size:14px;font-weight:bold;\">送往:</span><input type=text name=\"s_dp_to\" id=\"s_dp_to\" style=\"width:80px;height:21px;\" onfocus=\"this.select()\" value=\"".$s_dp_to."\"><input type=\"hidden\" value=\"\" name=\"s_to_cid\" id=\"s_to_cid\"> ";
			}*/
			//
			/*$search_content.="<input type=submit value=\"搜索\" class=\"btn_act\">";
			$search_form_hidden=array(
				"_a"=>$_a
			);*/
			//-----------------------/search
			//-----------------------act
			//$act="<input type=\"button\" value=\"新增\" onclick=\"dadd()\" class=\"btn_black\">";
			//$act.="<input onclick=\"location.href='".$_SERVER[PHP_SELF]."?_cid=".$_cid."&_m=".$_m."&_a=copy'\" type=\"button\" value=\"复制\" class=\"button_act\">";
			//$act.="<input type=button value='导出' class='button_act' onclick=\"dexport()\"> ";
			//$act.="<input type=\"button\" value=\"删除\" onclick=\"ddel(".$page_size.")\" class=\"btn_black\"> ";
			//if($s_is_read || $s_cid)
				//$act.=" <a href=\"".$_SERVER[PHP_SELF]."?_m=".$_m."&_cid=".$_cid."&page_size=".$page_size."\">显示全部</a>";
			//-----------------------/act
			//-----------------------tab

			//-----------------------/tab
			/*$form_hidden=array(
				"s_is_read"=>$s_is_read,
				"s_from_cid"=>$s_from_cid,
				"s_to_cid"=>$s_to_cid,
				"page_size"=>$page_size
			);*/
			//$checkbox_all=($priv[1]=="m")?"<input type=\"checkbox\" name=\"toggle\" onclick=\"checkAll(".$page_size.")\">":"";
			//表头
			//$column_str="<tr class=\"tabel_list_head\"><td style=\"border-bottom:solid 2px #EEEEEE;\" align=\"left\" width=\"60\"><input type=\"checkbox\" name=\"toggle\" onclick=\"checkAll(".$page_size.")\">序号</td><td style=\"border-bottom:solid 2px #EEEEEE;\" align=\"center\" width=\"30\">已读</td><td style=\"border-bottom:solid 2px #EEEEEE;\" align=\"center\" width=\"100\">来自</td><td style=\"border-bottom:solid 2px #EEEEEE;\" align=\"center\" width=\"100\">送往</td><td style=\"border-bottom:solid 2px #EEEEEE;\" align=\"center\">内容</td><td style=\"border-bottom:solid 2px #EEEEEE;\" align=\"center\" width=\"120\">发送时间</td></tr>";
			//------------
			$str_tmp="";
			$json_data.="\"code\":0,\"msg\":\"\",\"count\":".$total.",\"data\":[";

			$query="select * from ".$table_pre."msg ".$sql_con."order by ".$sql_order." limit ".$start.",".$end;
			//echo $query."<br>";
			$res=$db->query($query);
			$count=0;
			while($msg=$db->fetch_array($res)){
				$str_tmp.="{";
				$str_tmp.="\"id\":\"".$msg["id"]."\",";

				$list=$start+$count+1;
				$str_tmp.="\"xh\":\"".$list."\",";

				//$content[$count][]="<input type=\"checkbox\" id=\"cb".$count."\" name=\"id[]\" value=\"".$msg["id"]."\"><a href=\"".$_SERVER[PHP_SELF]."?_m=".$_m."&_cid=".$_cid."&_a=add&id=".$msg["id"]."\">".$list."</a>";
				//$content[$count][]=get_main_value($arr_yn,$msg["is_read"]);
				$str_tmp.="\"is_read\":\"".get_main_value($arr_yn,$msg["is_read"])."\",";

				$tmp_from=get_db_msg("select * from ".$table_pre."client where id='".$msg["from_cid"]."'");
				$tmp_to=get_db_msg("select * from ".$table_pre."client where id='".$msg["to_cid"]."'");
				$str_tmp.="\"from\":\"".$tmp_from["title"]."(".$tmp_from["username"].")\",";
				$str_tmp.="\"from_cid\":\"".$tmp_from["id"]."\",";

				$str_tmp.="\"to\":\"".$tmp_to["username"]."\",";
				$str_tmp.="\"to_cid\":\"".$tmp_to["id"]."\",";

				$str_tmp.="\"text\":\"".dhtmlchars($msg["text"])."\",";
				$str_tmp.="\"add_date\":\"".date("Y-m-d H:i:s",$msg["add_date"])."\"";
				$str_tmp.="},";

				//$content[$count][]=$tmp_from["title"]."(<a href=\"".$_SERVER[PHP_SELF]."?_cid=".$_cid."&_m=".$_m."&_a=add&to_cid=".$tmp_from["id"]."&from_cid=".$tmp_to["id"]."\">".$tmp_from["username"]."</a>)";
				//$content[$count][]=$tmp_to["title"]."(".$tmp_to["username"].")";
				//$content[$count][]=dhtmlchars($msg["text"]);
				//$content[$count][]=date("Y-m-d H:i:s",$msg["add_date"]);
				$count++;
			}
			$json_data.=substr($str_tmp,0,-1)."],";
		break;
	}
}
$json_data=substr($json_data,0,-1)."}";
echo $json_data;
?>