function createAlways()
{
$grdid = $_POST['f_cjzx_grdid'];
$grd = M('grd');
$grdo = $grd->where('grdid=' . $grdid)->find();
//改变的是学期 是课程 是老师
$cls = M($grdo['grdnm'] . '_cls');
// $pk=M($grdo['grdnm'].'_pk');
$xq = M('xq');
$xqodq = $xq->where('xqdq=1')->find();
if ($_POST['f_stdxqcls_clsid'] != 'bkl') {
$wherecls = '1=1';
// $wherepk='1=1';
if ($_POST['f_cjzx_sttid']) {
$wherecls = $wherecls . ' AND f_cls_sttid=' . $_POST['f_cjzx_sttid'];
// $wherepk=$wherepk.' AND f_pk_sttid='.$_POST['f_xk_sttid'];
}
if ($_POST['f_xk_grdid']) {
$wherecls = $wherecls . ' AND f_cls_grdid=' . $_POST['f_xk_grdid'];
// $wherepk=$wherepk.' AND f_pk_grdid='.$_POST['f_xk_grdid'];
}
// if($_POST['f_xk_xqid']){
// $wherepk=$wherepk.' AND f_pk_xqid='.$_POST['f_xk_xqid'];
// }
$clsls = $cls->join('tb_stt ON f_cls_sttid=sttid')->where($wherecls . ' AND clsactvt=1')->order('clsnm DESC')->select();
$clsoptu = "<option value=''>无</option>";
foreach ($clsls as $v) {
$clsoptu = $clsoptu . "<option value='" . $v['clsid'] . "'>[" . $v['sttnm'] . ']' . $v['clsnm'] . "</option>";
}
// $pkls=$pk->join('tb_'.$grdo['grdnm'].'_kc ON f_pk_kcid=kcid')->join('tb_tcr ON f_pk_tcrid=tcrid')->where($wherepk)->select();
// $pkoptu="<option value=''>无</option>";
// foreach ($pkls as $v){
// $pkoptu=$pkoptu."<option value='".$v['pkid']."'>".$v['kcnm'].'-'.$v['tcrnn']."</option>";
// }
$data['clsoptu'] = $clsoptu;
// $data['pkoptu']=$pkoptu;
}
if ($_POST['f_cjzx_sttid']) {
import('@.XQ.XQAction');
$xqw = new XQAction();
//外来的学期
$xqls = $xqw->getxqls($grdo['grdid'], $_POST['f_cjzx_sttid'], 'DESC');
} else {
$xq = M('xq');
$xqls = $xq->order('xqnm DESC')->select();
}
$xqoptu = '';
foreach ($xqls as $v) {
if ($v['xqid'] == $xqodq['xqid']) {
$xqoptu = $xqoptu . "<option value='" . $v['xqid'] . "' selected >" . $v['xqnm'] . "</option>";
} else {
$xqoptu = $xqoptu . "<option value='" . $v['xqid'] . "'>" . $v['xqnm'] . "</option>";
}
}
$data['xqoptu'] = $xqoptu;
if ($_POST['f_stdxqcls_clsid']) {
//找那个班的学生代表看看他选了那些选课
$stdxqcls = M($grdo['grdnm'] . '_stdxqcls');
$stdxqclso = $stdxqcls->join('tb_' . $grdo['grdnm'] . '_std ON f_stdxqcls_stdid=stdid')->where('f_stdxqcls_xqid=' . $_POST['f_xk_xqid'] . ' AND f_stdxqcls_clsid=' . $_POST['f_stdxqcls_clsid'] . ' AND f_std_statid=5')->find();
$xk = M($grdo['grdnm'] . '_xk');
$pkls = $xk->join('tb_' . $grdo['grdnm'] . '_pk ON f_xk_pkid=pkid')->join('tb_' . $grdo['grdnm'] . '_kc ON f_pk_kcid=kcid')->join('tb_tcr ON f_pk_tcrid=tcrid')->where('f_xk_sttid=' . $_POST['f_xk_sttid'] . ' AND f_xk_xqid=' . $_POST['f_xk_xqid'] . ' AND f_xk_stdid=' . $stdxqclso['f_stdxqcls_stdid'])->select();
$pkoptu = "<option value=''>无</option>";
foreach ($pkls as $v) {
$pkoptu = $pkoptu . "<option value='" . $v['pkid'] . "'>" . $v['kcnm'] . '-' . $v['tcrnn'] . "</option>";
}
} else {
$pkoptu = "<option value=''>无</option>";
}
$data['pkoptu'] = $pkoptu;
$data['status'] = 1;
$this->ajaxReturn($data, 'json');
}
function createAlways()
{
$grdid = $_POST['f_cls_grdid'];
$sttid = $_POST['f_cls_sttid'];
$grd = M('grd');
$grdo = $grd->where('grdid=' . $grdid)->find();
//适应一些站点用一二三
import('@.XQ.XQAction');
$xqw = new XQAction();
//外来的学期
$xqls = $xqw->getxqls($grdid, $sttid, 'ASC');
$str = "<option value=''></option>";
foreach ($xqls as $xqv) {
$str = $str . "<option value='" . $xqv['xqid'] . '_' . $xqv['xqnm'] . "'>" . $xqv['xqnm'] . "</option>";
}
$data['str'] = $str;
$data['status'] = 1;
$this->ajaxReturn($data, 'json');
}
function createAlways()
{
$grdid = $_POST['f_std_grdid'];
$grd = M('grd');
$grdo = $grd->where('grdid=' . $grdid)->find();
$xq = M('xq');
$xqodq = $xq->where('xqdq=1')->find();
if ($_POST['f_std_sttid']) {
import('@.XQ.XQAction');
$xqw = new XQAction();
//外来的学期
$xqls = $xqw->getxqls($grdo['grdid'], $_POST['f_std_sttid'], 'DESC');
} else {
$xq = M('xq');
$xqls = $xq->order('xqnm DESC')->select();
}
$xqoptu = '';
foreach ($xqls as $v) {
if ($v['xqid'] == $xqodq['xqid']) {
$xqoptu = $xqoptu . "<option value='" . $v['xqid'] . "' selected>" . $v['xqnm'] . "</option>";
} else {
$xqoptu = $xqoptu . "<option value='" . $v['xqid'] . "'>" . $v['xqnm'] . "</option>";
}
}
$data['xqoptu'] = $xqoptu;
//看情况产生学号//看看的
//1、如果是query中的班级变化，应该对下面的学号不产生影响
//2、如果是add或者modify中的class的变化应该对stdno产生影响
//本次属于传是传了，但是不知道是不是为null还是0还是其他数字，这个情况选用is_null
if (is_null($_POST['stdid'])) {
// 情况1
$data['stdno'] = '';
} else {
if ($_POST['stdid'] == 0) {
//随便搞
$flg = 'sbg';
} else {
$std = M($grdo['grdnm'] . '_std');
$stdo = $std->field('stdno')->where('stdid=' . $_POST['stdid'])->find();
if ($stdo['stdno']) {
$flg = 'zj';
} else {
$flg = 'sbg';
}
}
if ($flg == 'sbg') {
//按这学期的行情来，如果他之前没有学号的话
$xq = M('xq');
$xqodq = $xq->where('xqdq=1')->find();
if ($_POST['f_stdxqcls_xqid'] == $xqodq['xqid']) {
if ($_POST['f_stdxqcls_clsid']) {
//有班级
$clso = $cls->where('clsid=' . $_POST['f_stdxqcls_clsid'])->find();
if ($clso['clsxhprx']) {
//且班级的前缀是给了的
$std = M($grdo['grdnm'] . '_std');
$stdo = $std->field('stdno')->where("stdno LIKE '%" . $clso['clsxhprx'] . "%'")->order('stdno DESC')->find();
if ($stdo) {
//有学生
$xhzjdtx = (int) substr($stdo['stdno'], -2);
//学号最近的同学
$xhzjdtx = $xhzjdtx + 1;
$data['stdno'] = $clso['clsxhprx'] . $xhzjdtx;
} else {
//之前木有学生的话捏
$data['stdno'] = $clso['clsxhprx'] . '01';
}
} else {
$data['stdno'] = '';
}
} else {
$data['stdno'] = '';
}
} else {
$data['stdno'] = '';
}
}
if ($flg == 'zj') {
$stdo = $std->field('stdno')->where('stdid=' . $_POST['stdid'])->find();
$data['stdno'] = $stdo['stdno'];
}
}
//处理报名号//看看的
if (is_null($_POST['stdid'])) {
// 情况1
$data['stdaplno'] = '';
} else {
if ($_POST['stdid'] == 0) {
$flg = 'sbg';
} else {
$xq = M('xq');
$xqodq = $xq->where('xqdq=1')->find();
if ($_POST['f_stdxqcls_xqid'] == $xqodq['xqid']) {
//在2.3之间的bxxsid 切换了则用新的，否则用旧的
$stdxqmj = M($grdo['grdnm'] . '_stdxqmj');
$stdxqmjo = $stdxqmj->where('f_stdxqmj_stdid=' . $_POST['stdid'])->order('f_stdxqmj_xqid DESC')->find();
$mjid = $stdxqmjo['f_stdxqmj_mjid'];
$mj = M($grdo['grdnm'] . '_mj');
$mjo = $mj->where('mjid=' . $mjid)->find();
$bxxsid = $mjo['f_mj_bxxsid'];
$bxxs = M('bxxs');
$bxxso = $bxxs->where('bxxsid=' . $bxxsid)->find();
$f_mj_bxxsid = $_POST['f_mj_bxxsid'];
//处理报名号//如果和当前学期，这个属于学籍部分
if ((preg_match('/技能/', $bxxso['bxxsnm']) || preg_match('/自考/', $bxxso['bxxsnm'])) && $f_mj_bxxsid != $bxxsid) {
//添加的话是 有特殊说明 按特殊说明来，否则的话就是给编一个
//修改则不同，一般而言肯定是2和3都有aplno了的，所以重点就在于是延续保持，还是换，而且报名号也就是招生期间用之后就没有意义了
$flg = 'sbg';
} else {
$flg = 'zj';
}
} else {
$flg = 'zj';
}
}
if ($flg == 'sbg') {
$f_mj_bxxsid = $_POST['f_mj_bxxsid'];
$bxxs = M('bxxs');
$bxxso = $bxxs->where('bxxsid=' . $f_mj_bxxsid)->find();
$stdaplno = '';
if (preg_match('/技能/', $bxxso['bxxsnm']) || preg_match('/自考/', $bxxso['bxxsnm'])) {
if (preg_match('/技能/', $bxxso['bxxsnm'])) {
$stdaplno = 'J' . $grdo['grdnm'];
} else {
if (preg_match('/自考/', $bxxso['bxxsnm'])) {
$stdaplno = 'Z' . $grdo['grdnm'];
}
}
$std = M($grdo['grdnm'] . '_std');
$stdls = $std->field('stdaplno')->where("stdaplno LIKE '%" . $stdaplno . "%'")->order('stdaplno DESC')->select();
if (count($stdls) > 0) {
$stdo = $stdls[0];
$hou = substr($stdo['stdaplno'], 5);
$hounew = intval($hou) + 1;
if (intval($hounew / 1000) > 0) {
$k = 0;
} else {
if (intval($hounew / 100) > 0) {
$k = 1;
} else {
if (intval($hounew / 10) > 0) {
$k = 2;
} else {
$k = 3;
}
}
}
} else {
$k = 3;
$hounew = 1;
}
$ling = '';
for ($i = 0; $i < $k; $i++) {
$ling = $ling . '0';
}
$stdaplno = $stdaplno . $ling . $hounew;
}
}
if ($flg == 'zj') {
//照旧
$std = M($grdo['grdnm'] . '_std');
$stdo = $std->field('stdaplno')->where('stdid=' . $_POST['stdid'])->find();
$stdaplno = $stdo['stdaplno'];
}
$data['stdaplno'] = $stdaplno;
}
$data['status'] = 1;
$this->ajaxReturn($data, 'json');
}
function createAlways()
{
$grdid = $_POST['f_cjzx_grdid'];
$grd = M('grd');
$grdo = $grd->where('grdid=' . $grdid)->find();
//改变的是学期 是课程 是老师
$cls = M($grdo['grdnm'] . '_cls');
// $pk=M($grdo['grdnm'].'_pk');
$xq = M('xq');
$xqodq = $xq->where('xqdq=1')->find();
$wherecls = '1=1';
// $wherepk='1=1';
if ($_POST['f_cjzx_sttid']) {
$wherecls = $wherecls . ' AND f_cls_sttid=' . $_POST['f_cjzx_sttid'];
// $wherepk=$wherepk.' AND f_pk_sttid='.$_POST['f_cjzx_sttid'];
}
if ($_POST['f_cjzx_grdid']) {
$wherecls = $wherecls . ' AND f_cls_grdid=' . $_POST['f_cjzx_grdid'];
// $wherepk=$wherepk.' AND f_pk_grdid='.$_POST['f_cjzx_grdid'];
}
// if($_POST['f_cjzx_xqid']){
// $wherepk=$wherepk.' AND f_pk_xqid='.$_POST['f_cjzx_xqid'];
// }
$clsls = $cls->join('tb_stt ON f_cls_sttid=sttid')->where($wherecls . ' AND clsactvt=1')->order('clsnm DESC')->select();
$clsoptu = "<option value=''>无</option>";
foreach ($clsls as $v) {
$clsoptu = $clsoptu . "<option value='" . $v['clsid'] . "'>[" . $v['sttnm'] . ']' . $v['clsnm'] . "</option>";
}
// $pkls=$pk->join('tb_'.$grdo['grdnm'].'_kc ON f_pk_kcid=kcid')->join('tb_tcr ON f_pk_tcrid=tcrid')->where($wherepk)->select();
// $pkoptu="<option value=''>无</option>";
// foreach ($pkls as $v){
// $pkoptu=$pkoptu."<option value='".$v['pkid']."'>".$v['kcnm'].'-'.$v['tcrnn']."</option>";
// }
$data['clsoptu'] = $clsoptu;
// $data['pkoptu']=$pkoptu;
if ($_POST['f_cjzx_sttid']) {
import('@.XQ.XQAction');
$xqw = new XQAction();
//外来的学期
$xqls = $xqw->getxqls($grdo['grdid'], $_POST['f_cjzx_sttid'], 'DESC');
} else {
$xq = M('xq');
$xqls = $xq->order('xqnm DESC')->select();
}
$xqiddft = $xqls[0]['xqid'];
$xqoptu = '';
$findxqid = 0;
foreach ($xqls as $v) {
if ($v['xqid'] == $xqodq['xqid']) {
$findxqid = 1;
$xqid = $xqodq['xqid'];
$xqoptu = $xqoptu . "<option value='" . $v['xqid'] . "' selected >" . $v['xqnm'] . "</option>";
} else {
$xqoptu = $xqoptu . "<option value='" . $v['xqid'] . "'>" . $v['xqnm'] . "</option>";
}
}
if ($findxqid = 0) {
$xqid = $xqiddft;
}
$data['xqoptu'] = $xqoptu;
$cjzxforcls = M($grdo['grdnm'] . '_cjzx');
if ($_POST['f_stdxqcls_clsid']) {
//找那个班的学生代表看看他选了那些成绩中心//BIG不高，需要用高达上重新写
$pkidls = $cjzxforcls->Distinct(true)->field('pkid')->join('tb_' . $grdo['grdnm'] . '_pk ON f_cjzx_pkid=pkid')->join('tb_' . $grdo['grdnm'] . '_kc ON f_pk_kcid=kcid')->join('tb_tcr ON f_pk_tcrid=tcrid')->join('tb_' . $grdo['grdnm'] . '_std ON f_cjzx_stdid=stdid')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqcls ON stdid=f_stdxqcls_stdid')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqmj ON stdid=f_stdxqmj_stdid')->join('tb_stt ON f_std_sttid=sttid')->join('tb_grd ON f_std_grdid=grdid')->join('tb_' . $grdo['grdnm'] . '_mj ON f_stdxqmj_mjid=mjid')->join('tb_bxxs ON f_mj_bxxsid=bxxsid')->join('tb_cc ON f_mj_ccid=ccid')->join('tb_kl ON f_mj_klid=klid')->join('tb_xxxs ON f_mj_xxxsid=xxxsid')->join('tb_zsfw ON f_mj_zsfwid=zsfwid')->join('tb_xz ON f_mj_xzid=xzid')->join('tb_' . $grdo['grdnm'] . '_cls ON f_stdxqcls_clsid=clsid')->join('tb_sex ON f_std_sexid=sexid')->join('tb_rc ON f_std_rcid=rcid')->join('tb_zzmm ON f_std_zzmmid=zzmmid')->join('tb_xl ON f_std_xlid=xlid')->join('tb_stat ON f_std_statid=statid')->join('tb_xq ON f_stdxqcls_xqid=xqid')->where("f_cjzx_xqid=" . $xqid . " AND f_stdxqcls_xqid=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_std_statid=5 AND f_stdxqcls_clsid=" . $_POST['f_stdxqcls_clsid'])->select();
$where = '1=2';
foreach ($pkidls as $vI) {
$where = $where . ' OR pkid=' . $vI['pkid'];
}
$pk = m($grdo['grdnm'] . '_pk');
$pkls = $pk->join('tb_' . $grdo['grdnm'] . '_kc ON f_pk_kcid=kcid')->join('tb_tcr ON f_pk_tcrid=tcrid')->where($where)->order('pkzkkm ASC,kcnm ASC')->select();
$pkoptu = "<option value=''>无</option>";
foreach ($pkls as $v) {
if ($v['pkzkkm'] == 0) {
$pkoptu = $pkoptu . "<option value='" . $v['pkid'] . "'>" . $v['kcnm'] . '-' . $v['tcrnn'] . "</option>";
} else {
if ($v['pkzkkm'] == 1) {
$pkoptu = $pkoptu . "<option value='" . $v['pkid'] . "'>" . $v['kcnm'] . '-' . $v['tcrnn'] . "【自考科目】</option>";
}
}
}
} else {
$pkoptu = "<option value=''>无</option>";
}
$data['pkoptu'] = $pkoptu;
$data['status'] = 1;
$this->ajaxReturn($data, 'json');
}
function createXq()
{
$grdid = $_POST['f_std_grdid'];
$xnid = $_POST['f_cw_xnid'];
$sttid = $_POST['f_std_sttid'];
import('@.XQ.XQAction');
$xqw = new XQAction();
//外来的学期
$xqid = $xqw->getcwxqid($grdid, $xnid, $sttid);
$data['xqid'] = $xqid;
$data['status'] = 1;
$this->ajaxReturn($data, 'json');
}
function createAlways()
{
$grdid = $_POST['f_cjzx_grdid'];
$grd = M('grd');
$grdo = $grd->where('grdid=' . $grdid)->find();
//改变的是学期 是课程 是老师
$cls = M($grdo['grdnm'] . '_cls');
// $pk=M($grdo['grdnm'].'_pk');
$xq = M('xq');
$xqodq = $xq->where('xqdq=1')->find();
if ($_POST['f_cjzx_sttid']) {
import('@.XQ.XQAction');
$xqw = new XQAction();
//外来的学期
$xqls = $xqw->getxqls($grdo['grdid'], $_POST['f_cjzx_sttid'], 'DESC');
} else {
$xq = M('xq');
$xqls = $xq->order('xqnm DESC')->select();
}
$xqoptu = '';
foreach ($xqls as $v) {
if ($v['xqid'] == $xqodq['xqid']) {
$xqoptu = $xqoptu . "<option value='" . $v['xqid'] . "' selected >" . $v['xqnm'] . "</option>";
} else {
$xqoptu = $xqoptu . "<option value='" . $v['xqid'] . "'>" . $v['xqnm'] . "</option>";
}
}
$data['xqoptu'] = $xqoptu;
// if($_POST['f_stdxqcls_clsid']){
// //用高大上的方法选择数据库方法来选择PK
// $stdxqcls=M($grdo['grdnm'].'_stdxqcls');
// $stdxqclso=$stdxqcls->join('tb_'.$grdo['grdnm'].'_std ON f_stdxqcls_stdid=stdid')->where('f_stdxqcls_xqid='.$_POST['f_xk_xqid'].' AND f_stdxqcls_clsid='.$_POST['f_stdxqcls_clsid'].' AND f_std_statid=5')->find();
// $xk=M($grdo['grdnm'].'_xk');
// $pkls=$xk->join('tb_'.$grdo['grdnm'].'_pk ON f_xk_pkid=pkid')->join('tb_'.$grdo['grdnm'].'_kc ON f_pk_kcid=kcid')->join('tb_tcr ON f_pk_tcrid=tcrid')->where('f_xk_sttid='.$_POST['f_xk_sttid'].' AND f_xk_xqid='.$_POST['f_xk_xqid'].' AND f_xk_stdid='.$stdxqclso['f_stdxqcls_stdid'])->select();
// $pkoptu="<option value=''>无</option>";
// foreach ($pkls as $v){
// $pkoptu=$pkoptu."<option value='".$v['pkid']."'>".$v['kcnm'].'-'.$v['tcrnn']."</option>";
// }
// }else{
// $pkoptu="<option value=''>无</option>";
// }
// $data['pkoptu']=$pkoptu;
$wherecls = '1=1';
$cls = M($grdo['grdnm'] . '_cls');
$clsls = $cls->join('tb_stt ON f_cls_sttid=sttid')->where('clsactvt=1 AND f_cls_sttid=' . $_POST['f_cjzx_sttid'])->order('clsnm ASC')->select();
$clsoptu = "<option value=''>无</option>";
foreach ($clsls as $v) {
$clsoptu = $clsoptu . "<option value='" . $v['clsid'] . "'>[" . $v['sttnm'] . ']' . $v['clsnm'] . "</option>";
}
$data['clsoptu'] = $clsoptu;
$std = M($grdo['grdnm'] . '_std');
$stdls = $std->join('inner join tb_' . $grdo['grdnm'] . '_stdxqcls ON stdid=f_stdxqcls_stdid')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqmj ON stdid=f_stdxqmj_stdid')->join('tb_stt ON f_std_sttid=sttid')->join('tb_grd ON f_std_grdid=grdid')->join('tb_' . $grdo['grdnm'] . '_mj ON f_stdxqmj_mjid=mjid')->join('tb_bxxs ON f_mj_bxxsid=bxxsid')->join('tb_cc ON f_mj_ccid=ccid')->join('tb_kl ON f_mj_klid=klid')->join('tb_xxxs ON f_mj_xxxsid=xxxsid')->join('tb_zsfw ON f_mj_zsfwid=zsfwid')->join('tb_xz ON f_mj_xzid=xzid')->join('tb_' . $grdo['grdnm'] . '_cls ON f_stdxqcls_clsid=clsid')->join('tb_sex ON f_std_sexid=sexid')->join('tb_rc ON f_std_rcid=rcid')->join('tb_zzmm ON f_std_zzmmid=zzmmid')->join('tb_xl ON f_std_xlid=xlid')->join('tb_stat ON f_std_statid=statid')->join('tb_xq ON f_stdxqcls_xqid=xqid')->where("f_stdxqcls_xqid=" . $_POST['f_cjzx_xqid'] . " AND f_stdxqmj_xqid=" . $_POST['f_cjzx_xqid'] . " AND f_std_statid=5 AND f_std_sttid=" . $_POST['f_cjzx_sttid'] . ' AND f_stdxqcls_clsid=' . $_POST['f_stdxqcls_clsid'])->order('f_mj_bxxsid ASC,mjid ASC,stdno ASC')->select();
$this->assign('stdls', $stdls);
$stdoptu = "<option value=''>无</option>";
foreach ($stdls as $v) {
$stdoptu = $stdoptu . "<option value='" . $v['stdid'] . "'>" . $v['stdno'] . '-' . $v['mjnm'] . '-' . $v['stdnm'] . "</option>";
}
$data['stdoptu'] = $stdoptu;
$data['status'] = 1;
$this->ajaxReturn($data, 'json');
}
function createAlways()
{
$grdid = $_POST['f_std_grdid'];
$grd = M('grd');
$grdo = $grd->where('grdid=' . $grdid)->find();
$cls = M($grdo['grdnm'] . '_cls');
$xq = M('xq');
$xqodq = $xq->where('xqdq=1')->find();
$wherecls = '1=1';
if ($_POST['f_std_sttid']) {
$wherecls = $wherecls . ' AND f_cls_sttid=' . $_POST['f_std_sttid'];
}
if ($_POST['f_std_grdid']) {
$wherecls = $wherecls . ' AND f_cls_grdid=' . $_POST['f_std_grdid'];
}
$clsls = $cls->join('tb_stt ON f_cls_sttid=sttid')->where($wherecls . ' AND clsactvt=1')->order('clsnm ASC')->select();
$clsoptu = "<option value=''>无</option>";
foreach ($clsls as $v) {
$clsoptu = $clsoptu . "<option value='" . $v['clsid'] . "'>[" . $v['sttnm'] . ']' . $v['clsnm'] . "</option>";
}
$data['clsoptu'] = $clsoptu;
if ($_POST['f_std_sttid']) {
import('@.XQ.XQAction');
$xqw = new XQAction();
//外来的学期
$xqls = $xqw->getxqls($grdo['grdid'], $_POST['f_std_sttid'], 'DESC');
} else {
$xq = M('xq');
$xqls = $xq->order('xqnm DESC')->select();
}
$xqoptu = '';
foreach ($xqls as $v) {
if ($v['xqid'] == $xqodq['xqid']) {
$xqoptu = $xqoptu . "<option value='" . $v['xqid'] . "' selected>" . $v['xqnm'] . "</option>";
} else {
$xqoptu = $xqoptu . "<option value='" . $v['xqid'] . "'>" . $v['xqnm'] . "</option>";
}
}
$data['xqoptu'] = $xqoptu;
$data['status'] = 1;
$this->ajaxReturn($data, 'json');
}
function createAlways()
{
$grdid = $_POST['f_pk_grdid'];
$grd = M('grd');
$grdo = $grd->where('grdid=' . $grdid)->find();
//改变的是学期 是课程 是老师
$kc = M($grdo['grdnm'] . '_kc');
$tcr = M('tcr');
$xq = M('xq');
$xqodq = $xq->where('xqdq=1')->find();
$wherekc = '1=1';
$wheretcr = '1=1';
if ($_POST['f_pk_sttid']) {
$wheretcr = $wheretcr . ' AND f_tcr_sttid=' . $_POST['f_pk_sttid'];
}
if ($_POST['f_pk_grdid']) {
$wherekc = $wherekc . ' AND f_kc_grdid=' . $_POST['f_pk_grdid'];
}
$tcrls = $tcr->where($wheretcr)->select();
$kcls = $kc->where($wherekc)->select();
$tcroptu = "<option value=''>无</option>";
foreach ($tcrls as $v) {
$tcroptu = $tcroptu . "<option value='" . $v['tcrid'] . "'>" . $v['tcrnn'] . "</option>";
}
$kcoptu = "<option value=''>无</option>";
foreach ($kcls as $v) {
$kcoptu = $kcoptu . "<option value='" . $v['kcid'] . "'>" . $v['kcnm'] . "</option>";
}
$data['tcroptu'] = $tcroptu;
$data['kcoptu'] = $kcoptu;
if ($_POST['f_pk_sttid']) {
import('@.XQ.XQAction');
$xqw = new XQAction();
//外来的学期
$xqls = $xqw->getxqls($grdo['grdid'], $_POST['f_pk_sttid'], 'DESC');
} else {
$xq = M('xq');
$xqls = $xq->order('xqnm DESC')->select();
}
$xqoptu = '';
foreach ($xqls as $v) {
if ($v['xqid'] == $xqodq['xqid']) {
$xqoptu = $xqoptu . "<option value='" . $v['xqid'] . "' selected >" . $v['xqnm'] . "</option>";
} else {
$xqoptu = $xqoptu . "<option value='" . $v['xqid'] . "'>" . $v['xqnm'] . "</option>";
}
}
$data['xqoptu'] = $xqoptu;
$data['status'] = 1;
$this->ajaxReturn($data, 'json');
}
