$v){
$fen=explode(",",trim($v));
foreach($fen as $f){
if(!empty($f)&&!in_array($f,$arr)){
$arr[]=$f;
$likearr[]="realname = '$f'";
}
}
}
$likestr = empty($likearr)?"":"and (".implode(" or ",$likearr).")";
//$classstr=empty($classid)?"":"and classid = ".intval($classid);
$classstr="";
$gradearr=array();
if(!empty($grade)){
$gradearr=explode(",",$grade);
foreach($gradearr as $k => $v){
$gradearr[$k]=intval($v);
}
}
//$gradestr=empty($gradearr)?"":"and grade in (".implode(",",$gradearr).")";
$gradestr=empty($grade)?"":"and grade = ".intval($grade);
$gradeurl=empty($grade)?"":"&grade_operator=%3D&grade=".intval($grade);
global $list;
$list=sql("select id,Group_concat(id) as ids,realname from {{user}} where schoolid = '".intval($schoolid)."' and studentid is not null $gradestr $classstr $likestr group by realname")->queryAll();
//print_r($list);
echo '
结果1:
';
function getid($str){
global $list;
$id="";
foreach($list as $v){
if($v['realname']==$str){
//$id = $v['id'];
$id = $v['ids'];
break;
}
}
return $id;
}
$line=array();
foreach($strarr as $k => $v){
$fen=explode(",",trim($v));
$tarr=array();
foreach($fen as $f){
if(empty($f)){
//$tarr[]="";
}
else{
$id=getid($f);
if(!empty($id))$tarr[]=$id;
}
}
$line[]=implode(",",$tarr);
}
//print_r($line);
echo '
';
$same=sql("select id,realname,phone,count(*) as count,Group_concat(id) as ids,Group_concat(studentid) as studentids from {{user}} where schoolid = '".intval($schoolid)."' and studentid is not null $gradestr $classstr $likestr group by realname having count>1")->queryAll();
//print_r($same);
$samearr=array();
foreach($same as $v){
$idsarr=explode(",",$v['ids']);
$studentidsarr=explode(",",$v['studentids']);
$arr2=array();
foreach($idsarr as $k => $s){
$arr2[]="{".$idsarr[$k].":".$studentidsarr[$k]."}";
}
$arr2str=implode(",",$arr2);
$samearr[]='
'.$v['realname']."(".$v['count'].")".$arr2str.'';
}
if(!empty($same)){
echo "
重名{ID:学号}:
".implode("
",$samearr)."
";
}
$nonearr=array();
foreach($arr as $v){
$isin=false;
foreach($list as $c){
if($c['realname']==$v){
$isin=true;
break;
}
}
if(!$isin)$nonearr[]=$v;
}
if(!empty($nonearr))echo "
不存在:
".implode("
",$nonearr)."
";
echo "
结果2:
";
$line=array();
foreach($strarr as $k => $v){
$fen=explode(",",trim($v));
$tarr=array();
foreach($fen as $f){
if(empty($f)){
$tarr[]=$f;
}
else{
$id=getid($f);
if(empty($id)){
$tarr[]=$f;
}
else{
$tarr[]=$id;
}
}
}
$line[]=implode(",",$tarr);
}
//print_r($line);
echo '
';
echo '
';
exit;
}
?>