protected function _postDelete()
{
$tblUserDetail = new Kutu_Core_Orm_Table_UserDetail();
$rowsetUserDetail = $tblUserDetail->fetchAll("uid='{$this->guid}'");
foreach ($rowsetUserDetail as $row) {
// delete
$row->delete();
}
//delete from table KutuUserInvoice
$tblInvoice = new Kutu_Core_Orm_Table_Invoice();
$tblInvoice->delete("uid='{$this->guid}'");
//delete from table KutuUserAccessLog
$tblUserLog = new Kutu_Core_Orm_Table_UserLog();
$tblUserLog->delete("user_id='{$this->guid}'");
//delete from ACL
$aclMan = Kutu_Acl::manager();
$aclMan->deleteUser($this->username);
// delete physical user folder define by guid
$sDir = KUTU_ROOT_DIR . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR . 'images' . DIRECTORY_SEPARATOR . $this->guid;
try {
$this->removeRessource($sDir);
} catch (Exception $e) {
throw new Exception($e);
}
}
public function isAllowedToView($itemGuid)
{
$auth = Zend_Auth::getInstance();
$aclMan = Kutu_Acl::manager();
if (!$auth->hasIdentity()) {
return $aclMan->getPermissionsOnContent('', 'everyone', $itemGuid);
} else {
$aReturn = $aclMan->getUserGroupIds($auth->getIdentity()->username);
return $aclMan->getPermissionsOnContent('', $aReturn[1], $itemGuid);
}
}
function preDispatch()
{
$this->_helper->layout()->setLayout('layout-fb2');
Zend_Session::start();
$sReturn = "http://" . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
$sReturn = urlencode($sReturn);
$this->view->returnTo = $sReturn;
$auth = Zend_Auth::getInstance();
if (!$auth->hasIdentity()) {
$this->_redirect(KUTU_ROOT_URL . '/helper/sso/login' . '?returnTo=' . $sReturn);
} else {
// [TODO] else: check if user has access to admin page
$username = $auth->getIdentity()->username;
$this->view->username = $username;
$acl = Kutu_Acl::manager();
if (!$acl->checkAcl("site", 'all', 'user', $username, false, false) && !$acl->checkAcl("site", 'admin', 'user', $username, false, false)) {
$this->_helper->redirector('restricted', "error", 'admin');
}
}
}
private function _checkAccess($itemGuid)
{
$bpm = new Kutu_Core_Bpm_Catalog();
$acl = Kutu_Acl::manager();
if ($acl->checkAcl("site", 'all', 'user', $this->_auth->getIdentity()->username, false, false)) {
return true;
}
if ($bpm->getPrice($itemGuid) <= 0) {
// can be downloaded
return true;
} else {
//check if the logged in user has once bought the parent Catalog
return $bpm->isBoughtByUser($itemGuid, $this->_auth->getIdentity()->guid);
}
}
private function _isStoreClosed()
{
$auth = Zend_Auth::getInstance();
if (!$auth->hasIdentity()) {
} else {
$username = $auth->getIdentity()->username;
$acl = Kutu_Acl::manager();
if ($acl->checkAcl("site", 'all', 'user', $username, false, false)) {
return 0;
}
}
return $this->_configStore['isClosed'];
}
protected function _postInsert()
{
$acl = Kutu_Acl::manager();
$acl->addUser($this->username);
}
public function assigngroupAction()
{
$r = $this->getRequest();
$guid = $r->getParam('guid');
$tblUser = new Kutu_Core_Orm_Table_User();
$row = $tblUser->find($guid)->current();
$acl = Kutu_Acl::manager();
$aGroup = $acl->getGroups();
$this->view->availableGroups = $aGroup;
$aCurrentGroup = $acl->getUserGroupIds($row->username);
$this->view->currentGroups = $aCurrentGroup;
$this->view->rowUser = $row;
$this->view->message = '';
if ($r->isPost()) {
$assignedGroups = $r->getParam('assignedGroups');
//print_r($currentGroups);
foreach ($aCurrentGroup as $currGroup) {
$acl->removeUserFromGroup($row->username, $currGroup);
}
foreach ($assignedGroups as $group) {
//echo $group;
$acl->addUserToGroup($row->username, $group);
}
$aGroup = $acl->getGroups();
$this->view->availableGroups = $aGroup;
$aCurrentGroup = $acl->getUserGroupIds($row->username);
$this->view->currentGroups = $aCurrentGroup;
$this->view->message = "Data was Saved";
}
}
public function delete($userId)
{
//[TODO] WE MUST DEFINE RELATIONSHIP AND CASCADE DELETE ON EVERY TABLES
$tblUser = new Kutu_Core_Orm_Table_User();
$rowUser = $tblUser->find($userId)->current();
$username = $rowUser->username;
print_r($username);
//delete from KutuOrder
//$tblOrder = new Kutu_Core_Orm_Table_Order();
//$tblOrder->delete("userId='$userId'");
//delete from PHPGACL (use PHPGACL function to delete user)
$acl = Kutu_Acl::manager();
$acl->deleteUser($username);
//delete from KutuUserFinance
$tblUserFinance = new Kutu_Core_Orm_Table_UserFinance();
$rowsetUserFinance = $tblUserFinance->find($userId);
if (count($rowsetUserFinance)) {
$rowUserFinance = $rowsetUserFinance->current();
$rowUserFinance->delete();
}
//delete from KutuUser
$rowUser->delete();
//delete from all table that Chenri made (Store related tables)
}
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();
$acl->addUserToGroup($rowUser->username, "member_free");
} else {
}
}
}
die;
}
