<?php
if(!isset($_POST['action']))
{
//来访若没有定义action  那么就忽略
    exit();
}


//管理员权限检测
if(!isset($_COOKIE['gm']))
{
    echo"非管理员不得操作！";
    //没有读取到管理权限
    exit();
}
$gm=$_COOKIE['gm'];
if($gm<=0)
{
    echo"非管理员不得操作！";
    //管理权限不足
    exit();
}

//获取操作数据
include ('./functions.php');
include_once ("./conn.php");
$action=$_POST['action'];//操作类型
if($action=="editmajor")
{
    //编辑专业 保存
    $majorid=$_POST['majorid'];
    $majorname=$_POST['majorname'];
    $creditlimit=$_POST['creditlimit'];
    $sql="update major set majorname='$majorname',creditlimit='$creditlimit' where majorid='$majorid'";
    //执行sql命令
    $result=mysqli_query($link,$sql);
    if($result)
    {
        alertjump(1,"修改成功！","Adminmajor.php");
    }else{
        alertjump(1,"修改失败！","Adminmajor.php");
    }

}if($action=="addnewmajor")
{
    //添加一个新的专业
    //检测是否存在相同专业
    $majorname=$_POST['majorname'];
    $creditlimit=$_POST['creditlimit'];
    $sql="select * from major where majorname='$majorname'";
    //执行sql命令
    $result=mysqli_query($link,$sql);
    $num=mysqli_num_rows($result);
    if($num>0)
    {
        alertjump(1,"添加失败！该专业已存在！","Adminnew.php?kind=addnewmajor");
    }else{
        $sql="insert into major(majorname,creditlimit) values('$majorname','$creditlimit')";
        //执行sql命令
        $result=mysqli_query($link,$sql);
        if($result)
        {
            alertjump(1,"添加成功！","Adminmajor.php");
        }else{
            alertjump(1,"添加失败！","Adminmajor.php");
        }

    }




}else if($action=="addnewteacher")
{
    //添加一个新的专业
    //检测是否存在相同专业
    $teachername=$_POST['teachername'];
    $introduceid=$_POST['introduceid'];
    $sql="select * from teacher where teachername='$teachername'";
    //执行sql命令
    $result=mysqli_query($link,$sql);
    $num=mysqli_num_rows($result);
    if($num>0)
    {
        alertjump(1,"添加失败！该老师已存在！","Adminnew.php?kind=addnewteacher");
    }else{
        $sql="insert into teacher(teachername,introduceid) values('$teachername','$introduceid')";
        //执行sql命令
        $result=mysqli_query($link,$sql);
        if($result)
        {
            alertjump(1,"添加成功！","Adminteacher.php");
        }else{
            alertjump(1,"添加失败！","Adminteacher.php");
        }

    }




}else if($action=="editstudent"){
    //管理员更新学生用户资料
    $username=$_POST['username'];
    $realname=$_POST['realname'];
    $email=$_POST['email'];
    date_default_timezone_set("PRC");//消除时差
    $birthday=(int)strtotime($_POST['birthday']);
    $identity=$_POST['identity'];
    $address=$_POST['address'];
    $tel=$_POST['tel'];
    if($_POST['gender']=="男")
    {
        $gender=0;
    }
    else if($_POST['gender']=="女")
    {
        $gender=1;
    }
    $result = $link->query("update accounts
                                   set gender='$gender', realname='$realname',email='$email',birthday='$birthday',identity='$identity',address='$address',tel='$tel' 
                                   where username='$username'"
    );
    if($result)
    {
        alertjump(1,"修改成功！","Adminstudent.php");
    }else{
        alertjump(1,"修改失败！","Adminstudent.php");
    }
}else if($action=="editteacher"){
    //管理员更新教师资料
    //编辑教师 保存
    $teacherid=$_POST['teacherid'];
    $teachername=$_POST['teachername'];
    $introduceid=$_POST['introduceid'];
    $sql="update teacher set teachername='$teachername',introduceid='$introduceid' where teacherid='$teacherid'";
    //执行sql命令
    $result=mysqli_query($link,$sql);
    if($result)
    {
        alertjump(1,"修改成功！","Adminteacher.php");
    }else{
        alertjump(1,"修改失败！","Adminteacher.php");
    }
}else if($action=="editcourse"){
    //管理员更新课程资料
    //编辑资料 保存
    $courseid=$_POST['courseid'];
    $numpeople=$_POST['numpeople'];
    $coursename=$_POST['coursename'];
    $teacherid=$_POST['teacherid'];
    $credit=$_POST['credit'];
    $kind=$_POST['kind'];
    $introducetext=$_POST['introducetext'];
    $introduceid=$_POST['introduceid'];
    $picnameinfile=$_POST['picnameinfile'];
    $introducenameinfile=$_POST['introducenameinfile'];



    //收取文件1
    $resultmessage="";
    if($_FILES['file1']['error']==0 )//&& $_FILES['file2']['error']!=0
    {
        //封面图片正常上传
        var_dump($_FILES['file1']);
        $pic=$_FILES['file1'];
        if($pic['type']=="image/jpeg" || $pic['type']=="image/jpg" || $pic['type']=="image/bmp" || $pic['type']=="image/gif" || $pic['type']=="image/png" )
        {
            //图片格式正确
            //删除原有图片
            if(file_exists("./courselib/pic/$picnameinfile"))
            {
                //存在就删
                delall("./courselib/pic/$picnameinfile");
            }
            //删完就补
            $moveresult=move_uploaded_file($pic['tmp_name'],'./courselib/pic/'.$picnameinfile);
            if($moveresult) {
                $resultmessage.= "图片封面上传成功,";
                //图片载入数据库
            }else{
                $resultmessage.= "图片封面上传失败,";
            }


        }else{
            $resultmessage.= "图片格式类型不对上传失败,";
        }


    }    //else图片上传出错 或没有


    //收取文件2
    if($_FILES['file2']['error']==0 )//&& $_FILES['file2']['error']!=0
    {
        //介绍文件正常上传
        var_dump($_FILES['file2']);
        $zipfile=$_FILES['file2'];
        if( $zipfile['type']=="application/x-zip-compressed")
        {
            //压缩包格式正确
            //删除原有压缩包
            if(file_exists("./introduce/zip/$introducenameinfile"))
            {
                //存在就删
                delall("./introduce/zip/$introducenameinfile");
            }
            //删完就补
            $moveresult=move_uploaded_file($zipfile['tmp_name'],'./introduce/zip/'.$introducenameinfile);
            //再删解压后的文件夹
            if(file_exists("./introduce/ziptohtml/$introducenameinfile"))
            {
                //存在就删
                delall("./introduce/ziptohtml/$introducenameinfile");
            }
            //再补解压文件夹
            $unzipresult=unzip_file('./introduce/zip/'.$introducenameinfile,'./introduce/ziptohtml/'.$introducenameinfile);

            if($moveresult && $unzipresult) {
                $resultmessage.= "介绍文件上传成功,";
                //图片载入数据库
            }else{
                $resultmessage.= "介绍文件上传失败,";
            }


        }else{
            $resultmessage.= "介绍文件类型不对上传失败,";
        }


    }


    //先修改course表
    $sql="update course 
          set numpeople='$numpeople',coursename='$coursename', teacherid='$teacherid',credit='$credit',kind='$kind'
          where courseid='$courseid'";
    //执行sql命令
    $result=mysqli_query($link,$sql);
    if($result)
    {




        //再修改introduce表
        if($_FILES['file1']['name']=="" && $_FILES['file2']['name']=="")
        {
            //两个都没有更改
            $sql="update introduce 
              set introducetext='$introducetext'
              where introduceid='$introduceid'";
        }else if($_FILES['file1']['name']=="")
        {
            $sql="update introduce 
              set introducetext='$introducetext',introducename='{$_FILES['file2']['name']}'
              where introduceid='$introduceid'";
        }else if($_FILES['file2']['name']=="")
        {

            $sql="update introduce 
              set introducetext='$introducetext',picname='{$_FILES['file1']['name']}'
              where introduceid='$introduceid'";
        }else{
            //两个都有更改
            $sql="update introduce 
              set introducetext='$introducetext',picname='{$_FILES['file1']['name']}',introducename='{$_FILES['file2']['name']}'
              where introduceid='$introduceid'";
        }

        //执行sql命令
        $result=mysqli_query($link,$sql);
        if($result)
        {
            $resultmessage.="修改成功！";
        }else{
            $resultmessage.="修改失败！";
        }

    }else{
        $resultmessage.="修改失败！";

    }
    alertjump(1,$resultmessage,"Admincourse.php");
}else  if($action=="addnewcourse"){
    //管理员添加一门新的课程
    $numpeople=$_POST['numpeople'];
    $coursename=$_POST['coursename'];
    $teacherid=$_POST['teacherid'];
    $credit=$_POST['credit'];
    $kind=$_POST['kind'];
    $introducetext=$_POST['introducetext'];

    $getfile1=false;
    $getfile2=false;
    //收取文件1
    $resultmessage="";
    if($_FILES['file1']['error']==0 )//&& $_FILES['file2']['error']!=0
    {
        //封面图片正常上传
        var_dump($_FILES['file1']);
        $pic=$_FILES['file1'];
        if($pic['type']=="image/jpeg" || $pic['type']=="image/jpg" || $pic['type']=="image/bmp" || $pic['type']=="image/gif" || $pic['type']=="image/png" )
        {
            //图片格式正确
            //查找文件名
            $picnameinfile = 1;
            while(file_exists("./courselib/pic/".$picnameinfile))
            {
                $picnameinfile++;
            }
            //找完就补
            $moveresult=move_uploaded_file($pic['tmp_name'],'./courselib/pic/'.$picnameinfile);
            if($moveresult) {
                $resultmessage.= "图片封面上传成功,";
                $getfile1=true;
                //图片载入数据库
            }else{
                $resultmessage.= "图片封面上传失败,";
            }


        }else{
            $resultmessage.= "图片格式类型不对上传失败,";
        }


    }    //else图片上传出错 或没有


    //收取文件2
    if($_FILES['file2']['error']==0 )//&& $_FILES['file2']['error']!=0
    {
        //介绍文件正常上传
        var_dump($_FILES['file2']);
        $zipfile=$_FILES['file2'];
        if( $zipfile['type']=="application/x-zip-compressed")
        {
            //压缩包格式正确
            //查找文件名
            $introducenameinfile=1;
            while(file_exists("./introduce/zip/".$introducenameinfile))
            {
                $introducenameinfile++;
            }

            //找完就补
            $moveresult=move_uploaded_file($zipfile['tmp_name'],'./introduce/zip/'.$introducenameinfile);
            //再解压后的文件夹
            if(file_exists("./introduce/ziptohtml/$introducenameinfile"))
            {
                //存在就删
                delall("./introduce/ziptohtml/$introducenameinfile");
            }
            //再补解压文件夹
            $unzipresult=unzip_file('./introduce/zip/'.$introducenameinfile,'./introduce/ziptohtml/'.$introducenameinfile);

            if($moveresult && $unzipresult) {
                $resultmessage.= "介绍文件上传成功,";
                $getfile2=true;
                //图片载入数据库
            }else{
                $resultmessage.= "介绍文件上传失败,";
            }


        }else{
            $resultmessage.= "介绍文件类型不对上传失败,";
        }


    }

    if($getfile1 && $getfile2)
    {
        //先修改introduce表
        $sql="insert into introduce(introducetext,picname,introducename,picnameinfile,introducenameinfile) 
              values('$introducetext','{$_FILES['file1']['name']}','{$_FILES['file2']['name']}','$picnameinfile','$introducenameinfile')";
        //执行sql命令
        $result=mysqli_query($link,$sql);
        if($result)
        {
            $result2=mysqli_query($link,"select max(introduceid) from introduce");
            $row=mysqli_fetch_row($result2);
            $introduceid=$row[0];
            $resultmessage.=$introduceid;
            //再修改course表
            $sql="insert into course (numpeople,coursename,teacherid,credit,kind,introduceid) 
                  values ('$numpeople','$coursename','$teacherid','$credit','$kind','$introduceid')";
            //执行sql命令
            $result=mysqli_query($link,$sql);
            if($result)
            {

                $resultmessage.="修改成功！";
            }else{
                $resultmessage.="修改失败3！";
            }


        }else{
            $resultmessage.="修改失败2！";

        }
    }else{
        $resultmessage.="修改失败1！";

    }

    alertjump(1,$resultmessage,"Admincourse.php");
}else  if($action=="addnewadpic"){
    //管理员添加新的轮播广告图
    $sequence=$_POST['sequence'];
    $tourl=$_POST['tourl'];


    $getfile1=false;
    //收取文件1
    $resultmessage="";
    if($_FILES['file1']['error']==0 )//&& $_FILES['file2']['error']!=0
    {
        //封面图片正常上传
        var_dump($_FILES['file1']);
        $pic=$_FILES['file1'];
        if($pic['type']=="image/jpeg" || $pic['type']=="image/jpg" || $pic['type']=="image/bmp" || $pic['type']=="image/gif" || $pic['type']=="image/png" )
        {
            //图片格式正确
            //查找文件名
            $picnameinfile = 1;
            while(file_exists("./adpic/pics/".$picnameinfile))
            {
                $picnameinfile++;
            }
            //找完就补
            $moveresult=move_uploaded_file($pic['tmp_name'],'./adpic/pics/'.$picnameinfile);
            if($moveresult) {
                $resultmessage.= "图片轮播图上传成功,";
                $getfile1=true;
                //图片载入数据库
            }else{
                $resultmessage.= "图片轮播图上传失败,";
            }


        }else{
            $resultmessage.= "图片格式类型不对上传失败,";
        }


    }    //else图片上传出错 或没有




    if($getfile1)
    {
        //修改adpic表
        $sql="insert into adpic(sequence,picname,picnameinfiles,tourl) 
              values('$sequence','{$_FILES['file1']['name']}','$picnameinfile','$tourl')";
        //执行sql命令
        $result=mysqli_query($link,$sql);
        if($result)
        {
            $resultmessage.="修改成功！";

        }else{
            $resultmessage.="修改失败2！";

        }
    }else{
        $resultmessage.="修改失败1！";

    }

    alertjump(1,$resultmessage,"Admin.php");
}
else if($action=="editadpic"){
    //管理员更新广告轮播图
    //编辑资料 保存
    $adid=$_POST['adid'];
    $sequence=$_POST['sequence'];
    $tourl=$_POST['tourl'];
    $picnameinfile=$_POST['picnameinfiles'];
    if($picnameinfile=="")exit();


    //收取文件1
    $resultmessage="";
    if($_FILES['file1']['error']==0 )//&& $_FILES['file2']['error']!=0
    {
        //封面图片正常上传
        var_dump($_FILES['file1']);
        $pic=$_FILES['file1'];
        if($pic['type']=="image/jpeg" || $pic['type']=="image/jpg" || $pic['type']=="image/bmp" || $pic['type']=="image/gif" || $pic['type']=="image/png" )
        {
            //图片格式正确
            //删除原有图片
            if(file_exists("./adpic/pics/$picnameinfile"))
            {
                //存在就删
                delall("./adpic/pics/$picnameinfile");
            }
            //删完就补
            $moveresult=move_uploaded_file($pic['tmp_name'],'./adpic/pics/'.$picnameinfile);
            if($moveresult) {
                $resultmessage.= "轮播图片上传成功,";
                //图片载入数据库
            }else{
                $resultmessage.= "轮播图片上传失败,";
            }


        }else{
            $resultmessage.= "图片格式类型不对上传失败,";
        }


    }    //else图片上传出错 或没有





    //修改adpic表
    if($_FILES['file1']['name']=="")
    {
        $sql="update adpic 
          set sequence='$sequence', picnameinfiles='$picnameinfile',tourl='$tourl'
          where adid='$adid'";
    }else{
        $sql="update adpic 
          set sequence='$sequence',picname='{$_FILES['file1']['name']}', picnameinfiles='$picnameinfile',tourl='$tourl'
          where adid='$adid'";

    }
    //执行sql命令
    $result=mysqli_query($link,$sql);
    if($result)
    {

        $resultmessage.="修改成功！";

    }else{
        $resultmessage.="修改失败！";

    }
    alertjump(1,$resultmessage,"Admin.php");
}
else if($action=="addnewrule"){
    $courseid=$_POST['courseid'];
    $majorid=$_POST['majorid'];
    $grade=$_POST['grade'];
    $sql="select * from elective where courseid='$courseid' and majorid='$majorid' and grade='$grade'";
    //执行sql命令
    $result=mysqli_query($link,$sql);
    $num=mysqli_num_rows($result);
    if($num>0)
    {
        alertjump(1,"添加失败！该规则已存在！","Adminnew.php?kind=addnewrule");
    }else{
        $sql="insert into electivelimit(courseid,majorid,grade) values('$courseid','$majorid','$grade')";
        //执行sql命令
        $result=mysqli_query($link,$sql);
        if($result)
        {
            alertjump(1,"添加成功！","Adminexamine.php");
        }else{
            alertjump(1,"添加失败!2","Adminnew.php?kind=addnewrule");
        }

    }



}else alertjump(1,"？？？？？？","Admin.php");;
$link->close();
?>

</body>
</html>