<?php
namespace app\student\controller;
use app\base\controller\AdminBase;use app\student\model\Student as STU;use app\tools\controller\File;
class Index extends AdminBase
{
public function index()
{
$list['webtitle'] = '学生列表';
$list['dataurl'] = '/student/index/data';
$list['status'] = '/student/index/status';
$list['kaoshi'] = '/student/index/kaoshi';
$this->view->assign('list', $list);
return $this->view->fetch();
}
public function ajaxData()
{
$src = $this->request
->only([
'page' => '1'
,'limit' => '10'
,'field' => 'update_time'
,'order' => 'desc'
,'school_id' => array()
,'ruxuenian' => array()
,'banji_id' => array()
,'searchval' => ''
], 'POST');
if(count($src['banji_id']) == 0) # 如果没有获取到班级id,则查询班级id
{
$banji = new \app\teach\model\Banji;
$bjsrc = [
'school_id' => $src['school_id']
,'ruxuenian' => $src['ruxuenian']
,'status' => 1
];
$src['banji_id'] = $banji->search($bjsrc)->column('id');
}
$stu = new STU;
$data = $stu->search($src);
$data = reSetObject($data, $src);
return json($data);
}
public function byList()
{
$list['webtitle'] = '毕业学生';
$list['dataurl'] = '/student/index/databy';
$this->view->assign('list', $list);
return $this->view->fetch();
}
public function ajaxDataBy()
{
$src = $this->request
->only([
'page' => '1'
,'limit' => '10'
,'field' => 'update_time'
,'order' => 'desc'
,'school_id' => array()
,'ruxuenian' => array()
,'banji_id' => array()
,'searchval' => ''
], 'POST');
if(count($src['banji_id']) == 0) # 如果没有获取到班级id,则查询班级id
{
$banji = new \app\teach\model\Banji;
$bjsrc = [
'school_id' => $src['school_id']
,'ruxuenian' => $src['ruxuenian']
,'status' => 1
];
$src['banji_id'] = $banji->search($bjsrc)->column('id');
}
$stu = new STU;
$data = $stu->search($src);
$data = reSetObject($data, $src);
return json($data);
}
public function delList()
{
$list['webtitle'] = '异动学生';
$list['dataurl'] = '/student/index/datadel';
$this->view->assign('list', $list);
return $this->view->fetch();
}
public function ajaxDataDel()
{
$src = $this->request
->only([
'page' => '1'
,'limit' => '10'
,'field' => 'update_time'
,'order' => 'desc'
,'school_id' => array()
,'ruxuenian' => array()
,'banji_id' => array()
,'searchval' => ''
], 'POST');
if(count($src['banji_id']) == 0) # 如果没有获取到班级id,则查询班级id
{
$banji = new \app\teach\model\Banji;
$bjsrc = [
'school_id' => $src['school_id']
,'ruxuenian' => $src['ruxuenian']
,'status' => 1
];
$src['banji_id'] = $banji->search($bjsrc)->column('id');
}
$stu = new STU;
$data = $stu->searchDel($src);
$data = reSetObject($data, $src);
return json($data);
}
public function create()
{
$list['set'] = array(
'webtitle' => '添加学生'
,'butname' => '添加'
,'formpost' => 'POST'
,'url' => 'save'
);
$this->view->assign('list', $list);
return $this->view->fetch('create');
}
public function save()
{
$list = request()->only([
'xingming'
,'sex'
,'shenfenzhenghao'
,'shengri'
,'ruxuenian'
,'banji_id'
,'kaoshi'
,'quanpin'
,'shoupin'
], 'POST');
$validate = new \app\student\validate\Student;
$result = $validate->scene('create')->check($list);
$msg = $validate->getError();
if(!$result){
return json(['msg' => $msg, 'val' => 0]);;
}
$list['shenfenzhenghao'] = strtoupper($list['shenfenzhenghao']);
$list['quanpin'] = trim(strtolower($list['quanpin']));
$list['shoupin'] = trim(strtolower($list['shoupin']));
$chongfu = STU::withTrashed()
->where('shenfenzhenghao', $list['shenfenzhenghao'])
->find();
$stu = new STU;
if($chongfu == Null)
{
$data = $stu::create($list);
}else{
if($chongfu->delete_time > 0)
{
$chongfu->restore();
}
$data = $stu::update($list, ['id' => $chongfu->id]);
}
$data ? $data = ['msg' => '添加成功', 'val' => 1]
: $data = ['msg' => '数据处理错误', 'val' => 0];
return json($data);
}
public function edit($id)
{
$list['data'] = STU::field('id, xingming, sex, shenfenzhenghao, shengri, banji_id, kaoshi, status, quanpin, shoupin')
->with([
'stuBanji'=>function($query){
$query->field('id, ruxuenian, paixu, school_id')
->append(['banTitle']);
}
])
->find($id);
$list['set'] = array(
'webtitle' => '编辑学生'
,'butname' => '修改'
,'formpost' => 'PUT'
,'url' => '/student/index/update/' . $id
);
$this->view->assign('list', $list);
return $this->view->fetch('create');
}
public function update($id)
{
$list = request()->only([
'xingming'
,'sex'
,'shengri'
,'shenfenzhenghao'
,'ruxuenian'
,'banji_id'
,'kaoshi'
,'quanpin'
,'shoupin'
], 'PUT');
$list['id'] = $id;
$validate = new \app\student\validate\Student;
$result = $validate->scene('edit')->check($list);
$msg = $validate->getError();
if(!$result){
return json(['msg'=>$msg,'val'=>0]);;
}
$list['quanpin'] = trim(strtolower($list['quanpin']));
$list['shoupin'] = trim(strtolower($list['shoupin']));
$stu = new STU();
$stuinfo = $stu::withTrashed()
->where('shenfenzhenghao', $list['shenfenzhenghao'])
->where('id', '<>', $id)
->with([
'stuBanji'
])
->find();
if($stuinfo){
return json([
'msg' => '此身份证号与 ' . $stuinfo->stuSchool->jiancheng . ':' . $stuinfo->xingming . ' 重复。'
,'val' => 0
]);
}
$stu = new STU();
$data = $stu::update($list, ['id' => $id]);
$data ? $data = ['msg' => '更新成功', 'val' => 1]
: $data = ['msg' => '数据处理错误', 'val' => 0];
return json($data);
}
public function read($id)
{
$myInfo = STU::withTrashed()
->where('id', $id)
->with([
'stuBanji' => function($query){
$query->field('id, school_id, ruxuenian, paixu')
->with([
'glSchool' => function($q){
$q->field('id,title,jiancheng');
}
])
->append(['banjiTitle']);
},
])
->find();
$myInfo['webtitle'] = $myInfo->xingming . '-信息';
$this->view->assign('list', $myInfo);
return $this->view->fetch();
}
public function delete($id)
{
$id = request()->delete('id');
$id = explode(',', $id);
$data = STU::destroy($id);
$data ? $data=['msg'=>'删除成功','val'=>1] : $data=['msg'=>'数据处理错误','val'=>0];
return json($data);
}
public function reDel($id)
{
$user = STU::onlyTrashed()->find($id);
$data = $user->restore();
$data ? $data=['msg'=>'恢复成功','val'=>1] : $data=['msg'=>'数据处理错误','val'=>0];
return json($data);
}
public function setStatus()
{
$id = request()->post('id');
$value = request()->post('value');
$data = STU::where('id',$id)->update(['status'=>$value]);
$data ? $data=['msg'=>'状态设置成功','val'=>1] : $data=['msg'=>'数据处理错误','val'=>0];
return json($data);
}
public function setKaoshi()
{
$id = request()->post('id');
$value = request()->post('value');
$data = STU::where('id',$id)->update(['kaoshi'=>$value]);
$data ? $data=['msg'=>'状态设置成功','val'=>1] : $data=['msg'=>'数据处理错误','val'=>0];
return json($data);
}
public function createAll()
{
$list['set'] = array(
'webtitle'=>'同步学生名单',
'butname'=>'同步',
'formpost'=>'POST',
'url'=>'/student/index/saveall',
);
$this->view->assign('list',$list);
return $this->view->fetch('create_all');
}
public function saveAll()
{
$list = request()->only([
'school_id'
,'url'
], 'POST');
$stuinfo = \app\facade\File::readXls(public_path() . 'uploads\\' . $list['url']);
if($stuinfo[0][2] != "序号" && $stuinfo[1][2] != "姓名" && $stuinfo[2][2] != "身份证号")
{
$data = array('msg'=>'请使用模板上传','val'=>0,'url'=>'');
return json($data);
}
$stu = new STU;
$delStuList = $stu->tongBu($stuinfo, $list['school_id']);
$sch = new \app\system\model\School;
$sch = $sch->where('id', $list['school_id'])->value('jiancheng');
set_time_limit(0);
$spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet;
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', $sch . '电子表格中不存在的学生名单');
$sheet->setCellValue('A2', '此表中学生名单是系统中比上传名单中多的数据,是否删除请结合实际情况');
$sheet->setCellValue('A3', '序号');
$sheet->setCellValue('B3', 'ID');
$sheet->setCellValue('C3', '班级');
$sheet->setCellValue('D3', '姓名');
$sheet->setCellValue('E3', '性别');
$i = 4;
foreach ($delStuList as $key => $val) {
$j = $i + $key;
$sheet->setCellValue('A' . $j, $key + 1);
$sheet->setCellValue('B' . $j, $val['id']);
$sheet->setCellValue('C' . $j, $val['banjiTitle']);
$sheet->setCellValue('D' . $j, $val['xingming']);
$sheet->setCellValue('E' . $j, $val['sex']);
}
$filename = $sch . '电子表格中不存在的学生名单' . date('ymdHis') . '.xlsx';
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="' . $filename . '"');
header('Cache-Control: max-age=0');
$writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, 'Xlsx');
$writer->save('php://output');
ob_flush();
flush();
}
public function deletes()
{
$list['set'] = array(
'webtitle'=>'根据表格删除学生信息',
'butname'=>'删除',
'formpost'=>'POST',
'url'=>'/student/index/deleteall',
);
$this->view->assign('list',$list);
return $this->view->fetch();
}
public function deleteXlsx()
{
$list = request()->only([
'url'
], 'POST');
$stuinfo = \app\facade\File::readXls(public_path() . 'uploads\\' . $list['url']);
if($stuinfo[0][2] != "序号" && $stuinfo[1][2] != "ID" && $stuinfo[2][2] != "班级" && $stuinfo[3][2] != "姓名")
{
$data = array('msg'=>'请使用模板上传','val'=>0,'url'=>null);
return json($data);
}
array_splice($stuinfo,0,3); # 去掉标题行
$stuinfo = array_filter($stuinfo,function($q){
return $q[1] != null && $q[2] != null && $q[3] != null; # 去掉有空值行
});
$stuids = array_column($stuinfo, 1); # 获取学生信息
$stu = new STU;
$data = $stu::destroy(function($query) use($stuids){
$query->where('id', 'in', $stuids);
});
$data ? $data = ['msg' => '数据同步成功', 'val' => 1]
: ['msg' => '数据同步失败', 'val' => 0];
return json($data);
}
public function download()
{
$url = public_path() . 'uploads\\student\\student_template.xlsx';
return download($url,'学生名单模板.xlsx');
}
public function srcStudent()
{
$data = array();
$str = input("post.str");
$banji_id = input("post.banji_id");
$kaoshi = input("post.kaoshi");
if(strlen($str) <= 0){
return json($data);
}
$list = STU::field('id, xingming, shengri, sex')
->whereOr('xingming|shoupin', 'like', '%' . $str . '%')
->when(strlen($banji_id) > 0, function ($query) use ($banji_id) {
$query->where('banji_id', $banji_id);
})
->when(strlen($kaoshi) > 0, function ($query) use ($kaoshi) {
$query->where('kaoshi', $kaoshi);
})
->with(
[
'stuBanji' => function ($query) {
$query->field('id, jiancheng')
->with([
'glSchool'=>function($query){
$query->field('id, title, jiancheng');
},
]);
}
]
)
->append(['age'])
->select();
return json($list);
}
public function resetpassword($id)
{
$md5 = new \WhiteHat101\Crypt\APR1_MD5;
$password = $md5->hash('123456');
$data = STU::where('id', $id)->update(['password' => $password]);
$data ? $data = ['msg' => '密码已经重置为:<br>123456', 'val' => 1]
: $data = ['msg' => '数据处理错误', 'val' => 0];
return json($data);
}
}