百度Echarts消防训练成绩大数据可视化综合分析系统开发实录（1）饼图表格互动篇

    $projectSelect = $_POST['projectSelect'];
    $selectDepart = $_POST['selectDepart'];
    $grade = $_POST['grade'];
    $start_date = $_POST['start_date'];
    $end_date = $_POST['end_date'];
    //查询语句；
    $sql = "select category_id,category_name,achieve_grade,member_depart,achieve_time,COUNT(achieve_accurate) as achieve_accurate from " . $db->table('achieve') . " where 1";
    //训练项目查询；
    IF ($projectSelect != "") {
      $sql .= " AND category_id in ($projectSelect)";
    }
    //所在单位查询；
    IF ($selectDepart != "") {
      $sql .= " AND instr (\" . $selectDepart . \",member_depart) > 0";
    }
    //选择成绩评定查询；
    IF ($grade != "") {
      $sql .= " AND instr (\" . $grade . \",achieve_grade) > 0";
    }
    //起始时间；
    IF ($start_date != "") {
      $sql .= "  AND date_format(from_unixtime(achieve_time),'%Y-%m-%d') >= '$start_date'";
    }
    //结束时间；
    IF ($end_date != "") {
      $sql .= "  AND date_format(from_unixtime(achieve_time),'%Y-%m-%d') <= '$end_date'";
    }
    $sql .= ' group by achieve_grade';

gradeName.push(result.data[i].achieve_grade);