| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /nginx/html/Admin/User/ |
Upload File : |
<?
// Admin/User/userDuplicate_by_userName.phpinc
// Get list of duplicate Users by userFirstName,userLastName.
$query = "
SELECT concat(userFirstName,userLastName) AS userFullName, COUNT(concat(userFirstName,userLastName)) AS userFullNameNumOccurrences
FROM user
GROUP BY concat(userFirstName,userLastName)
HAVING COUNT(concat(userFirstName,userLastName)) > 1
";
$userDuplicateList = query_do($query);
$userDuplicateCountByName = $_SESSION['qry']['count'];
if (dc()) { echo basename(__FILE__)," line ",__LINE__,": ","\$userDuplicateCountByName=".$userDuplicateCountByName."<br>\n"; }
if ( !isset($userDuplicateSectionStarted) ) $userDuplicateSectionStarted = false;
if ( !$userDuplicateSectionStarted && $userDuplicateCountByName ) {
$userDuplicateSectionStarted = true;
$sectionTitle = 'Duplicate Users';
include('common/sectionHeader.phpinc');
}
if ($userDuplicateCountByName) {
/*
// Convert userDuplicateList to simple list.
$userSimleList = "";
mysqli_data_seek($userDuplicateList , 0);
while ($userDuplicateInfo = mysqli_fetch_assoc($userDuplicateList)) {
$userSimleList .= ", '".$userDuplicateInfo['userFullName']."'";
}
$userSimleList = substr($userSimleList,2);
echo "\$userSimleList=",$userSimleList,"<br>\n";
#exit;
$query = "
SELECT userId
FROM user
WHERE concat(userFirstName,userLastName) IN (
".$userSimleList."
)
";
$userDuplicateList = query_do($query);
$userDuplicateCountByName = $_SESSION['qry']['count'];
*/
?>
<fieldset><legend>Possible duplicate users by Name</legend>
<table class="center" border="0" cellpadding="1" cellspacing="0">
<tr><td class="grayline"></td><th class="grayline">MergeTo</th><th class="grayline">Merge</th><th class="grayline">userId</th><th class="grayline">Username</th><th class="grayline">First name</th><th class="grayline">Last name</th><th class="grayline">Student ID</th><th class="grayline">Last login</th><th class="grayline">Login count</th></tr>
<?
mysqli_data_seek($userDuplicateList , 0);
while ($userDuplicateInfo = mysqli_fetch_assoc($userDuplicateList)) {
if (dc()) { echo basename(__FILE__)," line ",__LINE__,": ","\$userDuplicateInfo['userStudentId']=".$userDuplicateInfo['userStudentId']."<br>\n"; }
// Get current list of duplicate Users by userStudentId.
$query = "
SELECT *
FROM user
WHERE concat(userFirstName,userLastName) = '".$userDuplicateInfo['userFullName']."'
ORDER BY userLastName, userFirstName, userId
";
$userCurrentDuplicateList = query_do($query);
$userCurrentDuplicateCount = $_SESSION['qry']['count'];
if (dc()) { echo basename(__FILE__)," line ",__LINE__,": ","\$userCurrentDuplicateCount=".$userCurrentDuplicateCount."<br>\n"; }
$count = 1;
while ($userCurrentDuplicateInfo = mysqli_fetch_assoc($userCurrentDuplicateList)) {
if ($count == $userCurrentDuplicateCount) {
$class = ' grayline';
} else {
$class = '';
}
if ($count == 1) {
$checked = ' checked="checked"';
?>
<form name="form_userMerge" action="<?=php_self()?>" method="post" style="display:inline;" />
<input name="f_uuid" type="hidden" value="<?=uuid()?>" />
<input name="f_form" type="hidden" value="form_userMerge" />
<tr>
<td class="grayline" rowspan="<?=$userCurrentDuplicateCount?>">
<input type="submit" name="f_task" value="Merge" />
</td>
<?
} else {
$checked = '';
?>
<tr>
<?
}
?>
<td class="center<?=$class?>"><input type="radio" name="f_userIdToMergeTo" id="f_userIdToMergeTo" value="<?=$userCurrentDuplicateInfo['userId']?>"<?=$checked?> /></td>
<td class="center<?=$class?>"><input type="checkbox" name="f_userIdToMergeFrom_<?=$count?>" id="f_userIdToMergeFrom_<?=$count?>" value="<?=$userCurrentDuplicateInfo['userId']?>" checked="checked" /></td>
<td class="right<?=$class?>"><?=$userCurrentDuplicateInfo['userId']?></td>
<td class="<?=$class?>"><?=$userCurrentDuplicateInfo['userUsername']?></td>
<td class="right<?=$class?>"><?=stripslashes($userCurrentDuplicateInfo['userFirstName'])?></td>
<td class="<?=$class?>"><?=stripslashes($userCurrentDuplicateInfo['userLastName'])?></td>
<td class="<?=$class?>"><?=$userCurrentDuplicateInfo['userStudentId']?></td>
<td class="<?=$class?>"><?=$userCurrentDuplicateInfo['userAccessTime']?></td>
<td class="right<?=$class?>"><?=$userCurrentDuplicateInfo['userLoginCount']?></td>
</tr>
<?
$count++;
}
$count--;
?>
<input name="f_count" type="hidden" value="<?=$count?>" />
</form>
<?
}
?>
</table>
</fieldset>
<?
} else {
?>
No possible duplicate users by Name.<br>
<?
}