admin.php如何重新上传,cj_admin.php

session_start();

error_reporting(0);

if(!$_SESSION['sjzusersort']) {Header("Location:./");exit();}

elseif($_SESSION['sjzusercheck']) {Header("Location:./");exit();}

$url='index';

include("../conn.php");

$action=_get('action');

$id=_get('id');

$sheet=_get('sheet');

$grade=_post('grade');

$class=_post('class');

$classname=_post('classname');

$getdata=_post('getdata');

$data=_post('data');

$alert=_get('alert');

$teacher=_get('teacher');

if ($alert=='1') $alert='修改成功！';

elseif ($alert=='2') $alert='学年、学期均不能为空！';

elseif ($alert=='3') $alert='任课信息添加成功！';

elseif ($alert=='4') $alert='任课信息修改成功！';

elseif ($alert=='5') $alert='上传文件名为空！';

elseif ($alert=='6') $alert='请选择xls格式文件上传！';

elseif ($alert=='7') $alert='文件不能大于8M！';

elseif ($alert=='8') $alert='文件上传出错！可能是目录"'.upfile().'"不可读写！';

elseif ($alert=='81') $alert='文件中无工作表信息，请检查文件！';

elseif ($alert=='9') $alert='科目';

elseif ($alert=='10') $alert='班级';

elseif ($alert=='11') $alert='姓名';

elseif ($alert=='12') $alert='数据上传成功！';

elseif ($alert=='13') $alert='数据处理成功！';

if ($teacher=='1') $teacher='(没有任课教师信息！请添加！)';

if ($teacher=='2') $teacher='(已有任课教师信息，未更新！)';

if ($action=="configedit") {

$schoolname=_post('schoolname');

$schoolweb=_post('schoolweb');

$cjlogin=_post('cjlogin');

$cjyear=_post('cjyear');

$cjyear=substr($cjyear,0,4);

$cjterm=_post('cjterm');

$cjterm=str_replace("１","1",$cjterm);

$cjterm=str_replace("２","2",$cjterm);

$cjterm=str_replace("二","2",$cjterm);

$cjterm=str_replace("一","1",$cjterm);

$cjabout=_post('cjabout');

$cjsub=postcheck(_post('cjsubject'));

$subject=explode(',',$cjsub);

$subnum=count($subject);

$subtemp=$cj_subject;

$cjtestname=postcheck(_post('cjtestname'));

$cjitem=postcheck(_post('cjitem'));

$cjlevel=postcheck(_post('cjlevel'));

if ($cjyear && $cjterm) {

mysql_query("update cj_config set cj_schoolname='$schoolname',cj_schoolweb='$schoolweb',cj_year='$cjyear',cj_term='$cjterm',cj_subject='$cjsub',cj_testname='$cjtestname',cj_item='$cjitem',cj_level='$cjlevel',cj_about='$cjabout'");

for($i=0;$i

if (in_array($subject[$i],$cj_subject)) {

$subtemp=str_replace($subject[$i],'',$subtemp);

} else {

mysql_query ("alter table cj_data add ".$subject[$i]." smallint(4) not null");

mysql_query ("alter table cj_teacher add ".$subject[$i]." varchar(10) character set utf8 collate utf8_general_ci not null");

}

}

$subtemp=str_replace(';;','',$subtemp);

$subtmp=explode(";",$subtemp);

$subnum=count($subtmp);

for($i=0;$i

mysql_query ("alter table cj_data drop ".$subtmp[$i]);

mysql_query ("alter table cj_teacher drop ".$subtmp[$i]);

}

echo "";

}

else echo "";

exit();

} elseif ($action=="saveteacher") {

if (_post('delteacher')=='删除') {

mysql_query("delete from cj_teacher where id=$id");

echo "";

exit();

}

$getdata=_post('getdata');

$grade=_post('grade');

if (!$grade) $grade=$getdata;

$class=_post('classname');

$class=str_replace('０','0',$class);

$class=str_replace('１','1',$class);

$class=str_replace('２','2',$class);

$class=str_replace('３','3',$class);

$class=str_replace('４','4',$class);

$class=str_replace('５','5',$class);

$class=str_replace('６','6',$class);

$class=str_replace('７','7',$class);

$class=str_replace('８','8',$class);

$class=str_replace('９','9',$class);

if ((!$class || !$grade) && !$id && !$getdata) {echo "";exit();}

$subject=$cj_subject;

$num=count($subject);

for($i=0;$i

$adddata1.=','.$subject[$i];

$adddata2.=",'"._post($i)."'";

if (!$i) $adddata3.=$subject[$i]."='"._post($i)."'";

else $adddata3.=",".$subject[$i]."='"._post($i)."'";

$tmp.=_post($i);

}

$bzr=_post('bzr');

$tmp.=_post('bzr');

if (!$tmp) {echo "";exit();}

if (!$id) {

$datacount=mysql_num_rows(mysql_query("select * from cj_teacher where 数据='$grade' and 班级=$class"));

if (!$datacount) {

if (!$getdata) {

mysql_query("insert into cj_teacher (数据,班级$adddata1,班主任,现任) values ('$grade',".$class.$adddata2.",'$bzr',1)");

echo "";

} else {

mysql_query("insert into cj_teacher (数据,班级$adddata1,班主任) values ('$grade',".$class.$adddata2.",'$bzr')");

echo "";

}

} else echo "";

} else {

mysql_query("update cj_teacher set $adddata3,班主任='$bzr' where id=$id");

echo "";

}

exit();

} elseif ($action=="saveinfo") {

$grade=_post('grade');

$time=_post('time');

$class=_post('class');

$cjdata=substr($grade,0,5).'_'.substr($time,0,4).substr($grade,5,1);

if (!$grade || !$class || !$time) {echo "";exit();}

$subjectall=$cj_subject;

$numall=count($subjectall);

for ($i=0; $i

$posti=_post($i);

if (!$posti) $posti=0;

$insert1.=",".$subjectall[$i];

$insert2.=",".$posti;

$update1.=",".$subjectall[$i]."=".$posti;

}

$now=_post('now');

if (!$now) $now=0;

if ($now==1) mysql_query("update cj_data set 现在=0 where (年级='".$grade."' or 年级='".substr($grade,0,5)."') and 现在=1");

mysql_query("update cj_data set 年级='$grade',班级='$class',时间='$time'".$update1.",数据='$cjdata',现在=$now where id=$id");

echo "";

exit();

} elseif ($action=="delinfo") {

$deldata=mysql_fetch_array(mysql_query("select * from cj_data where id=$id"));

if ($deldata['现在']==1) mysql_query("update cj_data set 现在=1 where 数据='".$deldata['上次']."'");

mysql_query("drop table ".$deldata['数据']);

mysql_query("delete from cj_data where id=".$id);

mysql_query("delete from cj_teacher where 数据='".$deldata['数据']."'");

echo "";

exit();

} elseif ($action=="delteacher") {

mysql_query("delete from cj_teacher where id=$id");

echo "";

exit();

} elseif ($action=="listtemp") {

?>

上传成绩数据表浏览

关闭本窗口

$tempexe="select * from temptable order by 总分 desc";

if ($sheet) $tempexe="select * from temptable order by 类别,总分 desc";

$temprs=mysql_query($tempexe);

if(!$temprs){echo '

无上传成绩数据表或数据表已失效!

';exit();}

$j=mysql_num_fields($temprs);

echo '

序号

for($i=0;$i

$meta=mysql_fetch_field($temprs);

echo '

'.$meta->name.'';

}

echo '

';

$k=1;

while($tempdata=mysql_fetch_array($temprs)){

echo '

'.$k.'';

for($i=0;$i'.$tempdata[$i].'';

echo '

';

$k=$k+1;

}

?>

关闭本窗口