68 lines
1.7 KiB
PHP
68 lines
1.7 KiB
PHP
<?php
|
|
|
|
include "db.php";
|
|
include "table.php";
|
|
|
|
$staffTable = new Table("people");
|
|
$userTable = new Table("users");
|
|
|
|
db_query("USE hotlunch_20171031");
|
|
$school_num = 18498;
|
|
|
|
$staff = array();
|
|
$users = array();
|
|
|
|
$query = "SELECT * FROM people WHERE school_num = $school_num AND people_type = 'Staff'";
|
|
$people = db_query($query);
|
|
|
|
$num = db_num_rows($people);
|
|
echo("Staff: $num\n");
|
|
|
|
while ($row = db_fetch_assoc($people)) {
|
|
extract($row);
|
|
$staff[] = $row;
|
|
|
|
$query = "SELECT * FROM users WHERE school_num = $base_school_num AND record_num = $user_num";
|
|
$results = db_query($query);
|
|
if (db_num_rows($results)) {
|
|
$row = db_fetch_assoc($results);
|
|
$users[] = $row;
|
|
}
|
|
}
|
|
|
|
db_query("USE hotlunch");
|
|
|
|
$query = "DELETE FROM people WHERE school_num = $school_num AND people_type = 'Staff'";
|
|
db_query($query);
|
|
|
|
for ($i = 0; $i < count($staff); $i++) {
|
|
$row = $staff[$i];
|
|
$rnum = $row['record_num'];
|
|
echo("People : $rnum " . $row['first_name'] . " " . $row['last_name']);
|
|
$results = db_query("SELECT * FROM people WHERE school_num = $school_num AND record_num = $rnum");
|
|
if (db_num_rows($results) == 0) {
|
|
echo(" - Not Found\n");
|
|
$query = $staffTable->BuildInsert($row);
|
|
echo("$query\n");
|
|
db_query($query);
|
|
}
|
|
else echo("\n");
|
|
}
|
|
|
|
echo("\n");
|
|
exit();
|
|
|
|
for ($i = 0; $i < count($users); $i++) {
|
|
$row = $users[$i];
|
|
$rnum = $row['record_num'];
|
|
$results = db_query("SELECT * FROM users WHERE school_num = $base_school_num AND record_num = $rnum");
|
|
if (db_num_rows($results) == 0) {
|
|
echo("User Not Found: " . $row['first_name'] . " " . $row['last_name'] . "\n");
|
|
$query = $userTable->BuildInsert($row,'Yes');
|
|
echo("$query\n");
|
|
db_query($query);
|
|
}
|
|
}
|
|
|
|
?>
|