<?php
session_start();
if( !defined('IN') ) die('bad request!');
include_once( AROOT . 'controller' . DS . 'app.class.php');
header("Content-Type: text/html; charset=utf-8");

class userController extends appController
{
	public function __construct()
	{
		parent::__construct();
	}

	// 发送错误结果集
	public function send_error($number,$msg)
	{
		$obj = array();
		$obj['code'] = intval($number);
		$obj['result'] = $msg;

		if( g('API_EMBED_MODE') == 1 ){
			return json_encode($obj);
		}else{
			header("Content-Type: application/json");
			die(json_encode($obj));
		}
	}

	// 发送结果集
	public function send_result($total,$data)
	{
		$obj = array();
		$obj['rows'] = $data;
		// $obj['result'] = 'success';
		$obj['total'] = $total;

		if( g('API_EMBED_MODE') == 1 ){
			return json_encode($obj);
		}else{
			header("Content-Type: application/json");
			die(json_encode($obj));
		}
	}

	// 发送结果集
	public function send_resu($data)
	{
		$obj = array();
		$obj['code'] = 0;
		$obj['message'] = 'success';
		$obj['data'] = $data;

		if( g('API_EMBED_MODE') == 1 ){
			return json_encode($obj);
		}else{
			header("Content-Type: application/json");
			die(json_encode($obj));
		}
	}

	public function userDataTable(){
		$project_id = $_SESSION['project_id'];

		if($_SESSION['project_id'] == '0')
		{
			$sql = "select id,project_id,account,name,mobile,login_time from user";
			$data = get_data($sql);
			
			for($i=0;$i<count($data);$i++)
			{
				$projectid = $data[$i]['project_id'];

				if($projectid != '0')
				{
					$sql_project = prepare("select name from project where id=?i",array($projectid)); 
					$project = get_var($sql_project);
				}
				else
				{
					$project = '全部项目';
				}
				$data[$i]['project'] =$project; 
			}
		}
		else
		{
			$sql = prepare("select user.id,user.name,user.account,user.mobile,user.login_time,project.name as project from user,project where user.project_id=project.id and project.id=?i",array($project_id));
			$data = get_data($sql);
		}
		$total = count($data);
		return self::send_result($total,$data);
	}

	//用户修改页面
	public function userEdit(){
		$id = v('id');
		$sql = prepare("select * from user where id=?i",array($id));
		$data = get_line($sql);
		$projectid = $data['project_id'];
		if($projectid == 0){
			$data['project'] ='';
		}else{
			$sql2 = prepare("select name from project where id=?i",array($projectid));
			$data['project'] = get_var($sql2);
		}
		// if (!empty($_SESSION)) {
			render($data, 'web', 'userEdit');
		
		// } else {

		// 	header("Location:?c=index&a=index");

		// }
	}

	//用户修改提交接口
	public function userUpdate(){
		$id= $_POST['id'];
		$project= $_POST['project'];
		$name= $_POST['name'];
		$mobile= $_POST['mobile'];
		$sql_update = prepare("update user set name=?s,mobile=?s where id=?i",array($name,$mobile,$id));
		$resu = run_sql($sql_update);
		if($resu){
			return self::send_resu('success');
		}else{
			return self::send_resu('failure');
		}
	}

	//项目列表
	public function userAdd(){
		$project = $_POST['project'];
		$name    = $_POST['name'];
		$mobile  = $_POST['mobile'];
		$duty    = $_POST['duty'];
		$account = $this -> getPinyin($name);
		$current_time = date("md",time());
		$password = md5($account.$current_time);
		$created_at = date("Y-m-d H:i:s",time());
		$sql_project = prepare("select id from project where name=?s",array($project));
		$project_id = get_var($sql_project);
		$sql_insert = prepare("insert into user(account,password,project_id,name,duty,mobile,created_at) value(?s,?s,?i,?s,?s,?s,?s)",array($account,$password,$project_id,$name,$duty,$mobile,$created_at));
		$resu = run_sql($sql_insert);
		if($resu){
			return self::send_resu('success');
		}else{
			return self::send_resu('failure');
		}
	}

	//获取拼音
	private function getPinyin($str,$code = 'gb2312'){
	    $_DataKey = "a|ai|an|ang|ao|ba|bai|ban|bang|bao|bei|ben|beng|bi|bian|biao|bie|bin|bing|bo|bu|ca|cai|can|cang|cao|ce|ceng|cha" . "|chai|chan|chang|chao|che|chen|cheng|chi|chong|chou|chu|chuai|chuan|chuang|chui|chun|chuo|ci|cong|cou|cu|" . "cuan|cui|cun|cuo|da|dai|dan|dang|dao|de|deng|di|dian|diao|die|ding|diu|dong|dou|du|duan|dui|dun|duo|e|en|er" . "|fa|fan|fang|fei|fen|feng|fo|fou|fu|ga|gai|gan|gang|gao|ge|gei|gen|geng|gong|gou|gu|gua|guai|guan|guang|gui" . "|gun|guo|ha|hai|han|hang|hao|he|hei|hen|heng|hong|hou|hu|hua|huai|huan|huang|hui|hun|huo|ji|jia|jian|jiang" . "|jiao|jie|jin|jing|jiong|jiu|ju|juan|jue|jun|ka|kai|kan|kang|kao|ke|ken|keng|kong|kou|ku|kua|kuai|kuan|kuang" . "|kui|kun|kuo|la|lai|lan|lang|lao|le|lei|leng|li|lia|lian|liang|liao|lie|lin|ling|liu|long|lou|lu|lv|luan|lue" . "|lun|luo|ma|mai|man|mang|mao|me|mei|men|meng|mi|mian|miao|mie|min|ming|miu|mo|mou|mu|na|nai|nan|nang|nao|ne" . "|nei|nen|neng|ni|nian|niang|niao|nie|nin|ning|niu|nong|nu|nv|nuan|nue|nuo|o|ou|pa|pai|pan|pang|pao|pei|pen" . "|peng|pi|pian|piao|pie|pin|ping|po|pu|qi|qia|qian|qiang|qiao|qie|qin|qing|qiong|qiu|qu|quan|que|qun|ran|rang" . "|rao|re|ren|reng|ri|rong|rou|ru|ruan|rui|run|ruo|sa|sai|san|sang|sao|se|sen|seng|sha|shai|shan|shang|shao|" . "she|shen|sheng|shi|shou|shu|shua|shuai|shuan|shuang|shui|shun|shuo|si|song|sou|su|suan|sui|sun|suo|ta|tai|" . "tan|tang|tao|te|teng|ti|tian|tiao|tie|ting|tong|tou|tu|tuan|tui|tun|tuo|wa|wai|wan|wang|wei|wen|weng|wo|wu" . "|xi|xia|xian|xiang|xiao|xie|xin|xing|xiong|xiu|xu|xuan|xue|xun|ya|yan|yang|yao|ye|yi|yin|ying|yo|yong|you" . "|yu|yuan|yue|yun|za|zai|zan|zang|zao|ze|zei|zen|zeng|zha|zhai|zhan|zhang|zhao|zhe|zhen|zheng|zhi|zhong|" . "zhou|zhu|zhua|zhuai|zhuan|zhuang|zhui|zhun|zhuo|zi|zong|zou|zu|zuan|zui|zun|zuo";
	    $_DataValue = "-20319|-20317|-20304|-20295|-20292|-20283|-20265|-20257|-20242|-20230|-20051|-20036|-20032|-20026|-20002|-19990" . "|-19986|-19982|-19976|-19805|-19784|-19775|-19774|-19763|-19756|-19751|-19746|-19741|-19739|-19728|-19725" . "|-19715|-19540|-19531|-19525|-19515|-19500|-19484|-19479|-19467|-19289|-19288|-19281|-19275|-19270|-19263" . "|-19261|-19249|-19243|-19242|-19238|-19235|-19227|-19224|-19218|-19212|-19038|-19023|-19018|-19006|-19003" . "|-18996|-18977|-18961|-18952|-18783|-18774|-18773|-18763|-18756|-18741|-18735|-18731|-18722|-18710|-18697" . "|-18696|-18526|-18518|-18501|-18490|-18478|-18463|-18448|-18447|-18446|-18239|-18237|-18231|-18220|-18211" . "|-18201|-18184|-18183|-18181|-18012|-17997|-17988|-17970|-17964|-17961|-17950|-17947|-17931|-17928|-17922" . "|-17759|-17752|-17733|-17730|-17721|-17703|-17701|-17697|-17692|-17683|-17676|-17496|-17487|-17482|-17468" . "|-17454|-17433|-17427|-17417|-17202|-17185|-16983|-16970|-16942|-16915|-16733|-16708|-16706|-16689|-16664" . "|-16657|-16647|-16474|-16470|-16465|-16459|-16452|-16448|-16433|-16429|-16427|-16423|-16419|-16412|-16407" . "|-16403|-16401|-16393|-16220|-16216|-16212|-16205|-16202|-16187|-16180|-16171|-16169|-16158|-16155|-15959" . "|-15958|-15944|-15933|-15920|-15915|-15903|-15889|-15878|-15707|-15701|-15681|-15667|-15661|-15659|-15652" . "|-15640|-15631|-15625|-15454|-15448|-15436|-15435|-15419|-15416|-15408|-15394|-15385|-15377|-15375|-15369" . "|-15363|-15362|-15183|-15180|-15165|-15158|-15153|-15150|-15149|-15144|-15143|-15141|-15140|-15139|-15128" . "|-15121|-15119|-15117|-15110|-15109|-14941|-14937|-14933|-14930|-14929|-14928|-14926|-14922|-14921|-14914" . "|-14908|-14902|-14894|-14889|-14882|-14873|-14871|-14857|-14678|-14674|-14670|-14668|-14663|-14654|-14645" . "|-14630|-14594|-14429|-14407|-14399|-14384|-14379|-14368|-14355|-14353|-14345|-14170|-14159|-14151|-14149" . "|-14145|-14140|-14137|-14135|-14125|-14123|-14122|-14112|-14109|-14099|-14097|-14094|-14092|-14090|-14087" . "|-14083|-13917|-13914|-13910|-13907|-13906|-13905|-13896|-13894|-13878|-13870|-13859|-13847|-13831|-13658" . "|-13611|-13601|-13406|-13404|-13400|-13398|-13395|-13391|-13387|-13383|-13367|-13359|-13356|-13343|-13340" . "|-13329|-13326|-13318|-13147|-13138|-13120|-13107|-13096|-13095|-13091|-13076|-13068|-13063|-13060|-12888" . "|-12875|-12871|-12860|-12858|-12852|-12849|-12838|-12831|-12829|-12812|-12802|-12607|-12597|-12594|-12585" . "|-12556|-12359|-12346|-12320|-12300|-12120|-12099|-12089|-12074|-12067|-12058|-12039|-11867|-11861|-11847" . "|-11831|-11798|-11781|-11604|-11589|-11536|-11358|-11340|-11339|-11324|-11303|-11097|-11077|-11067|-11055" . "|-11052|-11045|-11041|-11038|-11024|-11020|-11019|-11018|-11014|-10838|-10832|-10815|-10800|-10790|-10780" . "|-10764|-10587|-10544|-10533|-10519|-10331|-10329|-10328|-10322|-10315|-10309|-10307|-10296|-10281|-10274" . "|-10270|-10262|-10260|-10256|-10254";
	    $_TDataKey = explode ( '|', $_DataKey );
	    $_TDataValue = explode ( '|', $_DataValue );
	    $data = (PHP_VERSION >= '5.0') ? array_combine ( $_TDataKey, $_TDataValue ) : $this->_Array_Combine( $_TDataKey, $_TDataValue );
	    arsort ( $data );
	    reset ( $data );
	    $str = $this->safe_encoding ( $str );
	    $_Res = '';
	    for($i = 0; $i < strlen ( $str ); $i ++) {
	      $_P = ord ( substr ( $str, $i, 1 ) );
	      if ($_P > 160) {
	        $_Q = ord ( substr ( $str, ++ $i, 1 ) );
	        $_P = $_P * 256 + $_Q - 65536;
	      }
	      $_Res .= substr($this->_Pinyin ( $_P, $data ),0,1);
	    }
	    return preg_replace ( "/[^a-z0-9]*/", '', $_Res );
	 }

	  //编码转换
	private function safe_encoding($string) {
	  	$_outEncoding = "GB2312";
	    $encoding="UTF-8";
	    for($i=0;$i<strlen($string);$i++) {
	      if(ord($string{$i})<128) continue;
	      if((ord($string{$i})&224)==224) { //第一个字节判断通过
	        $char=$string{++$i};
	        if((ord($char)&128)==128) { //第二个字节判断通过
	          $char=$string{++$i};
	          if((ord($char)&128)==128) {
	            $encoding="UTF-8";
	            break;
	          }
	        }
	      }
	      if((ord($string{$i})&192)==192) { //第一个字节判断通过
	        $char=$string{++$i};
	        if((ord($char)&128)==128) { //第二个字节判断通过
	          $encoding="GB2312";
	          break;
	        }
	      }
	    }
	    if(strtoupper($encoding)==strtoupper($_outEncoding))
	      return $string;
	    else
	      return iconv($encoding,$_outEncoding,$string);
	}


	//转换拼音
	private function _Pinyin($_Num, $_Data) {
	    if ($_Num > 0 && $_Num < 160)
	      	return chr ( $_Num );
	    elseif ($_Num < - 20319 || $_Num > - 10247)
	      	return '';
	    else {
	      	foreach ( $_Data as $k => $v ) {
	        	if ($v <= $_Num)
	          	break;
	      	}
	      return $k;
	    }
	}


	/**
	 * 获取两个指定日期之间的每一天
	 */
	public function getDateFromtime($starttime,$endtime)
	{
		
		$dt_start = strtotime($starttime);
	    $dt_end   = strtotime($endtime);

	    while ($dt_start <= $dt_end){

	    	$array[] = date('Y-m-d',$dt_start);
	       
	        $dt_start = strtotime('+1 day',$dt_start);
	    }

	    return $array;
	}


	/**
	 * 获取本年的12个月
	 */
	public function getYearMonthTime()
	{
	
		for ($i=1; $i < 13; $i++) { 

			$month = date("Y",time())."-".$i;

			$array[] = date("Y-m",strtotime($month));

		}

		return $array;
	}

	public function getUserTreeData()
	{
		$role_id 	= $_SESSION['role_id'];
		$project_id = $_SESSION['project_id'];

		if($role_id == 2)
		{
			// 管理员用户 查看所有设备

			$sql  = "select id,sector as text, '#' as parent from sector";
			$data = get_data($sql);

		}elseif($role_id == 1)
		{
			// 项目用户只能查看当前管理的设备
			$sql  = prepare("select id,sector as text, '#' as parent from sector where project_id = ?i",array($project_id));
			$data = get_data($sql);
		}

		for ($i=0; $i < count($data); $i++) {

		 	$sector_id = $data[$i]['id'];

			$sql_1 = prepare("select (id+50) as id, SUBSTRING(name, 1, CHAR_LENGTH(name) - 3) as text, s_id as parent from device where s_id = ?i",array($sector_id));
			$data_1[$i] = get_data($sql_1);
		}

		foreach($data_1 as $value){
			if(!empty($value)){
				foreach ($value as $v) {
					array_push($data,$v);
				}
			}
		}

		// 重组数组
		for ($j=0; $j < count($data); $j++) 
		{ 
		 	$result[$j]['id']     = $data[$j]['id'];
		 	$result[$j]['text']   = $data[$j]['text'];
		 	$result[$j]['parent'] = $data[$j]['parent'];
		 } 


		return self::send_resu($result);
		
	}

	public function getUserSettingList()
	{
		$role_id 	= $_SESSION['role_id'];
		$project_id = $_SESSION['project_id'];

		if($role_id == 2)
		{
			// 管理员用户 查看所有人员

			$sql  = "select user.id,project.name as project_name,sector.sector,user.account,user.name,user.mobile,user.device_str from user left join project on project.id = user.project_id left join sector on sector.id = user.s_id  where user.name != '管理员'";

		}elseif($role_id == 1)
		{
			// 项目用户只能查看当前管理的设备
			$sql  = prepare("select user.id,project.name as project_name,sector.sector,user.account,user.name,user.mobile,user.device_str from user left join project on project.id = user.project_id left join sector on sector.id = user.s_id where user.name != '管理员' and user.project_id = ?i ",array($project_id));
		}

		$data = get_data($sql);

		for ($i=0; $i < count($data); $i++) 
		{ 
			$result[$i]['id'] = $data[$i]['id'];
			$result[$i]['project_name'] = $data[$i]['project_name'];
			$result[$i]['sector'] = $data[$i]['sector'];
			$result[$i]['account'] = $data[$i]['account'];
			$result[$i]['name'] = $data[$i]['name'];
			$result[$i]['mobile'] = $data[$i]['mobile'];

			$device_name_array = explode('-',$data[$i]['device_str']);
			if(count($device_name_array)>1)
			{
				for ($j=0; $j < count($device_name_array); $j++) 
				{ 
					$sql_device_id = prepare("select name from device where id = ?i limit 1",array(trim($device_name_array[$j])));
					$device_id_array[$i] = get_var($sql_device_id);
				}
				$result[$i]['device_name'] = implode('-', $device_id_array);
			}else
			{
				$sql_device_id = prepare("select name from device where id = ?i limit 1",array($data[$i]['device_str']));
				$result[$i]['device_name'] = get_var($sql_device_id);
			}
		}

		return self::send_resu($result);
	}

	public function getUserListBySector()
	{
		$s_id = $_GET['s_id'];

		$sql  = prepare("select user.id,project.name as project_name,sector.sector,user.account,user.name,user.mobile from user left join project on project.id = user.project_id left join sector on sector.id = user.s_id  where user.name != '管理员' and s_id = ?i",array($s_id));

		$data = get_data($sql);

		return self::send_resu($data);
	}

	public function getUserListByDevice()
	{
		$d_id = $_GET['d_id'];

		$id = $d_id-50;

		$sql  = "select user.id,project.name as project_name,sector.sector,user.account,user.name,user.mobile,user.device_str from user left join project on project.id = user.project_id left join sector on sector.id = user.s_id  where user.name != '管理员'";
		$data = get_data($sql);

		for ($i=0; $i < count($data); $i++) 
		{ 
			$device_id_str = $data[$i]['device_str'];

			// 判断ID是否在这个数组内
			$device_id_array = explode("-",$device_id_str);

			if(in_array($id,$device_id_array))
			{
				$result[$i]['id'] 		= $data[$i]['id'];
				$result[$i]['project_name'] = $data[$i]['project_name'];
				$result[$i]['sector'] 	= $data[$i]['sector'];
				$result[$i]['account'] 	= $data[$i]['account'];
				$result[$i]['name'] 	= $data[$i]['name'];
				$result[$i]['mobile'] 	= $data[$i]['mobile'];
			}
		}

		return self::send_resu($result);

	}

	public function getUserSettingDelete()
	{
		$id  = $_GET['id'];
		$sql = prepare("delete from user where id=?i",array($id));
		$impact = run_sql($sql);
		if($impact){
		    $result = "success";
		    return self::send_resu($result);
		 }
	}

	public function getUserSettingEdit()
	{
		$id = $_GET['id'];

		$sql  = prepare("select user.id,project.name as project_name,sector.sector,user.account,user.name,user.mobile from user left join project on project.id = user.project_id left join sector on sector.id = user.s_id  where user.name != '管理员' and user.id = ?i",array($id));

		$data = get_line($sql);

		return self::send_resu($data);
	}

	public function getUserSettingUpdate()
	{
		$id   	= $_POST['id'];
		$account = $_POST['account'];
		$name 	= $_POST['name'];
		$mobile = $_POST['mobile'];
		
		$sql = prepare("update user set account=?s,name=?s,mobile=?s where id = ?i",array($account,$name,$mobile,$id));
		$impact = run_sql($sql);
		if($impact){
		  $result = "success";
		  return self::send_resu($result);
		}
	}

	public function getUserSettingInsert()
	{
		$project_name = $_POST['project_name'];
		$sector   	  = $_POST['sector'];
		$account  	  = $_POST['account'];
		$password 	  = md5($_POST['password']);
		$name 	  	  = $_POST['name'];
		$mobile   	  = $_POST['mobile'];
		$note 	  	  = $_POST['note'];
		$current_time = date("Y-m-d H:i:s",time());
		$role_id      = 1;
		$type         = 1;
		
		// 获取 porject_id
		$sql_project_id = prepare("select id from project where name = ?s limit 1",array($project_name));
		$project_id = get_var($sql_project_id);
		
		// 获取s_id
		$sql_s_id = prepare("select id from sector where sector = ?s limit 1",array($sector));
		$s_id = get_var($sql_s_id);
		$token = $this->generateRandomNumber(28);

		$note_array = explode('、',$note);
		if(count($note_array)>1)
		{
			for ($i=0; $i < count($note_array); $i++) 
			{ 
				$sql_device_id = prepare("select id from device where name = ?s and project_id = ?i limit 1",array(trim($note_array[$i]),$project_id));
				$device_id_array[$i] = get_var($sql_device_id);
			}
			$device_str = implode('-', $device_id_array);
		}else
		{
			$sql_device_id = prepare("select id from device where name = ?s and project_id = ?i limit 1",array($note,$project_id));
			$device_str = get_var($sql_device_id);
		}
		$sql_insert = prepare("insert into user (id,project_id,account,password,token,name,mobile,created_at,role_id,device_str,type,s_id) values (null,?i,?s,?s,?s,?s,?s,?s,?i,?s,?i,?i)",array($project_id,$account,$password,$token,$name,$mobile,$current_time,$role_id,$device_str,$type,$s_id));
		$impact = run_sql($sql_insert);
		if($impact){
		  $result = "success";
		  return self::send_resu($sql_insert);
		}
	}

	// 生成token
	public function generateRandomNumber($length) {
	    $randomNumber = '';
	    for ($i = 0; $i < $length; $i++) {
	        // 每次生成一个0-9之间的随机数
	        $randomNumber .= mt_rand(0, 9);
	    }
	    return $randomNumber;
	}
}