public function edit($pr_id = null)
{
if ($pr_id) {
$data['info'] = ProfessionRelatedModel::professionRelatedInfo($pr_id);
} else {
$data['knowledge_list'] = KnowledgeModel::get_knowledge_children_list(self::$pr_subjectid);
$data['pr_knowledgeids'] = ProfessionRelatedModel::professionRelatedKnowledgeid(self::$pr_subjectid);
}
$data['profession'] = ProfessionModel::professionList(null, null, 1000);
$this->load->view('vocational_aptitude/edit', $data);
}
public function edit_subject_dimension($subd_subjectid = 0)
{
$data = array();
if ($subd_subjectid) {
$data['info'] = SubjectModel::subjectDimensionInfo($subd_subjectid);
}
$data['subject_list'] = C('subject');
$data['profession'] = ProfessionModel::professionList(null, null, 1000);
$this->load->view('subject/edit_subject_dimension', $data);
}
public function save_import()
{
set_time_limit(0);
if (!$_FILES['profession_file']) {
$message[] = '请选择导入的Excel文件';
}
/**
* 上传文件
*/
$upload_path = '../../cache/excel/';
$file_name = microtime(true) . '.' . end(explode('.', $_FILES['profession_file']['name']));
$upload_file = $upload_path . $file_name;
if (!is_dir($upload_path)) {
mkdir($upload_path, '0777', true);
}
if (!@move_uploaded_file($_FILES['profession_file']['tmp_name'], $upload_file)) {
message('导入文件失败，请重新导入！');
}
//导入结果信息统计
$stat = array('total' => 0, 'success' => 0, 'fail' => 0);
/**
* 读取excel
*/
$this->load->library('PHPExcel');
$this->load->library('PHPExcel/IOFactory');
$inputFileType = IOFactory::identify($upload_file);
$objReader = IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($upload_file);
$sheetcount = $objPHPExcel->getSheetCount();
for ($i = 0; $i < $sheetcount; $i++) {
$list = array_filter($objPHPExcel->getSheet($i)->toArray());
if (empty($list)) {
continue;
}
foreach ($list as $k => $v) {
if (!$k) {
continue;
}
$stat['total']++;
$data = array();
try {
if (!Validate::isNotEmpty($v[0])) {
$stat['fail']++;
continue;
}
$data['profession_name'] = htmlspecialchars(trim($v[0]));
$data['profession_emerging'] = 0;
if (trim($v[1]) == '是') {
$data['profession_emerging'] = 1;
}
$data['profession_explain'] = htmlspecialchars(trim($v[2]));
if (ProfessionModel::addProfession($data)) {
$stat['success']++;
} else {
$stat['fail']++;
}
} catch (Exception $e) {
$stat['fail']++;
}
}
}
@unlink($upload_file);
message("本次导入共有{$stat['total']}个职业，成功导入{$stat['success']}个，失败{$stat['fail']}个。", '/admin/profession/index');
}
