private function createPersons()
{
$person = new Person();
$person->drop()->yesImSure();
$person->createTable();
$persons = array(array('f' => 'Jane', 'l' => 'Wayne', 'zip' => 1003), array('f' => 'John', 'l' => 'Anderson', 'zip' => 1004), array('f' => 'Mike', 'l' => 'Johnson', 'zip' => 1005), array('f' => 'Katy', 'l' => 'Peterson', 'zip' => 1006));
foreach ($persons as $person) {
$p = new Person();
$p->setFirstname($person['f']);
$p->setLastname($person['l']);
$p->setZip($person['zip']);
$p->commit();
}
}
public function register($postArr)
{
$status = false;
$firstName = $postArr['firstname'];
$lastName = $postArr['lastname'];
if ($postArr['institution'] && !trim(strpos($postArr['institution'], ' ')) && preg_match('/[a-z]+[A-Z]+[a-z]+[A-Z]+/', $postArr['institution'])) {
if ($postArr['title'] && !trim(strpos($postArr['title'], ' ')) && preg_match('/[a-z]+[A-Z]+[a-z]+[A-Z]+/', $postArr['title'])) {
return false;
}
}
$person = new Person();
$person->setPassword($postArr['pwd']);
$person->setUserName($this->userName);
$person->setFirstName($firstName);
$person->setLastName($lastName);
$person->setTitle($postArr['title']);
$person->setInstitution($postArr['institution']);
$person->setCity($postArr['city']);
$person->setState($postArr['state']);
$person->setZip($postArr['zip']);
$person->setCountry($postArr['country']);
$person->setEmail($postArr['emailaddr']);
$person->setUrl($postArr['url']);
$person->setBiography($postArr['biography']);
$person->setIsPublic(isset($postArr['ispublic']) ? 1 : 0);
//Add to users table
$fields = 'INSERT INTO users (';
$values = 'VALUES (';
$fields .= 'firstname ';
$values .= '"' . $this->cleanInStr($person->getFirstName()) . '"';
$fields .= ', lastname';
$values .= ', "' . $this->cleanInStr($person->getLastName()) . '"';
if ($person->getTitle()) {
$fields .= ', title';
$values .= ', "' . $this->cleanInStr($person->getTitle()) . '"';
}
if ($person->getInstitution()) {
$fields .= ', institution';
$values .= ', "' . $this->cleanInStr($person->getInstitution()) . '"';
}
if ($person->getDepartment()) {
$fields .= ', department';
$values .= ', "' . $this->cleanInStr($person->getDepartment()) . '"';
}
if ($person->getAddress()) {
$fields .= ', address';
$values .= ', "' . $this->cleanInStr($person->getAddress()) . '"';
}
if ($person->getCity()) {
$fields .= ', city';
$values .= ', "' . $this->cleanInStr($person->getCity()) . '"';
}
$fields .= ', state';
$values .= ', "' . $this->cleanInStr($person->getState()) . '"';
$fields .= ', country';
$values .= ', "' . $this->cleanInStr($person->getCountry()) . '"';
if ($person->getZip()) {
$fields .= ', zip';
$values .= ', "' . $this->cleanInStr($person->getZip()) . '"';
}
if ($person->getPhone()) {
$fields .= ', phone';
$values .= ', "' . $this->cleanInStr($person->getPhone()) . '"';
}
if ($person->getEmail()) {
$fields .= ', email';
$values .= ', "' . $this->cleanInStr($person->getEmail()) . '"';
}
if ($person->getUrl()) {
$fields .= ', url';
$values .= ', "' . $person->getUrl() . '"';
}
if ($person->getBiography()) {
$fields .= ', biography';
$values .= ', "' . $this->cleanInStr($person->getBiography()) . '"';
}
if ($person->getIsPublic()) {
$fields .= ', ispublic';
$values .= ', ' . $person->getIsPublic();
}
$sql = $fields . ') ' . $values . ')';
//echo "SQL: ".$sql;
$editCon = $this->getConnection('write');
if ($editCon->query($sql)) {
$person->setUid($editCon->insert_id);
$this->uid = $person->getUid();
//Add userlogin
$sql = 'INSERT INTO userlogin (uid, username, password) ' . 'VALUES (' . $person->getUid() . ', "' . $this->cleanInStr($person->getUserName()) . '", PASSWORD("' . $this->cleanInStr($person->getPassword()) . '"))';
if ($editCon->query($sql)) {
$status = true;
//authenicate
$this->userName = $person->getUserName();
$this->displayName = $person->getFirstName();
$this->reset();
$this->setCookies();
} else {
$this->errorStr = 'FAILED: Unable to create user.<div style="margin-left:55px;">Please contact system administrator for assistance.</div>';
}
}
$editCon->close();
return $status;
}
private function createPeople()
{
for ($i = 0; $i < 50; $i++) {
$person = new Person();
$person->setFirstname('John');
$person->setLastname('Wayne');
$person->setZip(4330);
$person->setAddress('Somewhere');
$person->commit();
}
}
$city = array_key_exists("city", $_REQUEST) ? $_REQUEST["city"] : "";
$state = array_key_exists("state", $_REQUEST) ? $_REQUEST["state"] : "";
$zip = array_key_exists("zip", $_REQUEST) ? $_REQUEST["zip"] : "";
$country = array_key_exists("country", $_REQUEST) ? $_REQUEST["country"] : "";
$url = array_key_exists("url", $_REQUEST) ? $_REQUEST["url"] : "";
$biography = array_key_exists("biography", $_REQUEST) ? $_REQUEST["biography"] : "";
$isPublic = array_key_exists("ispublic", $_REQUEST) ? $_REQUEST["ispublic"] : "";
$newPerson = new Person();
$newPerson->setUid($userId);
$newPerson->setFirstName($firstname);
$newPerson->setLastName($lastname);
$newPerson->setTitle($title);
$newPerson->setInstitution($institution);
$newPerson->setCity($city);
$newPerson->setState($state);
$newPerson->setZip($zip);
$newPerson->setCountry($country);
$newPerson->setEmail($email);
$newPerson->setUrl($url);
$newPerson->setBiography($biography);
$newPerson->setIsPublic($isPublic);
if (!$pHandler->updateProfile($newPerson)) {
$statusStr = "Profile update failed!";
}
$person = $pHandler->getPerson();
if ($person->getIsTaxonomyEditor()) {
$tabIndex = 3;
} else {
$tabIndex = 2;
}
} elseif ($action == "Change Password") {
$url->address = $row['address'];
$parsed = new SimpleXMLElement($url, null, true);
if ($parsed->street_number && $parsed->street_name) {
// Look up their address in Master Address
$url = new URL(ADDRESS_SERVICE . '/home.php');
$url->queryType = 'address';
$url->format = 'xml';
$url->query = $row['address'];
echo $url->query . " ==> ";
$xml = new SimpleXMLElement($url, null, true);
if (count($xml) == 1) {
// Set the address
$person->setAddress($xml->address->streetAddress);
$person->setCity($xml->address->city);
$person->setState($xml->address->state);
$person->setZip($xml->address->zip);
// $person->setStreet_address_id($xml->address->id);
// See if there's a subunit
if ($parsed->subunitIdentifier) {
$subunit = $xml->xpath("//subunit[identifier='{$parsed->subunitIdentifier}']");
if ($subunit) {
// $person->setSubunit_id($subunit[0]['id']);
$person->setAddress("{$person->getAddress()} {$subunit[0]->type} {$subunit[0]->identifier}");
}
}
echo "{$person->getAddress()} ==>";
}
}
if (!$person->getAddress()) {
$person->setAddress(ucwords(strtolower($row['address'])));
$person->setCity(ucwords(strtolower($row['city'])));
/**
* @test
*/
public function shouldCreateRecordsInAcceptableTime_MYSQLI()
{
LudoDB::setConnectionType('MYSQLI');
$this->startTimer();
for ($i = 0; $i < 500; $i++) {
$person = new Person();
$person->setFirstname('John');
$person->setLastname('Wayne');
$person->setAddress('Somewhere');
$person->setZip(4330);
$person->commit();
}
$time = $this->getElapsed(__FUNCTION__);
// then
$this->assertLessThan(1.5, $time);
}
private function getPersonWithPhone($firstname = '', $phoneNumbers = array())
{
$person = new Person();
$person->setFirstname($firstname);
$this->createCity();
$person->setZip(4330);
$person->commit();
$id = $person->getId();
foreach ($phoneNumbers as $number) {
$this->addPhone($id, $number);
}
return new Person($id);
}
/**
* @test
*/
public function shouldGetValueFromJoinsOnNewObjects()
{
$person = new Person();
$person->setZip('7001');
$city = new City();
$city->setZip('7001');
$city->setCity('Somewhere');
$city->commit();
// then
$this->assertEquals('Somewhere', $person->getCity());
}
