private function _migrateAllUsers()
{
$sqlSource = "SELECT * from tblPersonalization_User";
$this->_dbSource->setFetchMode(Zend_Db::FETCH_OBJ);
$results = $this->_dbSource->fetchAll($sqlSource);
// do mapping
if (count($results)) {
foreach ($results as $row) {
$tblUser = new Kutu_Core_Orm_Table_User();
$rowsetUser = $tblUser->find($this->_guidPrefix . $row->UserID);
if (count($rowsetUser) < 1) {
// do something
$rowUser = $tblUser->fetchNew();
$rowUser->guid = $this->_guidPrefix . $row->UserID;
$rowUser->username = $row->UserName;
$rowUser->password = is_null($row->Password) ? 'V3FXfFJzBnpVYg==' : $row->Password;
$rowUser->firstname = $row->FullName;
$rowUser->lastname = '';
$rowUser->email = $row->Email;
$rowUser->company = $row->CompanyName;
$rowUser->mainAddress = $row->Address;
$rowUser->zip = $row->ZIP;
$rowUser->phone = $row->Phone;
$rowUser->industryId = $row->CompBusLine;
$rowUser->isActive = is_null($row->isActive) ? 0 : $row->isActive;
$rowUser->createdDate = $row->DateCreate;
$rowUser->registrationDate = $rowUser->createdDate;
$sqlMembership = "SELECT * from tblMembership_Exp where User_ID={$row->UserID}";
$this->_dbSource->setFetchMode(Zend_Db::FETCH_OBJ);
$resultsMembership = $this->_dbSource->fetchAll($sqlMembership);
//print_r($resultsMembership);
//die();
if (count($resultsMembership)) {
$rowMembership = $resultsMembership[0];
$rowUser->fax = $rowMembership->Fax;
$rowUser->activationDate = $rowMembership->Activation_Date;
$rowUser->expirationDate = $rowMembership->Expiration_Date;
}
//if($row->UserID==157)
if (true) {
$rowUser->save();
//die();
}
//Must also assign assign user as group:member_free
$acl = Kutu_Acl_Manager::getAdapter();
$acl->addUserToGroup($rowUser->username, "member_free");
} else {
}
}
}
die;
}
