/**
* There has been a file selected; check that file for headers and what not to display something useful to the user.
*/
private function _import2(){
$view = $this->getView();
$request = $this->getPageRequest();
$filename = \Core\Session::Get('user-import/file');
$file = \Core\Filestore\Factory::File($filename);
$contents = $file->getContentsObject();
if(!$contents instanceof \Core\Filestore\Contents\ContentCSV){
\Core\set_message($file->getBaseFilename() . ' does not appear to be a valid CSV file!', 'error');
\Core\Session::UnsetKey('user-import/file');
\Core\reload();
}
$hasheader = $contents->hasHeader();
$data = $contents->parse();
$total = sizeof($data);
// Since I don't want to display the entire dataset in the preview...
if($hasheader){
$header = $contents->getHeader();
}
else{
$header = array();
$i=0;
foreach($data[0] as $k => $v){
$header[$i] = 'Column ' . ($i+1);
$i++;
}
}
$colcount = sizeof($header);
if($total > 11){
$preview = array_splice($data, 0, 10);
}
else{
$preview = $data;
}
$form = new Form();
$form->set('callsmethod', 'User\\ImportHelper::FormHandler2');
$form->addElement('system', ['name' => 'key', 'value' => \Core\Session::Get('user-import/key')]);
$form->addElement(
'checkbox',
[
'name' => 'has_header',
'title' => 'Has Header',
'value' => 1,
'checked' => $hasheader,
'description' => 'If this CSV has a header record on line 1, (as illustrated below), check this to ignore that line.'
]
);
$form->addElement(
'checkbox',
[
'name' => 'merge_duplicates',
'title' => 'Merge Duplicate Records',
'value' => 1,
'checked' => true,
'description' => 'Merge duplicate records that may be found in the import.'
]
);
// Only display the user groups if the current user has access to manage user groups.
$usergroups = UserGroupModel::Find(['context = ']);
if(sizeof($usergroups) && \Core\user()->checkAccess('p:/user/groups/manage')){
$usergroupopts = array();
foreach($usergroups as $ug){
$usergroupopts[$ug->get('id')] = $ug->get('name');
}
$form->addElement(
'checkboxes',
[
'name' => 'groups[]',
'title' => 'User Groups to Assign',
'options' => $usergroupopts,
'description' => 'Check which groups to set the imported users to. If merge duplicate records is selected, any found users will be set to the checked groups, (and consequently unset from any unchecked groups).',
]
);
}
else{
$form->addElement('hidden', ['name' => 'groups[]', 'value' => '']);
}
// Get the map-to options.
$maptos = ['' => '-- Do Not Map --', 'email' => 'Email', 'password' => 'Password'];
$configs = UserConfigModel::Find([], null, 'weight asc, name desc');
foreach($configs as $c){
$maptos[ $c->get('key') ] = $c->get('name');
}
$maptoselects = [];
foreach($header as $key => $title){
$value = '';
if(isset($maptos[$key])) $value = $key;
if(array_search($title, $maptos)) $value = array_search($title, $maptos);
$form->addElement(
'select',
[
'name' => 'mapto[' . $key . ']',
'title' => $title,
'options' => $maptos,
'value' => $value
]
);
}
$view->templatename = 'pages/user/import2.tpl';
$view->assign('has_header', $hasheader);
$view->assign('header', $header);
$view->assign('preview', $preview);
$view->assign('form', $form);
$view->assign('total', $total);
$view->assign('col_count', $colcount);
}
