|
<?php |
|
|
|
namespace Kanboard\Import; |
|
|
|
use Kanboard\Model\UserModel; |
|
use SimpleValidator\Validator; |
|
use SimpleValidator\Validators; |
|
use Kanboard\Core\Security\Role; |
|
use Kanboard\Core\Base; |
|
use Kanboard\Core\Csv; |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
class UserImport extends Base |
|
{ |
|
|
|
|
|
|
|
|
|
|
|
|
|
public $counter = 0; |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
public function getColumnMapping() |
|
{ |
|
return array( |
|
'username' => 'Username', |
|
'password' => 'Password', |
|
'email' => 'Email', |
|
'name' => 'Full Name', |
|
'is_admin' => 'Administrator', |
|
'is_manager' => 'Manager', |
|
'is_ldap_user' => 'Remote User', |
|
); |
|
} |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
public function import(array $row, $line_number) |
|
{ |
|
$row = $this->prepare($row); |
|
|
|
if ($this->validateCreation($row)) { |
|
if ($this->userModel->create($row) !== false) { |
|
$this->logger->debug('UserImport: imported successfully line '.$line_number); |
|
$this->counter++; |
|
} else { |
|
$this->logger->error('UserImport: creation error at line '.$line_number); |
|
} |
|
} else { |
|
$this->logger->error('UserImport: validation error at line '.$line_number); |
|
} |
|
} |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
public function prepare(array $row) |
|
{ |
|
$row['username'] = strtolower($row['username']); |
|
|
|
foreach (array('is_admin', 'is_manager', 'is_ldap_user') as $field) { |
|
$row[$field] = Csv::getBooleanValue($row[$field]); |
|
} |
|
|
|
if ($row['is_admin'] == 1) { |
|
$row['role'] = Role::APP_ADMIN; |
|
} elseif ($row['is_manager'] == 1) { |
|
$row['role'] = Role::APP_MANAGER; |
|
} else { |
|
$row['role'] = Role::APP_USER; |
|
} |
|
|
|
unset($row['is_admin']); |
|
unset($row['is_manager']); |
|
|
|
$this->helper->model->removeEmptyFields($row, array('password', 'email', 'name')); |
|
|
|
return $row; |
|
} |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
public function validateCreation(array $values) |
|
{ |
|
$v = new Validator($values, array( |
|
new Validators\MaxLength('username', t('The maximum length is %d characters', 255), 255), |
|
new Validators\Unique('username', t('The username must be unique'), $this->db->getConnection(), UserModel::TABLE, 'id'), |
|
new Validators\MinLength('password', t('The minimum length is %d characters', 6), 6), |
|
new Validators\Email('email', t('Email address invalid')), |
|
new Validators\Integer('is_ldap_user', t('This value must be an integer')), |
|
)); |
|
|
|
return $v->execute(); |
|
} |
|
} |
|
|