/**
* @description 批量删除产品分类
* @author
* @final
* @param array $ids 产品分类id
*/
public function batch_delete()
{
if (!$this->check_power_new('production_category_batch_delete')) {
return;
}
$ids = $this->input->post('ids');
if (empty($ids) or !is_array($ids)) {
message('请选择要删除的项目！');
return;
}
// 检查被关联试题
$success = $fail = 0;
foreach ($ids as $id) {
$pc_id = intval($id);
$bool = true;
$pc_ids = CommonModel::get_product_category($pc_id);
if (empty($pc_ids)) {
$bool = false;
}
$query = array();
$data = array();
$query['pc_id'] = $pc_id;
$res = CommonModel::get_list($query, 'v_trans_log', 'count(pt_id) as pt_id_count');
$pt_id_count = $res[0]['pt_id_count'];
if ($pt_id_count > 0) {
$bool = false;
}
if (!$bool) {
$fail++;
continue;
}
$num = Fn::db()->delete('rd_product_category', "pc_id={$pc_id}");
admin_log('delete', 'product_category', $pc_id);
if ($num > 0) {
$success += $num;
} else {
$fail++;
}
}
message('批量操作完成，成功删除：' . $success . ' 个，失败：' . $fail . ' 个。', 'javascript');
}
/**
* @description 批量删除产品信息
* @author
* @final
* @param array $ids 产品id
*/
public function batch_delete()
{
if (!$this->check_power_new('production_batch_delete')) {
return;
}
$ids = $this->input->post('ids');
if (empty($ids) or !is_array($ids)) {
message('请选择要删除的项目！');
return;
}
// 检查被关联试题
$success = $fail = 0;
foreach ($ids as $id) {
$p_id = intval($id);
$p_ids = CommonModel::get_product_list($p_id);
$bool = true;
if (empty($p_ids)) {
$bool = false;
}
$admin = $this->session->userdata('admin_id');
/*
$managers = explode(',',$p_ids['p_managers']);
if(!in_array($admin, $managers)&&!$this->check_power_new('production_del'))
{
$bool = false;
}
*/
$query = array();
$query['p_id'] = $p_id;
$res = CommonModel::get_list($query, 'v_trans_log_count', 'pt_id_count');
$pt_id_count = $res[0]['pt_id_count'];
if ($pt_id_count > 0) {
$bool = false;
}
if (!$bool) {
$fail++;
continue;
}
$num = Fn::db()->delete('rd_product', "p_id={$p_id}");
admin_log('delete', 'product', $p_id);
if ($num > 0) {
$success += $num;
} else {
$fail++;
}
}
$back_url = 'admin/prodution/index/';
message('批量操作完成，成功删除：' . $success . ' 个，失败：' . $fail . ' 个。', 'javascript');
}
/**
* 学生报名信息核对
*/
public function info_check()
{
if ($this->input->post('grade_id')) {
$this->load->library('PHPExcel');
$this->load->library('PHPExcel/IOFactory');
$grade_id = intval($this->input->post('grade_id'));
$school_id = intval($this->input->post('school_id'));
if (!$grade_id) {
message('请选择年级');
}
if (!$school_id) {
message('请选择学校');
}
$file = $_FILES['infos']['name'];
$desc = '../../cache/excel/' . $file;
$tmp_name = $_FILES['infos']['tmp_name'];
$extend = strrchr($file, '.');
if (!in_array($extend, array('.xlsx', '.xls'))) {
message('文件类型不合法');
}
if (!move_uploaded_file($tmp_name, $desc)) {
message('文件移动失败，请联系管理员');
}
$reader = new PHPExcel_Reader_Excel2007();
$reader_type = $extend == '.xlsx' ? 'Excel2007' : 'Excel5';
$obj = new IOFactory();
$objreader = $obj::createReader($reader_type)->load($desc);
$sheet = $objreader->getSheet(0);
$allRow = $sheet->getHighestRow();
$file2 = $file . '信息核对反馈表';
$objexcel = new PHPExcel();
$objexcel->setActiveSheetIndex(0)->setCellValue('A1', '姓名');
$objexcel->setActiveSheetIndex(0)->setCellValue('B1', '学号');
$objexcel->setActiveSheetIndex(0)->setCellValue('C1', '年级');
$objexcel->setActiveSheetIndex(0)->setCellValue('D1', '准考证号');
$objexcel->setActiveSheetIndex(0)->setCellValue('E1', '报名');
$objexcel->getActiveSheet()->setTitle($file2);
$objwriter = IOFactory::createWriter($objexcel, $reader_type);
for ($i = 2; $i <= $allRow; $i++) {
$arr = array();
$student_name = $objreader->getActiveSheet()->getCell('A' . $i)->getValue();
$student_number = $objreader->getActiveSheet()->getCell('B' . $i)->getValue();
$student_grade = $objreader->getActiveSheet()->getCell('C' . $i)->getValue();
$space = " ";
$student_name = str_ireplace($space, "", $student_name);
$count = 0;
$objexcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $student_name);
$objexcel->setActiveSheetIndex(0)->setCellValue('B' . $i, $student_number);
$objexcel->setActiveSheetIndex(0)->setCellValue('C' . $i, $student_grade);
$student_search = array('school_id' => $school_id, 'grade_id' => $grade_id, 'keyword' => "CONCAT(last_name,first_name) LIKE '%" . trim($student_name) . "%'");
$student_list = CommonModel::get_list($student_search, 'rd_student', '*');
$number = count($student_list);
if ($number) {
if ($number > 1) {
//2代表错误，一个学校一个年纪有多个重名学生情况
$objexcel->setActiveSheetIndex(0)->setCellValue('D' . $i, '报名出错了(重名情况)');
$objexcel->setActiveSheetIndex(0)->setCellValue('E' . $i, 2);
} else {
$student_info = array_shift($student_list);
$idcard = $student_info['idcard'];
$objexcel->setActiveSheetIndex(0)->setCellValue('D' . $i, $student_info['exam_ticket']);
$objexcel->setActiveSheetIndex(0)->setCellValue('E' . $i, 1);
}
} else {
$objexcel->setActiveSheetIndex(0)->setCellValue('D' . $i, '未报名');
$objexcel->setActiveSheetIndex(0)->setCellValue('E' . $i, 0);
}
}
$objwriter->save($desc);
$data = array('url' => $desc, 'act' => 'update', 'name' => $file);
} else {
$grades = C('grades');
$data = array('act' => 'add', 'grades' => $grades);
}
$this->load->view('/student/info_check', $data);
}
/**
* @按产品查询交易数据信息
* @param int $p_id 产品id
*/
public function transactionp($p_id)
{
if (!$this->check_power('statistics_manage')) {
return;
}
$p_id = intval($p_id);
$student = CommonModel::get_product_list($p_id);
if (empty($student)) {
message('信息不存在');
return;
}
$admin = $this->session->userdata('admin_id');
$managers = explode(',', $student['p_managers']);
if (!in_array($admin, $managers) && !$this->is_super_user()) {
message('没有管理权限');
return;
}
/*
* 基本信息
*/
$p_id = intval($p_id);
$student = CommonModel::get_product_list($p_id);
if (empty($student)) {
message('信息不存在');
return;
}
$data = array();
$data['p_id'] = $p_id;
$data['p_name'] = $student[p_name];
$query = array();
$query['p_id'] = $p_id;
$query['pt_type'] = 0;
/* 搜索条件 */
if (isset($_GET['begin_time']) && !empty($_GET['begin_time'])) {
$query['pt_u_time >='] = strtotime($_GET['begin_time'] . '00:00:59');
$search['begin_time'] = $_GET['begin_time'];
}
if (isset($_GET['end_time']) && !empty($_GET['end_time'])) {
$query['pt_u_time <='] = strtotime($_GET['end_time'] . '23:59:59');
$search['end_time'] = $_GET['end_time'];
}
// 公共数据
$res = CommonModel::get_list($query, 'v_trans_log', 'count(pt_id) as pt_id_count,sum(pt_money)*(-1) as pt_money_count');
$data['p_id_count'] = $res[0]['pt_id_count'];
$data['p_money_count'] = !empty($res[0]['pt_money_count']) ? $res[0]['pt_money_count'] : 0;
$total = $res[0]['pt_id_count'];
/*
* 分页读取数据列表，并处理相关数据
*/
$size = 10;
$page = isset($_GET['page']) && intval($_GET['page']) > 1 ? intval($_GET['page']) : 1;
$offset = ($page - 1) * $size;
$list = array();
if ($total) {
$res = CommonModel::get_list($query, 'v_trans_log', 'pt_id,p_name,pc_name,end_time,start_time,a_name,pt_money', $page, $size);
foreach ($res as $row) {
$row['start_time'] = $row['start_time'] > 0 ? date('Y-m-d H:i:s', $row['start_time']) : date('Y-m-d H:i:s', time());
$row['end_time'] = $row['end_time'] > 0 ? date('Y-m-d H:i:s', $row['end_time']) : date('Y-m-d H:i:s', time());
$row['p_name'] = !empty($row['p_name']) ? $row['p_name'] : '充值';
$row['pt_money'] = !empty($row['pt_money']) ? $row['pt_money'] * -1 : '0';
$row['pc_name'] = !empty($row['pc_name']) ? $row['pc_name'] : '充值';
$list[] = $row;
}
}
$data['list'] = $list;
// 分页
$purl = site_url('admin/account/transactionp/' . $p_id);
$data['pagination'] = multipage($total, $size, $page, $purl);
$data['search'] = $search;
// 模版
$this->load->view('account/transactionp', $data);
}
