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 createAlways() { $grdid = $_POST['f_std_grdid']; $grd = M('grd'); $grdo = $grd->where('grdid=' . $grdid)->find(); $cls = M($grdo['grdnm'] . '_cls'); $mj = M($grdo['grdnm'] . '_mj'); $wherecls = '1=1'; $wheremj = '1=1'; if ($_POST['f_mj_ccid']) { $wheremj = $wheremj . ' AND f_mj_ccid=' . $_POST['f_mj_ccid']; } if ($_POST['f_mj_klid']) { $wheremj = $wheremj . ' AND f_mj_klid=' . $_POST['f_mj_klid']; } if ($_POST['f_mj_xxxsid']) { $wheremj = $wheremj . ' AND f_mj_xxxsid=' . $_POST['f_mj_xxxsid']; } if ($_POST['f_mj_zsfwid']) { $wheremj = $wheremj . ' AND f_mj_zsfwid=' . $_POST['f_mj_zsfwid']; } if ($_POST['f_mj_xzid']) { $wheremj = $wheremj . ' AND f_mj_xzid=' . $_POST['f_mj_xzid']; } if ($_POST['f_std_sttid']) { $wherecls = $wherecls . ' AND f_cls_sttid=' . $_POST['f_std_sttid']; $wheremj = $wheremj . " AND mjsttu LIKE '%-" . $_POST['f_std_sttid'] . "-%'"; } if ($_POST['f_std_grdid']) { $wherecls = $wherecls . ' AND f_cls_grdid=' . $_POST['f_std_grdid']; $wheremj = $wheremj . ' AND f_mj_grdid=' . $_POST['f_std_grdid']; } if ($_POST['f_mj_bxxsid']) { $wheremj = $wheremj . ' AND f_mj_bxxsid=' . $_POST['f_mj_bxxsid']; } $clsls = $cls->join('tb_stt ON f_cls_sttid=sttid')->where($wherecls)->select(); $mjls = $mj->join('tb_bxxs ON f_mj_bxxsid=bxxsid')->where($wheremj)->select(); $clsoptu = "<option value=''>无</option>"; foreach ($clsls as $v) { $clsoptu = $clsoptu . "<option value='" . $v['clsid'] . "'>[" . $v['sttnm'] . ']' . $v['clsnm'] . "</option>"; } $clsoptu = $clsoptu . "<option value='0'>[]未分班</option>"; $mjoptu = "<option value=''>无</option>"; foreach ($mjls as $v) { if (preg_match('/技能/', $v['bxxsnm'])) { $v['bxxsnmst'] = '技能'; } else { if (preg_match('/自考/', $v['bxxsnm'])) { $v['bxxsnmst'] = '自考'; } else { $v['bxxsnmst'] = '普通'; } } $mjoptu = $mjoptu . "<option value='" . $v['mjid'] . "'>[" . $v['bxxsnmst'] . ']' . $v['mjdm'] . $v['mjnm'] . "</option>"; } $data['clsoptu'] = $clsoptu; $data['mjoptu'] = $mjoptu; if ($_POST['stdid'] === '0') { //就是添加的时候比较特殊 import('@.XQ.XQAction'); $xqw = new XQAction(); //外来的学期 $xqls = $xqw->getxqls($grdo['grdid'], $_POST['f_std_sttid'], 'ASC'); $xqoptu = "<option value='" . $xqls[0]['xqid'] . "'>" . $xqls[0]['xqnm'] . "</option>"; } else { 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) { $xqoptu = $xqoptu . "<option value='" . $v['xqid'] . "'>" . $v['xqnm'] . "</option>"; } } $data['xqoptu'] = $xqoptu; //学年要保证比学期大 $xn = M('xn'); $xnls = $xn->where('xnnm>=' . $grdo['grdnm'])->order('xnid DESC')->select(); $xnoptu = ''; foreach ($xnls as $v) { $xnoptu = $xnoptu . "<option value='" . $v['xnid'] . "'>" . $v['xnnm'] . "</option>"; } $data['xnoptu'] = $xnoptu; //连带学年的变化影响到了学期的取值 $xnid = $xnls[0]['xnid']; $sttid = $_POST['f_std_sttid']; //p($xnid);p($sttid);die; import('@.XQ.XQAction'); $xqw = new XQAction(); //外来的学期 $xqid = $xqw->getcwxqid($grdid, $xnid, $sttid); $data['xqid'] = $xqid; //看情况产生学号//看看的 //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(); 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'); }