/**
* Delete entries
*
* @param array|string $where SQL WHERE clause(s)
* @return int|string
*/
public function delete($id)
{
$table = $this->getTable();
// Get the parent_role from the role will delete
$role = $this->fetchEntry($id);
//Zend_Debug::dump($role["role_parent"], "rol que eliminamos");
//find the roles have the parent role of the role will delete
$rolsongs = $this->fetchParentRoles($id);
// Zend_Debug::dump($rolsongs["0"]["id"], "el hijo del rol que eliminaremos");
//chance the parent_role of the songs
foreach ($rolsongs as $value) {
$data["role_parent"] = (int) $role["role_parent"];
$data["id"] = $value["id"];
$this->update($data, 'id =' . (int) $value["id"]);
}
//find the users with the role will delete
$users = new User_Model_Users();
$users->getTable();
$arrayusers = $users->fetchUsers($id);
//Zend_Debug::dump($arrayusers,"users with role will delete");
// chance the role to the users
foreach ($arrayusers as $value) {
$data["role_id"] = (int) $rolsongs["0"]["id"];
$data["id"] = $value["id"];
Zend_Debug::dump($data, "data1");
$users->update($data, 'id =' . (int) $value["id"]);
}
$table->delete('id =' . (int) $id);
}
/**
* AddAction for Userscompaniess
*
* @return void
*/
public function addAction()
{
$this->view->headTitle("Add New User", 'APPEND');
$request = $this->getRequest();
$form = new Company_Form_Userscompanies();
if ($this->getRequest()->isPost()) {
if ($form->isValid($request->getPost())) {
//comprobar que el usuario existe
$data = $form->getValues();
$model_user = new User_Model_Users();
if ($data_userscompanies["acl_users_id"] = $model_user->fetchUserByEmail($data['email'])) {
$data_userscompanies["companies_id"] = $_SESSION["company"]["id"];
$model = new Company_Model_Userscompanies();
//comprobar si ya existe en esa produccion
// Zend_Debug::dump($data_userscompanies);
// die();
$model->save($data_userscompanies);
} else {
//TODO enviar email
}
// Zend_Debug::dump($data_userscompanies);
// die();
return $this->_helper->redirector('index');
}
} else {
$form->populate($form->getValues());
}
$this->view->form = $form;
}
public function loginAction()
{
//echo 'suresh';exit;
$postarray = $this->getRequest()->getParams();
if (isset($postarray['email']) && isset($postarray['pwd']) && $postarray['email'] != '' && $postarray['pwd'] != '') {
$usermodel = new User_Model_Users();
$userDet = $usermodel->userDetails($postarray['email'], md5($postarray['pwd']));
if (count($userDet) > 0) {
if ($userDet[0]['user_role_id'] != 2) {
$userDetJson = array('status' => '0', 'message' => 'Not a privileged user.', 'result' => '');
} else {
if ($userDet[0]['is_blocked'] == 1) {
$userDetJson = array('status' => '0', 'message' => 'User has been blocked.', 'result' => '');
} else {
if ($userDet[0]['is_active'] == 0) {
$userDetJson = array('status' => '0', 'message' => 'Not an active user.', 'result' => '');
} else {
unset($userDet[0]['user_role_id']);
unset($userDet[0]['is_blocked']);
unset($userDet[0]['is_active']);
$userDetJson = array('status' => '1', 'message' => 'Successfully logged in.', 'result' => $userDet);
}
}
}
} else {
$userDetJson = array('status' => '0', 'message' => 'No user exist with the credentials.', 'result' => '');
}
} else {
$userDetJson = array('status' => '0', 'message' => 'Email and Password should not be empty.', 'result' => '');
}
//$testString = array(''=>'','result'=>'Created an action for restful web service.');
//echo $testString;exit;
$this->_helper->json($userDetJson);
}
public function firstFormAction()
{
$this->view->headTitle('טופס רישום');
$userFirstForm = new User_Form_UserFirstForm();
if ($this->getRequest()->getParam('submit')) {
if (!$userFirstForm->isValid($_POST)) {
$this->view->form = $userFirstForm;
} else {
// success
$values = $userFirstForm->getValues();
$user = new User_Model_Users();
$user->addUser($values);
$email = $values['email'];
$pwd = $values['password1'];
$this->_redirect("/user/email-functions/create-validation-code/email/{$email}/pwd/{$pwd}/");
}
} else {
$this->view->form = $userFirstForm;
}
}
public function settings($postarray)
{
if (isset($postarray['userid']) && $postarray['userid'] != '') {
if (isset($postarray['password']) && $postarray['password'] != '' || isset($_FILES['profile_photo']['name']) && $_FILES['profile_photo']['name'] != '') {
$uploadresult = array();
$data = array();
if (isset($_FILES['profile_photo']['name']) && $_FILES['profile_photo']['name'] != '') {
$uploadresult = sapp_Global::imageUploadAfterResize();
}
if (isset($postarray['password']) && $postarray['password'] != '') {
$password = md5($postarray['password']);
$data['user_password'] = $password;
}
if (isset($uploadresult['img']) && $uploadresult['img'] != '') {
$data['profile_photo'] = $uploadresult['img'];
}
$where = 'id = "' . $postarray['userid'] . '"';
$usersModel = new User_Model_Users();
$changepwd = $usersModel->edituserPassword($data, $where);
$userDetJson = array('status' => '1', 'message' => 'Success', 'result' => 'Updated successfully.');
} else {
$userDetJson = array('status' => '0', 'message' => 'Either Password or Profile Photo should change.', 'result' => '');
}
} else {
$userDetJson = array('status' => '0', 'message' => 'User Id should not be empty.', 'result' => '');
}
return $userDetJson;
}
/**
* deleteAction for Users
*
* @return void
*/
public function deleteAction()
{
if ($this->getRequest()->isPost()) {
$del = $this->getRequest()->getPost('del');
if ($del == 'Yes') {
$id = $this->getRequest()->getPost('id');
$model = new User_Model_Users();
$model->delete('id = ' . (int) $id);
}
return $this->_helper->redirector('index');
} else {
$id = $this->_getParam('id', 0);
if ($id > 0) {
$model = new User_Model_Users();
$this->view->user = $model->fetchEntry($id);
}
}
}
/**
* Fetch all sql entries for the $role_id
*
* @return array
*/
public function fetchUsersActivity($array_id_users)
{
$model = new User_Model_Users();
foreach ($array_id_users as $key => $value) {
$array_user[$key] = $model->fetchEntry($array_id_users[$key]);
}
return $array_user;
}
