Example #1
0
function del_paper($id)
{
    global $db;
    if (!is_array($id)) {
        $id = array($id);
    }
    $sqlin = implode(",", $id);
    $return = 0;
    if (preg_match("/^(\\d{1,10},)*(\\d{1,10})\$/", $sqlin)) {
        //循环试卷 更新试卷相应类型的试卷数
        $sql = "SELECT *  FROM " . table('evaluation_paper') . " WHERE id IN ({$sqlin})";
        $paper_info = $db->getall($sql);
        foreach ($paper_info as $key => $value) {
            //更新试卷数  1=>加    2=>减
            set_paper_num('2', $value['type_id'], 1);
        }
        if (!$db->query("Delete from " . table('evaluation_paper') . " WHERE id IN ({$sqlin})")) {
            return false;
        }
        $return = $return + $db->affected_rows();
        return $return;
    } else {
        return false;
    }
}
Example #2
0
        if (empty($_FILES['img']['name'])) {
            adminmsg('请上传图片!', 1);
        } else {
            $eval_updir = "../data/eval/img/" . date("Y/m/d/");
            make_dir($eval_updir);
            $setarr['img'] = _asUpFiles($eval_updir, "img", 1000, 'gif/jpg/bmp/png', true);
            if (empty($setarr['img'])) {
                adminmsg('上传文件失败!', 1);
            }
            $setarr['img'] = date("Y/m/d/") . $setarr['img'];
        }
        $link[0]['text'] = "返回列表";
        $link[0]['href'] = '?act=list';
        write_log("后台添加试卷信息", $_SESSION['admin_name'], 3);
        //更新试卷数  1=>加    2=>减
        set_paper_num('1', $setarr["type_id"], 1);
        !$db->inserttable(table("evaluation_paper"), $setarr) ? adminmsg("添加失败!") : adminmsg("添加成功!", 2, $link);
    }
} elseif ($act == "paper_del") {
    $id = !empty($_REQUEST['id']) ? $_REQUEST['id'] : adminmsg("你没有选择试卷!", 1);
    $num = del_paper($id);
    if ($num > 0) {
        write_log("后台删除试卷,共删除" . $return . "行", $_SESSION['admin_name'], 3);
        adminmsg("删除成功!共删除" . $num . "行", 2);
    } else {
        adminmsg("删除失败!", 0);
    }
} elseif ($act == 'question_list') {
    get_token();
    // 试卷id
    $paper_id = intval($_GET['id']);