Example #1
0
 function query()
 {
     header("Content-Type:text/html; charset=utf-8");
     //先给hd设置好些东西,他自身是无法提取的
     import('@.SS.SSAction');
     $ss = new SSAction();
     $ss->setss();
     //鉴权 如果OK的就正常显示,或者出现查看神马的,否则就呵呵了,query he gtxpg两处
     $mdII = M('md');
     $mdo = $mdII->where("mdmk='Cls'")->find();
     import('@.IDTATH.IdtathAction');
     $Idtath = new IdtathAction();
     $Idtath->identify($mdo['mdid'], 'qry');
     import('@.NTF.NTFAction');
     $ntf = new NTFAction();
     $ntf->setntf();
     import('@.KZMB.KZMBAction');
     $kzmb = new KZMBAction();
     $kzmb->setkzmb($mdo['mdid']);
     //鉴权对用户对stt的权限,若为设置权限,说明是教务的人,可以全管,否则只能管自己函授站的 ntf为不用this assign的
     $mdII = M('md');
     $mdo = $mdII->where("mdmk='Stt'")->find();
     import('@.IDTATH.IdtathAction');
     $Idtath = new IdtathAction();
     $athofnstt = $Idtath->identify($mdo['mdid'], 'ntf');
     $usr = M('usr');
     $usro = $usr->where('usrid=' . session('usridss'))->find();
     //NB初始化,开始
     $cdt = $_GET['cdt'];
     $grd = M('grd');
     if (preg_match('/f_cls_grdid/', $cdt)) {
         //获取该键的值
         $tmp = explode('f_cls_grdid', $cdt);
         $tmp = explode('-eq-', $tmp[1]);
         $tmp = explode('-sp-', $tmp[1]);
         $grdid = $tmp[0];
     } else {
         //默认grdid
         $grdo = $grd->order('grdid DESC')->find();
         $grdid = $grdo['grdid'];
     }
     $grdo = $grd->where('grdid=' . $grdid)->find();
     $cls = M($grdo['grdnm'] . '_cls');
     $fldint = '-clsid-sttnm-f_cls_grdid-grdnm-clsnm-clsxhprx-clsactvt-clsxqu-';
     if ($athofnstt['aths'] == 1) {
         $sttidforxq = 1;
         //默认以本部站点为例
         $cdtint = "-sp-f_cls_grdid-eq-" . $grdid . '-sp-';
     } else {
         $sttidforxq = $usro['f_usr_sttid'];
         //默认以用户所在站点为例
         $cdtint = "-sp-f_cls_sttid-eq-" . $usro['f_usr_sttid'] . "-sp-f_cls_grdid-eq-" . $grdid . '-sp-';
     }
     $spccdtint = '-sp-';
     ////
     $odrint = '-clsid ASC-';
     $lmtint = 20;
     $jn = 'tb_stt ON f_cls_sttid=sttid-jn-tb_grd ON f_cls_grdid=grdid';
     //$jn='tb_stt ON f_cls_sttid=sttid-jn-tb_atc ON f_cls_sttid=atcid';//若出现多个join
     import('@.NB.NBAction');
     $NB = new NBAction();
     $arr = $NB->NB($cls, $fldint, $cdtint, $spccdtint, $odrint, $lmtint, $jn);
     ////
     // 		$arr=NB($u,$fldint,$cdtint,$odrint,$lmtint,$jn);
     //适应一些站点用一二三
     import('@.XQ.XQAction');
     $xqw = new XQAction();
     //外来的学期
     //1、0是否化
     $mls = $arr['mls'];
     $mlsfn = array();
     foreach ($mls as $v) {
         if ($v['clsactvt'] == 1) {
             $v['clsactvt'] = '是';
         } else {
             if ($v['clsactvt'] == 0) {
                 $v['clsactvt'] = '否';
             }
         }
         if ($v['clsxqu']) {
             $clsxqu = explode('-', $v['clsxqu']);
             $xqnmu = '';
             for ($i = 1; $i < count($clsxqu) - 1; $i++) {
                 $xqid = $clsxqu[$i];
                 $xqnm = $xqw->getxqnm($grdid, $sttidforxq, $xqid);
                 $xqnmu = $xqnmu . $xqnm . '<br>';
             }
         }
         $v['clsxqu'] = $xqnmu;
         array_push($mlsfn, $v);
     }
     $this->assign('fstrw', $arr['fstrw']);
     $this->assign('sqlstc', $arr['sqlstc']);
     $this->assign('fld', $arr['fld']);
     $this->assign('cdt', $arr['cdt']);
     $this->assign('spccdt', $arr['spccdt']);
     ////
     $this->assign('odr', $arr['odr']);
     $this->assign('lmt', $arr['lmt']);
     $this->assign('count', $arr['count']);
     $this->assign('mls', $mlsfn);
     $this->assign('page_method', $arr['page_method']);
     //NB初始化,结束
     //q特殊
     $stt = M('stt');
     $sttls = $stt->select();
     $this->assign('sttls', $sttls);
     $grd = M('grd');
     $grdls = $grd->select();
     $this->assign('grdls', $grdls);
     //q特殊
     $this->assign('title', '浏览班级列表');
     $this->assign('theme', '班级管理');
     $this->display('query');
 }
Example #2
0
 function gtxpg()
 {
     //先给hd设置好些东西,他自身是无法提取的
     import('@.SS.SSAction');
     $ss = new SSAction();
     $usross = $ss->setss();
     $x = $_GET['x'];
     //鉴权 如果OK的就正常显示,或者出现查看神马的,否则就呵呵了,query he gtxpg两处
     $mdII = M('md');
     $mdo = $mdII->where("mdmk='Std'")->find();
     import('@.IDTATH.IdtathAction');
     $Idtath = new IdtathAction();
     $athofn = $Idtath->identify($mdo['mdid'], $x);
     import('@.NTF.NTFAction');
     $ntf = new NTFAction();
     $ntf->setntf();
     import('@.KZMB.KZMBAction');
     $kzmb = new KZMBAction();
     $kzmb->setkzmb($mdo['mdid']);
     if ($x == 'vw') {
         $grdid = $_GET['grdid'];
         $xqid = $_GET['xqid'];
         $stdid = $_GET['stdid'];
         $grd = M('grd');
         $grdo = $grd->where('grdid=' . $grdid)->find();
         $std = M($grdo['grdnm'] . '_std')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_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');
         $mo = $std->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_dm ON f_stdxqdm_dmid=dmid')->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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_stdxqdm_xqid=" . $xqid . " AND stdid=" . $stdid)->find();
         //给专业多点修饰
         if (preg_match('/技能/', $mo['bxxsnm'])) {
             $mo['bxxsnmst'] = '技能';
         } else {
             if (preg_match('/自考/', $mo['bxxsnm'])) {
                 $mo['bxxsnmst'] = '自考';
             } else {
                 $mo['bxxsnmst'] = '普通';
             }
         }
         //需要看下如果是其他函授站的可以能要第一学期,第二学期,第三学期之类的很BT的东西
         //适应一些站点用一二三
         import('@.XQ.XQAction');
         $xqw = new XQAction();
         //外来的学期
         $xqnm = $xqw->getxqnm($grdid, $mo['f_std_sttid'], $xqid);
         $mo['xqnm'] = $xqnm;
         $this->assign('mo', $mo);
         //搞推荐人
         if ($mo['stdrcmdnm'] || $mo['stdrcmdcp']) {
             $this->assign('ifrcmd', '是');
         } else {
             $this->assign('ifrcmd', '否');
         }
         //所有的注册信息,哪个学期哪个班哪个专业
         //应该具备哪些注册信息
         //学期
         import('@.XQ.XQAction');
         $xqw = new XQAction();
         //外来的学期
         $xqls = $xqw->getxqls($grdid, $mo['f_std_sttid'], 'ASC');
         //年级确定开始,学制确定过程
         $stdxqcls = M($grdo['grdnm'] . '_stdxqcls');
         $stdxqmj = M($grdo['grdnm'] . '_stdxqmj');
         $stdxqdm = M($grdo['grdnm'] . '_stdxqdm');
         for ($i = 0; $i < count($xqls); $i++) {
             $xqid = $xqls[$i]['xqid'];
             if ($stdxqcls->where('f_stdxqcls_stdid=' . $stdid . ' AND f_stdxqcls_xqid=' . $xqid)->find() && $stdxqmj->where('f_stdxqmj_stdid=' . $stdid . ' AND f_stdxqmj_xqid=' . $xqid)->find()) {
                 $xqls[$i]['zcf'] = 'active';
                 //注册否?
                 $xqls[$i]['zczt'] = '已注册';
             } else {
                 $xqls[$i]['zcf'] = 'disabled';
                 $xqls[$i]['zczt'] = '未注册';
             }
             $stdxqclso = $stdxqcls->join('tb_' . $grdo['grdnm'] . '_cls ON f_stdxqcls_clsid=clsid')->where('f_stdxqcls_stdid=' . $stdid . ' AND f_stdxqcls_xqid=' . $xqid)->find();
             $stdxqmjo = $stdxqmj->join('tb_' . $grdo['grdnm'] . '_mj ON f_stdxqmj_mjid=mjid')->where('f_stdxqmj_stdid=' . $stdid . ' AND f_stdxqmj_xqid=' . $xqid)->find();
             $stdxqdmo = $stdxqdm->join('tb_dm ON f_stdxqdm_dmid=dmid')->where('f_stdxqdm_stdid=' . $stdid . ' AND f_stdxqdm_xqid=' . $xqid)->find();
             $xqls[$i]['clsnm'] = $stdxqclso['clsnm'];
             $xqls[$i]['mjnm'] = $stdxqmjo['mjnm'];
             $xqls[$i]['dmnm'] = $stdxqdmo['dmnm'];
         }
         $this->assign('zcls', $xqls);
         //注册列表
         //特殊情况
         $tsqk = M($grdo['grdnm'] . '_tsqk');
         $tsqkls = $tsqk->where('f_tsqk_stdid=' . $stdid)->order('tsqktm DESC')->select();
         $tsqklsnw = array();
         foreach ($tsqkls as $tsqkv) {
             if ($tsqkv['tsqknr'] == 1) {
                 $tsqkv['tsqknr'] = '换状态';
                 $stat = M('stat');
                 //原状态
                 $stato = $stat->where('statid=' . $tsqkv['tsqkorgid'])->find();
                 $tsqkv['tsqkorgid'] = $stato['statnm'];
                 //现状态
                 $stato = $stat->where('statid=' . $tsqkv['tsqknwid'])->find();
                 $tsqkv['tsqknwid'] = $stato['statnm'];
             } else {
                 if ($tsqkv['tsqknr'] == 2) {
                     $tsqkv['tsqknr'] = '换专业';
                     $mj = M($grdo['grdnm'] . '_mj');
                     //原专业
                     $mjo = $mj->where('mjid=' . $tsqkv['tsqkorgid'])->find();
                     $tsqkv['tsqkorgid'] = $stato['mjnm'];
                     //现专业
                     $mjo = $mj->where('mjid=' . $tsqkv['tsqknwid'])->find();
                     $tsqkv['tsqknwid'] = $stato['mjnm'];
                 } else {
                     if ($tsqkv['tsqknr'] == 3) {
                         $tsqkv['tsqknr'] = '换班级';
                         $cls = M($grdo['grdnm'] . '_cls');
                         //原班级
                         $clso = $cls->where('clsid=' . $tsqkv['tsqkorgid'])->find();
                         $tsqkv['tsqkorgid'] = $stato['clsnm'];
                         //现班级
                         $clso = $cls->where('clsid=' . $tsqkv['tsqknwid'])->find();
                         $tsqkv['tsqknwid'] = $stato['clsnm'];
                     } else {
                         if ($tsqkv['tsqknr'] == 4) {
                             $tsqkv['tsqknr'] = '换寝室';
                             $dm = M('dm');
                             //原状态
                             $dmo = $dm->where('dmid=' . $tsqkv['tsqkorgid'])->find();
                             $tsqkv['tsqkorgid'] = $dmo['dmnm'];
                             //现状态
                             $dmo = $dm->where('dmid=' . $tsqkv['tsqknwid'])->find();
                             $tsqkv['tsqknwid'] = $dmo['dmnm'];
                         }
                     }
                 }
             }
             array_push($tsqklsnw, $tsqkv);
         }
         $this->assign('tsqkls', $tsqklsnw);
         $this->assign('title', '查看');
         $this->assign('theme', '查看详细');
         $this->display('view');
     } else {
         if ($x == 'updt') {
             $grdid = $_GET['grdid'];
             $xqid = $_GET['xqid'];
             $stdid = $_GET['stdid'];
             $usr = M('usr');
             $usro = $usr->where('usrid=' . session('usridss'))->find();
             //鉴权对用户对stt的权限,若为设置权限,说明是教务的人,可以全管,否则只能管自己函授站的 ntf为不用this assign的
             $mdII = M('md');
             $mdo = $mdII->where("mdmk='Stt'")->find();
             import('@.IDTATH.IdtathAction');
             $Idtath = new IdtathAction();
             $athofnstt = $Idtath->identify($mdo['mdid'], 'ntf');
             if ($stdid == 0) {
                 $mo['stdid'] = 0;
                 $mo['stdsol'] = '无';
                 $mo['stdpt'] = C('PUBLIC') . '/IMG/default.jpg';
                 //第几学年 第几学期的班级 第几学年 第几学期的专业 ...
                 //因为grd无法定下来,所以stdxqcls stdxqmj_xqid 定下来也没有意义,干脆就不定了,等搜索时候自由分晓
                 //默认年级是当前年级
                 $grd = M('grd');
                 $grdo = $grd->order('grdnm DESC')->find();
                 $grdid = $grdo['grdid'];
                 $mo['f_std_grdid'] = $grdid;
                 $mo['grdnm'] = $grdo['grdnm'];
                 //默认站点,有主的找有主的,没主的找本部
                 if ($athofnstt['aths'] != 1) {
                     $mo['f_std_sttid'] = $usro['f_usr_sttid'];
                 } else {
                     $mo['f_std_sttid'] = 1;
                 }
                 //默认学期 为XX年级XX站点的起始学期
                 $sttintxq = M($grdo['grdnm'] . '_sttintxq');
                 $sttintxqo = $sttintxq->where('f_sttintxq_grdid=' . $grdo['grdid'] . ' AND f_sttintxq_sttid=' . $mo['f_std_sttid'])->find();
                 $xqid = $sttintxqo['f_sttintxq_xqid'];
                 $mo['f_stdxqcls_xqid'] = $xqid;
                 $mo['f_stdxqmj_xqid'] = $xqid;
                 $this->assign('title', '添加');
                 $this->assign('theme', '添加:');
                 $this->assign('btnvl', '添加');
                 //q特殊
                 $xq = M('xq');
                 $xqls = $xq->where('xqid=' . $xqid)->select();
                 //我TMD就为了一个置顶的xq来了
                 $this->assign('xqls', $xqls);
                 $where = '1=1';
                 if ($athofnstt['aths'] != 1) {
                     $where = $where . ' AND f_cls_sttid=' . $usro['f_usr_sttid'];
                 }
                 //之前已经确定过到底是看哪个年级
                 $where = $where . ' AND f_cls_grdid=' . $grdid;
                 $cls = M($grdo['grdnm'] . '_cls');
                 $clsls = $cls->join('tb_stt ON f_cls_sttid=sttid')->where($where)->order('clsnm ASC')->select();
                 $this->assign('clsls', $clsls);
                 $where = '1=1';
                 if ($athofnstt['aths'] != 1) {
                     $where = $where . " AND mjsttu LIKE '%-" . $usro['f_usr_sttid'] . "-%'";
                 }
                 //之前已经确定过到底是看哪个年级
                 $where = $where . ' AND f_mj_grdid=' . $grdid;
                 $mj = M($grdo['grdnm'] . '_mj');
                 $mjls = $mj->join('tb_bxxs ON f_mj_bxxsid=bxxsid')->where($where)->order('f_mj_bxxsid ASC,mjdm ASC')->select();
                 $mjlsnw = array();
                 foreach ($mjls as $v) {
                     //给专业多点修饰
                     if (preg_match('/技能/', $v['bxxsnm'])) {
                         $v['bxxsnmst'] = '技能';
                     } else {
                         if (preg_match('/自考/', $v['bxxsnm'])) {
                             $v['bxxsnmst'] = '自考';
                         } else {
                             $v['bxxsnmst'] = '普通';
                         }
                     }
                     array_push($mjlsnw, $v);
                 }
                 $this->assign('mjls', $mjlsnw);
             } else {
                 $grd = M('grd');
                 $grdo = $grd->where('grdid=' . $grdid)->find();
                 $std = M($grdo['grdnm'] . '_std')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_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');
                 $mo = $std->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_dm ON f_stdxqdm_dmid=dmid')->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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_stdxqdm_xqid=" . $xqid . " AND stdid=" . $stdid)->find();
                 $this->assign('title', '修改');
                 $this->assign('theme', '修改:');
                 $this->assign('btnvl', '修改');
                 //q特殊
                 import('@.XQ.XQAction');
                 $xqw = new XQAction();
                 //外来的学期
                 $xqls = $xqw->getxqls($grdo['grdid'], $mo['f_std_sttid'], 'DESC');
                 $this->assign('xqls', $xqls);
                 $where = '1=1';
                 $where = $where . ' AND f_cls_sttid=' . $mo['f_std_sttid'];
                 //之前已经确定过到底是看哪个年级
                 $where = $where . ' AND f_cls_grdid=' . $grdid;
                 $cls = M($grdo['grdnm'] . '_cls');
                 $clsls = $cls->join('tb_stt ON f_cls_sttid=sttid')->where($where)->order('clsnm ASC')->select();
                 $this->assign('clsls', $clsls);
                 $where = '1=1';
                 $where = $where . " AND mjsttu LIKE '%-" . $mo['f_std_sttid'] . "-%' AND f_mj_bxxsid=" . $mo['f_mj_bxxsid'];
                 //之前已经确定过到底是看哪个年级
                 $where = $where . ' AND f_mj_grdid=' . $grdid;
                 $mj = M($grdo['grdnm'] . '_mj');
                 $mjls = $mj->join('tb_bxxs ON f_mj_bxxsid=bxxsid')->where($where)->order('f_mj_bxxsid ASC,mjdm ASC')->select();
                 $mjlsnw = array();
                 foreach ($mjls as $v) {
                     //给专业多点修饰
                     if (preg_match('/技能/', $v['bxxsnm'])) {
                         $v['bxxsnmst'] = '技能';
                     } else {
                         if (preg_match('/自考/', $v['bxxsnm'])) {
                             $v['bxxsnmst'] = '自考';
                         } else {
                             $v['bxxsnmst'] = '普通';
                         }
                     }
                     array_push($mjlsnw, $v);
                 }
                 $this->assign('mjls', $mjlsnw);
                 //所有的注册信息,哪个学期哪个班哪个专业
                 //应该具备哪些注册信息
                 //学期
                 import('@.XQ.XQAction');
                 $xqw = new XQAction();
                 //外来的学期
                 $xqls = $xqw->getxqls($grdid, $mo['f_std_sttid'], 'ASC');
                 //年级确定开始,学制确定过程
                 $stdxqcls = M($grdo['grdnm'] . '_stdxqcls');
                 $stdxqmj = M($grdo['grdnm'] . '_stdxqmj');
                 $stdxqdm = M($grdo['grdnm'] . '_stdxqdm');
                 for ($i = 0; $i < count($xqls); $i++) {
                     $xqid = $xqls[$i]['xqid'];
                     if ($stdxqcls->where('f_stdxqcls_stdid=' . $stdid . ' AND f_stdxqcls_xqid=' . $xqid)->find() && $stdxqmj->where('f_stdxqmj_stdid=' . $stdid . ' AND f_stdxqmj_xqid=' . $xqid)->find()) {
                         $xqls[$i]['zcf'] = 'active';
                         //注册否?
                         $xqls[$i]['zczt'] = '已注册';
                     } else {
                         $xqls[$i]['zcf'] = 'disabled';
                         $xqls[$i]['zczt'] = '未注册';
                     }
                     $stdxqclso = $stdxqcls->join('tb_' . $grdo['grdnm'] . '_cls ON f_stdxqcls_clsid=clsid')->where('f_stdxqcls_stdid=' . $stdid . ' AND f_stdxqcls_xqid=' . $xqid)->find();
                     $stdxqmjo = $stdxqmj->join('tb_' . $grdo['grdnm'] . '_mj ON f_stdxqmj_mjid=mjid')->where('f_stdxqmj_stdid=' . $stdid . ' AND f_stdxqmj_xqid=' . $xqid)->find();
                     $stdxqdmo = $stdxqdm->join('tb_dm ON f_stdxqdm_dmid=dmid')->where('f_stdxqdm_stdid=' . $stdid . ' AND f_stdxqdm_xqid=' . $xqid)->find();
                     $xqls[$i]['clsnm'] = $stdxqclso['clsnm'];
                     $xqls[$i]['mjnm'] = $stdxqmjo['mjnm'];
                     $xqls[$i]['dmnm'] = $stdxqdmo['dmnm'];
                 }
                 $this->assign('zcls', $xqls);
                 //注册列表
                 //特殊情况
                 $tsqk = M($grdo['grdnm'] . '_tsqk');
                 $tsqkls = $tsqk->where('f_tsqk_stdid=' . $stdid)->order('tsqktm DESC')->select();
                 $tsqklsnw = array();
                 foreach ($tsqkls as $tsqkv) {
                     if ($tsqkv['tsqknr'] == 1) {
                         $tsqkv['tsqknr'] = '换状态';
                         $stat = M('stat');
                         //原状态
                         $stato = $stat->where('statid=' . $tsqkv['tsqkorgid'])->find();
                         $tsqkv['tsqkorgid'] = $stato['statnm'];
                         //现状态
                         $stato = $stat->where('statid=' . $tsqkv['tsqknwid'])->find();
                         $tsqkv['tsqknwid'] = $stato['statnm'];
                     } else {
                         if ($tsqkv['tsqknr'] == 2) {
                             $tsqkv['tsqknr'] = '换专业';
                             $mj = M($grdo['grdnm'] . '_mj');
                             //原专业
                             $mjo = $mj->where('mjid=' . $tsqkv['tsqkorgid'])->find();
                             $tsqkv['tsqkorgid'] = $stato['mjnm'];
                             //现专业
                             $mjo = $mj->where('mjid=' . $tsqkv['tsqknwid'])->find();
                             $tsqkv['tsqknwid'] = $stato['mjnm'];
                         } else {
                             if ($tsqkv['tsqknr'] == 3) {
                                 $tsqkv['tsqknr'] = '换班级';
                                 $cls = M($grdo['grdnm'] . '_cls');
                                 //原班级
                                 $clso = $cls->where('clsid=' . $tsqkv['tsqkorgid'])->find();
                                 $tsqkv['tsqkorgid'] = $stato['clsnm'];
                                 //现班级
                                 $clso = $cls->where('clsid=' . $tsqkv['tsqknwid'])->find();
                                 $tsqkv['tsqknwid'] = $stato['clsnm'];
                             } else {
                                 if ($tsqkv['tsqknr'] == 4) {
                                     $tsqkv['tsqknr'] = '换寝室';
                                     $dm = M('dm');
                                     //原状态
                                     $dmo = $dm->where('dmid=' . $tsqkv['tsqkorgid'])->find();
                                     $tsqkv['tsqkorgid'] = $dmo['dmnm'];
                                     //现状态
                                     $dmo = $dm->where('dmid=' . $tsqkv['tsqknwid'])->find();
                                     $tsqkv['tsqknwid'] = $dmo['dmnm'];
                                 }
                             }
                         }
                     }
                     array_push($tsqklsnw, $tsqkv);
                 }
                 $this->assign('tsqkls', $tsqklsnw);
             }
             // 			//搞学生照片
             // 			if(file_exists('./Uploads/std/'.$grdo['grdnm'].'/'.$mo['f_std_sttid'].'/'.$mo['stdno'].'.jpg')){
             // 				$mo['stdpt']=__ROOT__.'/Uploads/std/'.$grdo['grdnm'].'/'.$mo['f_std_sttid'].'/'.$mo['stdno'].'.jpg';
             // 			}else{
             // 				$mo['stdpt']=C('PUBLIC').'/IMG/default.jpg';
             // 			}
             $this->assign('mo', $mo);
             //q特殊
             $bxxs = M('bxxs');
             $bxxsls = $bxxs->select();
             $this->assign('bxxsls', $bxxsls);
             //q特殊
             $where = '1=1';
             if ($athofnstt['aths'] != 1) {
                 $where = $where . ' AND sttid=' . $usro['f_usr_sttid'];
             }
             $stt = M('stt');
             $sttls = $stt->where($where)->select();
             $this->assign('sttls', $sttls);
             //q特殊
             $cc = M('cc');
             $ccls = $cc->select();
             $this->assign('ccls', $ccls);
             //q特殊
             $kl = M('kl');
             $klls = $kl->select();
             $this->assign('klls', $klls);
             //q特殊
             $xxxs = M('xxxs');
             $xxxsls = $xxxs->select();
             $this->assign('xxxsls', $xxxsls);
             //q特殊
             $zsfw = M('zsfw');
             $zsfwls = $zsfw->select();
             $this->assign('zsfwls', $zsfwls);
             //q特殊
             $xz = M('xz');
             $xzls = $xz->select();
             $this->assign('xzls', $xzls);
             //q特殊
             $grd = M('grd');
             $grdls = $grd->order('grdnm DESC')->select();
             $this->assign('grdls', $grdls);
             $dm = M('dm');
             $dmls = $dm->select();
             $this->assign('dmls', $dmls);
             //q特殊
             $sex = M('sex');
             $sexls = $sex->select();
             $this->assign('sexls', $sexls);
             //q特殊
             $rc = M('rc');
             $rcls = $rc->select();
             $this->assign('rcls', $rcls);
             //q特殊
             $zzmm = M('zzmm');
             $zzmmls = $zzmm->select();
             $this->assign('zzmmls', $zzmmls);
             //q特殊
             $xl = M('xl');
             $xlls = $xl->select();
             $this->assign('xlls', $xlls);
             //q特殊
             $stat = M('stat');
             $statls = $stat->where("statactvt=1 AND statmk='jw'")->select();
             $this->assign('statls', $statls);
             //搞介绍人
             if ($mo['stdrcmdnm'] || $mo['stdrcmdcp']) {
                 $this->assign('ifrcmd', '是');
                 $this->assign('rcmdcls', '');
             } else {
                 $this->assign('ifrcmd', '否');
                 $this->assign('rcmdcls', 'readonly');
             }
             $this->display('update');
         } else {
             if ($x == 'mdf') {
                 $grdid = $_GET['grdid'];
                 $xqid = $_GET['xqid'];
                 $stdid = $_GET['stdid'];
                 $usr = M('usr');
                 $usro = $usr->where('usrid=' . session('usridss'))->find();
                 //鉴权对用户对stt的权限,若为设置权限,说明是教务的人,可以全管,否则只能管自己函授站的 ntf为不用this assign的
                 $mdII = M('md');
                 $mdo = $mdII->where("mdmk='Stt'")->find();
                 import('@.IDTATH.IdtathAction');
                 $Idtath = new IdtathAction();
                 $athofnstt = $Idtath->identify($mdo['mdid'], 'ntf');
                 $grd = M('grd');
                 $grdo = $grd->where('grdid=' . $grdid)->find();
                 $std = M($grdo['grdnm'] . '_std')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_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');
                 $mo = $std->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_dm ON f_stdxqdm_dmid=dmid')->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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_stdxqdm_xqid=" . $xqid . " AND stdid=" . $stdid)->find();
                 $this->assign('title', '修改');
                 $this->assign('theme', '修改:');
                 $this->assign('btnvl', '修改');
                 //q特殊
                 import('@.XQ.XQAction');
                 $xqw = new XQAction();
                 //外来的学期
                 $xqls = $xqw->getxqls($grdo['grdid'], $mo['f_std_sttid'], 'DESC');
                 $this->assign('xqls', $xqls);
                 $where = '1=1';
                 $where = $where . ' AND f_cls_sttid=' . $mo['f_std_sttid'];
                 //之前已经确定过到底是看哪个年级
                 $where = $where . ' AND f_cls_grdid=' . $grdid;
                 $cls = M($grdo['grdnm'] . '_cls');
                 $clsls = $cls->join('tb_stt ON f_cls_sttid=sttid')->where($where)->order('clsnm ASC')->select();
                 $this->assign('clsls', $clsls);
                 $where = '1=1';
                 $where = $where . " AND mjsttu LIKE '%-" . $mo['f_std_sttid'] . "-%' AND f_mj_bxxsid=" . $mo['f_mj_bxxsid'];
                 //之前已经确定过到底是看哪个年级
                 $where = $where . ' AND f_mj_grdid=' . $grdid;
                 $mj = M($grdo['grdnm'] . '_mj');
                 $mjls = $mj->join('tb_bxxs ON f_mj_bxxsid=bxxsid')->where($where)->order('f_mj_bxxsid ASC,mjdm ASC')->select();
                 $mjlsnw = array();
                 foreach ($mjls as $v) {
                     //给专业多点修饰
                     if (preg_match('/技能/', $v['bxxsnm'])) {
                         $v['bxxsnmst'] = '技能';
                     } else {
                         if (preg_match('/自考/', $v['bxxsnm'])) {
                             $v['bxxsnmst'] = '自考';
                         } else {
                             $v['bxxsnmst'] = '普通';
                         }
                     }
                     array_push($mjlsnw, $v);
                 }
                 $this->assign('mjls', $mjlsnw);
                 //所有的注册信息,哪个学期哪个班哪个专业
                 //应该具备哪些注册信息
                 //学期
                 import('@.XQ.XQAction');
                 $xqw = new XQAction();
                 //外来的学期
                 $xqls = $xqw->getxqls($grdid, $mo['f_std_sttid'], 'ASC');
                 //年级确定开始,学制确定过程
                 $stdxqcls = M($grdo['grdnm'] . '_stdxqcls');
                 $stdxqmj = M($grdo['grdnm'] . '_stdxqmj');
                 $stdxqdm = M($grdo['grdnm'] . '_stdxqdm');
                 for ($i = 0; $i < count($xqls); $i++) {
                     $xqid = $xqls[$i]['xqid'];
                     if ($stdxqcls->where('f_stdxqcls_stdid=' . $stdid . ' AND f_stdxqcls_xqid=' . $xqid)->find() && $stdxqmj->where('f_stdxqmj_stdid=' . $stdid . ' AND f_stdxqmj_xqid=' . $xqid)->find()) {
                         $xqls[$i]['zcf'] = 'active';
                         //注册否?
                         $xqls[$i]['zczt'] = '已注册';
                     } else {
                         $xqls[$i]['zcf'] = 'disabled';
                         $xqls[$i]['zczt'] = '未注册';
                     }
                     $stdxqclso = $stdxqcls->join('tb_' . $grdo['grdnm'] . '_cls ON f_stdxqcls_clsid=clsid')->where('f_stdxqcls_stdid=' . $stdid . ' AND f_stdxqcls_xqid=' . $xqid)->find();
                     $stdxqmjo = $stdxqmj->join('tb_' . $grdo['grdnm'] . '_mj ON f_stdxqmj_mjid=mjid')->where('f_stdxqmj_stdid=' . $stdid . ' AND f_stdxqmj_xqid=' . $xqid)->find();
                     $stdxqdmo = $stdxqdm->join('tb_dm ON f_stdxqdm_dmid=dmid')->where('f_stdxqdm_stdid=' . $stdid . ' AND f_stdxqdm_xqid=' . $xqid)->find();
                     $xqls[$i]['clsnm'] = $stdxqclso['clsnm'];
                     $xqls[$i]['mjnm'] = $stdxqmjo['mjnm'];
                     $xqls[$i]['dmnm'] = $stdxqdmo['dmnm'];
                 }
                 $this->assign('zcls', $xqls);
                 //注册列表
                 //特殊情况
                 $tsqk = M($grdo['grdnm'] . '_tsqk');
                 $tsqkls = $tsqk->where('f_tsqk_stdid=' . $stdid)->order('tsqktm DESC')->select();
                 $tsqklsnw = array();
                 foreach ($tsqkls as $tsqkv) {
                     if ($tsqkv['tsqknr'] == 1) {
                         $tsqkv['tsqknr'] = '换状态';
                         $stat = M('stat');
                         //原状态
                         $stato = $stat->where('statid=' . $tsqkv['tsqkorgid'])->find();
                         $tsqkv['tsqkorgid'] = $stato['statnm'];
                         //现状态
                         $stato = $stat->where('statid=' . $tsqkv['tsqknwid'])->find();
                         $tsqkv['tsqknwid'] = $stato['statnm'];
                     } else {
                         if ($tsqkv['tsqknr'] == 2) {
                             $tsqkv['tsqknr'] = '换专业';
                             $mj = M($grdo['grdnm'] . '_mj');
                             //原专业
                             $mjo = $mj->where('mjid=' . $tsqkv['tsqkorgid'])->find();
                             $tsqkv['tsqkorgid'] = $stato['mjnm'];
                             //现专业
                             $mjo = $mj->where('mjid=' . $tsqkv['tsqknwid'])->find();
                             $tsqkv['tsqknwid'] = $stato['mjnm'];
                         } else {
                             if ($tsqkv['tsqknr'] == 3) {
                                 $tsqkv['tsqknr'] = '换班级';
                                 $cls = M($grdo['grdnm'] . '_cls');
                                 //原班级
                                 $clso = $cls->where('clsid=' . $tsqkv['tsqkorgid'])->find();
                                 $tsqkv['tsqkorgid'] = $stato['clsnm'];
                                 //现班级
                                 $clso = $cls->where('clsid=' . $tsqkv['tsqknwid'])->find();
                                 $tsqkv['tsqknwid'] = $stato['clsnm'];
                             } else {
                                 if ($tsqkv['tsqknr'] == 4) {
                                     $tsqkv['tsqknr'] = '换寝室';
                                     $dm = M('dm');
                                     //原状态
                                     $dmo = $dm->where('dmid=' . $tsqkv['tsqkorgid'])->find();
                                     $tsqkv['tsqkorgid'] = $dmo['dmnm'];
                                     //现状态
                                     $dmo = $dm->where('dmid=' . $tsqkv['tsqknwid'])->find();
                                     $tsqkv['tsqknwid'] = $dmo['dmnm'];
                                 }
                             }
                         }
                     }
                     array_push($tsqklsnw, $tsqkv);
                 }
                 $this->assign('tsqkls', $tsqklsnw);
                 // 			//搞学生照片
                 // 			if(file_exists('./Uploads/std/'.$grdo['grdnm'].'/'.$mo['f_std_sttid'].'/'.$mo['stdno'].'.jpg')){
                 // 				$mo['stdpt']=__ROOT__.'/Uploads/std/'.$grdo['grdnm'].'/'.$mo['f_std_sttid'].'/'.$mo['stdno'].'.jpg';
                 // 			}else{
                 // 				$mo['stdpt']=C('PUBLIC').'/IMG/default.jpg';
                 // 			}
                 $this->assign('mo', $mo);
                 //q特殊
                 $bxxs = M('bxxs');
                 $bxxsls = $bxxs->select();
                 $this->assign('bxxsls', $bxxsls);
                 //q特殊
                 $where = '1=1';
                 if ($athofnstt['aths'] != 1) {
                     $where = $where . ' AND sttid=' . $usro['f_usr_sttid'];
                 }
                 $stt = M('stt');
                 $sttls = $stt->where($where)->select();
                 $this->assign('sttls', $sttls);
                 //q特殊
                 $cc = M('cc');
                 $ccls = $cc->select();
                 $this->assign('ccls', $ccls);
                 //q特殊
                 $kl = M('kl');
                 $klls = $kl->select();
                 $this->assign('klls', $klls);
                 //q特殊
                 $xxxs = M('xxxs');
                 $xxxsls = $xxxs->select();
                 $this->assign('xxxsls', $xxxsls);
                 //q特殊
                 $zsfw = M('zsfw');
                 $zsfwls = $zsfw->select();
                 $this->assign('zsfwls', $zsfwls);
                 //q特殊
                 $xz = M('xz');
                 $xzls = $xz->select();
                 $this->assign('xzls', $xzls);
                 //q特殊
                 $grd = M('grd');
                 $grdls = $grd->order('grdnm DESC')->select();
                 $this->assign('grdls', $grdls);
                 $dm = M('dm');
                 $dmls = $dm->select();
                 $this->assign('dmls', $dmls);
                 //q特殊
                 $sex = M('sex');
                 $sexls = $sex->select();
                 $this->assign('sexls', $sexls);
                 //q特殊
                 $rc = M('rc');
                 $rcls = $rc->select();
                 $this->assign('rcls', $rcls);
                 //q特殊
                 $zzmm = M('zzmm');
                 $zzmmls = $zzmm->select();
                 $this->assign('zzmmls', $zzmmls);
                 //q特殊
                 $xl = M('xl');
                 $xlls = $xl->select();
                 $this->assign('xlls', $xlls);
                 //q特殊
                 $stat = M('stat');
                 $statls = $stat->where("statactvt=1 AND statmk='jw'")->select();
                 $this->assign('statls', $statls);
                 //搞介绍人
                 if ($mo['stdrcmdnm'] || $mo['stdrcmdcp']) {
                     $this->assign('ifrcmd', '是');
                     $this->assign('rcmdcls', '');
                 } else {
                     $this->assign('ifrcmd', '否');
                     $this->assign('rcmdcls', 'readonly');
                 }
                 $this->display('update');
             } else {
                 if ($x = 'stddtfx') {
                     $xq = M('xq');
                     $xqodq = $xq->where('xqdq=1')->find();
                     $xqiddq = $xqodq['xqid'];
                     $sttid = 1;
                     $bxxs = M('bxxs');
                     $bxxsls = $bxxs->select();
                     $dm = M('dm');
                     $dmls = $dm->select();
                     //先分开算再合起来
                     $grd = M('grd');
                     $grdls = $grd->order('grdnm DESC')->select();
                     $grdlsfn = array();
                     foreach ($grdls as $grdv) {
                         $zl = array();
                         //资料
                         $cls = M($grdv['grdnm'] . '_cls');
                         $clsls = $cls->where('clsactvt=1 AND f_cls_sttid=' . $sttid)->order('clsnm ASC')->select();
                         $mj = M($grdv['grdnm'] . '_mj');
                         $mjls = $mj->join('tb_bxxs ON f_mj_bxxsid=bxxsid')->where("mjsttu LIKE '%-" . $sttid . "-%'")->order('bxxsid ASC,mjnm ASC')->select();
                         $std = M($grdv['grdnm'] . '_std');
                         if ($std->where('f_std_statid=5')->count() == 0) {
                             continue;
                         }
                         $zongnb = $std->where('f_std_statid=5')->count();
                         $zl['zongnb'] = $zongnb;
                         $bynb = $std->where('f_std_statid=5 AND f_std_sexid=1')->count();
                         $zl['bynb'] = $bynb;
                         $glnb = $std->where('f_std_statid=5 AND f_std_sexid=2')->count();
                         $zl['glnb'] = $glnb;
                         //查看办学形式
                         $bxxsarr = array();
                         foreach ($bxxsls as $bxxsv) {
                             $bxxscnt = $std->join('inner join tb_' . $grdv['grdnm'] . '_stdxqcls ON stdid=f_stdxqcls_stdid')->join('inner join tb_' . $grdv['grdnm'] . '_stdxqmj ON stdid=f_stdxqmj_stdid')->join('tb_' . $grdv['grdnm'] . '_mj ON f_stdxqmj_mjid=mjid')->where("f_stdxqcls_xqid=" . $xqiddq . " AND f_stdxqmj_xqid=" . $xqiddq . ' AND f_mj_bxxsid=' . $bxxsv['bxxsid'] . ' AND f_std_statid=5')->count();
                             if ($bxxscnt == 0) {
                                 continue;
                             }
                             $bxxsv['bxxscnt'] = $bxxscnt;
                             array_push($bxxsarr, $bxxsv);
                         }
                         $zl['bxxs'] = $bxxsarr;
                         //查看住宿
                         $dmarr = array();
                         foreach ($dmls as $dmv) {
                             $dmcnt = $std->join('inner join tb_' . $grdv['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_stdid')->where("f_stdxqdm_xqid=" . $xqiddq . ' AND f_stdxqdm_dmid=' . $dmv['dmid'] . ' AND f_std_statid=5')->count();
                             if ($dmcnt == 0) {
                                 continue;
                             }
                             $dmv['dmcnt'] = $dmcnt;
                             array_push($dmarr, $dmv);
                         }
                         $zl['dm'] = $dmarr;
                         //查看港澳台西藏
                         $hknb = $std->where("stdnp LIKE '%香港%' AND f_std_statid=5")->count();
                         $zl['hknb'] = $hknb;
                         $mcnb = $std->where("stdnp LIKE '%澳门%' AND f_std_statid=5")->count();
                         $zl['mcnb'] = $mcnb;
                         $twnb = $std->where("stdnp LIKE '%台湾%' AND f_std_statid=5")->count();
                         $zl['twnb'] = $twnb;
                         $tbnb = $std->where("stdnp LIKE '%西藏%' AND f_std_statid=5")->count();
                         $zl['tbnb'] = $tbnb;
                         $otnb = $std->where("stdnp NOT LIKE '%香港%' AND stdnp NOT LIKE '%澳门%' AND stdnp NOT LIKE '%台湾%' AND stdnp NOT LIKE '%西藏%' AND f_std_statid=5")->count();
                         $zl['otnb'] = $otnb;
                         //查看班级
                         $clsarr = array();
                         foreach ($clsls as $clsv) {
                             $clscnt = $std->join('inner join tb_' . $grdv['grdnm'] . '_stdxqcls ON stdid=f_stdxqcls_stdid')->join('inner join tb_' . $grdv['grdnm'] . '_stdxqmj ON stdid=f_stdxqmj_stdid')->join('tb_' . $grdv['grdnm'] . '_cls ON f_stdxqcls_clsid=clsid')->where("f_stdxqcls_xqid=" . $xqiddq . " AND f_stdxqmj_xqid=" . $xqiddq . ' AND f_stdxqcls_clsid=' . $clsv['clsid'] . ' AND f_std_statid=5')->count();
                             if ($clscnt == 0) {
                                 continue;
                             }
                             $clsv['clscnt'] = $clscnt;
                             array_push($clsarr, $clsv);
                         }
                         $zl['cls'] = $clsarr;
                         //查看专业
                         $mjarr = array();
                         foreach ($mjls as $mjv) {
                             $mjcnt = $std->join('inner join tb_' . $grdv['grdnm'] . '_stdxqcls ON stdid=f_stdxqcls_stdid')->join('inner join tb_' . $grdv['grdnm'] . '_stdxqmj ON stdid=f_stdxqmj_stdid')->join('tb_' . $grdv['grdnm'] . '_mj ON f_stdxqmj_mjid=mjid')->where("f_stdxqcls_xqid=" . $xqiddq . " AND f_stdxqmj_xqid=" . $xqiddq . ' AND f_stdxqmj_mjid=' . $mjv['mjid'] . ' AND f_std_statid=5')->count();
                             if ($mjcnt == 0) {
                                 continue;
                             }
                             $mjv['clscnt'] = $mjcnt;
                             array_push($mjarr, $mjv);
                         }
                         $zl['mj'] = $mjarr;
                         $grdv['zl'] = $zl;
                         array_push($grdlsfn, $grdv);
                     }
                     $this->assign('grdls', $grdlsfn);
                     $this->assign('title', '学生数据分析');
                     $this->assign('theme', '学生数据分析详细');
                     $this->display('stddtfx');
                 }
             }
         }
     }
 }
Example #3
0
 function gtxpg()
 {
     //先给hd设置好些东西,他自身是无法提取的
     import('@.SS.SSAction');
     $ss = new SSAction();
     $ss->setss();
     $x = $_GET['x'];
     //鉴权 如果OK的就正常显示,或者出现查看神马的,否则就呵呵了,query he gtxpg两处
     $mdII = M('md');
     $mdo = $mdII->where("mdmk='Zsstd'")->find();
     import('@.IDTATH.IdtathAction');
     $Idtath = new IdtathAction();
     $athofn = $Idtath->identify($mdo['mdid'], $x);
     import('@.NTF.NTFAction');
     $ntf = new NTFAction();
     $ntf->setntf();
     import('@.KZMB.KZMBAction');
     $kzmb = new KZMBAction();
     $kzmb->setkzmb($mdo['mdid']);
     $zssz = M('zssz');
     $zsszo = $zssz->find();
     $grdid = $zsszo['f_zssz_grdid'];
     $xqid = $zsszo['f_zssz_xqid'];
     $sttid = 1;
     if ($x == 'vw') {
         $stdid = $_GET['stdid'];
         $grd = M('grd');
         $grdo = $grd->where('grdid=' . $grdid)->find();
         $std = M($grdo['grdnm'] . '_std')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_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');
         $mo = $std->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_dm ON f_stdxqdm_dmid=dmid')->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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_stdxqdm_xqid=" . $xqid . " AND stdid=" . $stdid)->find();
         //给专业多点修饰
         if (preg_match('/技能/', $mo['bxxsnm'])) {
             $mo['bxxsnmst'] = '技能';
         } else {
             if (preg_match('/自考/', $mo['bxxsnm'])) {
                 $mo['bxxsnmst'] = '自考';
             } else {
                 $mo['bxxsnmst'] = '普通';
             }
         }
         //需要看下如果是其他函授站的可以能要第一学期,第二学期,第三学期之类的很BT的东西
         //适应一些站点用一二三
         import('@.XQ.XQAction');
         $xqw = new XQAction();
         //外来的学期
         $xqnm = $xqw->getxqnm($grdid, $mo['f_std_sttid'], $xqid);
         $mo['xqnm'] = $xqnm;
         if ($athofn['aths'] == 1) {
             //aths==1说明是教务的人或者是管理员
             $mo['mdf'] = 1;
         } else {
             $mo['mdf'] = 0;
         }
         $this->assign('mo', $mo);
         //搞推荐人
         if ($mo['stdrcmdnm'] || $mo['stdrcmdcp']) {
             $this->assign('ifrcmd', '是');
         } else {
             $this->assign('ifrcmd', '否');
         }
         //特殊情况
         $tsqk = M($grdo['grdnm'] . '_tsqk');
         $tsqkls = $tsqk->where('f_tsqk_stdid=' . $stdid)->order('tsqktm DESC')->select();
         $this->assign('tsqkls', $tsqkls);
         $this->assign('title', '查看');
         $this->assign('theme', '查看详细');
         $this->display('view');
     } else {
         if ($x == 'updt') {
             $stdid = $_GET['stdid'];
             if ($stdid == 0) {
                 $mo['stdid'] = 0;
                 $mo['stdsol'] = '无';
                 $mo['stdpt'] = C('PUBLIC') . '/IMG/default.jpg';
                 //第几学年 第几学期的班级 第几学年 第几学期的专业 ...
                 //因为grd无法定下来,所以stdxqcls stdxqmj_xqid 定下来也没有意义,干脆就不定了,等搜索时候自由分晓
                 //默认年级是当前年级
                 $grd = M('grd');
                 $grdo = $grd->where('grdid=' . $grdid)->find();
                 $mo['f_std_grdid'] = $grdid;
                 $mo['grdnm'] = $grdo['grdnm'];
                 //默认站点,有主的找有主的,没主的找本部
                 $mo['f_std_sttid'] = 1;
                 //默认学期 为XX年级XX站点的起始学期
                 $mo['f_stdxqcls_xqid'] = $xqid;
                 $mo['f_stdxqmj_xqid'] = $xqid;
                 $this->assign('title', '添加');
                 $this->assign('theme', '添加:');
                 $this->assign('btnvl', '添加');
                 //q特殊
                 $xq = M('xq');
                 $xqls = $xq->where('xqid=' . $xqid)->select();
                 //我TMD就为了一个置顶的xq来了
                 $this->assign('xqls', $xqls);
                 $where = '1=1';
                 $where = $where . ' AND f_cls_sttid=1';
                 //之前已经确定过到底是看哪个年级
                 $where = $where . ' AND f_cls_grdid=' . $grdid . ' AND clsactvt=1';
                 $cls = M($grdo['grdnm'] . '_cls');
                 $clsls = $cls->join('tb_stt ON f_cls_sttid=sttid')->where($where)->order('clsnm ASC')->select();
                 $this->assign('clsls', $clsls);
                 $where = '1=1';
                 $where = $where . " AND mjsttu LIKE '%-1-%'";
                 //之前已经确定过到底是看哪个年级
                 $where = $where . ' AND f_mj_grdid=' . $grdid;
                 $mj = M($grdo['grdnm'] . '_mj');
                 $mjls = $mj->join('tb_bxxs ON f_mj_bxxsid=bxxsid')->where($where)->order('f_mj_bxxsid ASC,mjdm ASC')->select();
                 $mjlsnw = array();
                 foreach ($mjls as $v) {
                     //给专业多点修饰
                     if (preg_match('/技能/', $v['bxxsnm'])) {
                         $v['bxxsnmst'] = '技能';
                     } else {
                         if (preg_match('/自考/', $v['bxxsnm'])) {
                             $v['bxxsnmst'] = '自考';
                         } else {
                             $v['bxxsnmst'] = '普通';
                         }
                     }
                     array_push($mjlsnw, $v);
                 }
                 $this->assign('mjls', $mjlsnw);
             } else {
                 $grd = M('grd');
                 $grdo = $grd->where('grdid=' . $grdid)->find();
                 $std = M($grdo['grdnm'] . '_std')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_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');
                 $mo = $std->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_dm ON f_stdxqdm_dmid=dmid')->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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_stdxqdm_xqid=" . $xqid . " AND stdid=" . $stdid)->find();
                 $this->assign('title', '修改');
                 $this->assign('theme', '修改:');
                 $this->assign('btnvl', '修改');
                 //q特殊
                 import('@.XQ.XQAction');
                 $xqw = new XQAction();
                 //外来的学期
                 $xqls = $xqw->getxqls($grdo['grdid'], 1, 'DESC');
                 $this->assign('xqls', $xqls);
                 $where = '1=1';
                 $where = $where . ' AND f_cls_sttid=1';
                 //之前已经确定过到底是看哪个年级
                 $where = $where . ' AND f_cls_grdid=' . $grdid . ' AND clsactvt=1';
                 $cls = M($grdo['grdnm'] . '_cls');
                 $clsls = $cls->join('tb_stt ON f_cls_sttid=sttid')->where($where)->order('clsnm ASC')->select();
                 $this->assign('clsls', $clsls);
                 $where = '1=1';
                 $where = $where . " AND mjsttu LIKE '%-1-%' AND f_mj_bxxsid=" . $mo['f_mj_bxxsid'];
                 //之前已经确定过到底是看哪个年级
                 $where = $where . ' AND f_mj_grdid=' . $grdid;
                 $mj = M($grdo['grdnm'] . '_mj');
                 $mjls = $mj->join('tb_bxxs ON f_mj_bxxsid=bxxsid')->where($where)->order('f_mj_bxxsid ASC,mjdm ASC')->select();
                 $mjlsnw = array();
                 foreach ($mjls as $v) {
                     //给专业多点修饰
                     if (preg_match('/技能/', $v['bxxsnm'])) {
                         $v['bxxsnmst'] = '技能';
                     } else {
                         if (preg_match('/自考/', $v['bxxsnm'])) {
                             $v['bxxsnmst'] = '自考';
                         } else {
                             $v['bxxsnmst'] = '普通';
                         }
                     }
                     array_push($mjlsnw, $v);
                 }
                 $this->assign('mjls', $mjlsnw);
                 //特殊情况
                 $tsqk = M($grdo['grdnm'] . '_tsqk');
                 $tsqkls = $tsqk->where('f_tsqk_stdid=' . $stdid)->order('tsqktm DESC')->select();
                 $this->assign('tsqkls', $tsqkls);
             }
             // 			//搞学生照片
             // 			if(file_exists('./Uploads/std/'.$grdo['grdnm'].'/'.$mo['f_std_sttid'].'/'.$mo['stdno'].'.jpg')){
             // 				$mo['stdpt']=__ROOT__.'/Uploads/std/'.$grdo['grdnm'].'/'.$mo['f_std_sttid'].'/'.$mo['stdno'].'.jpg';
             // 			}else{
             // 				$mo['stdpt']=C('PUBLIC').'/IMG/default.jpg';
             // 			}
             $this->assign('mo', $mo);
             //q特殊
             $tmp = explode('-', $zsszo['zsszbxxsu']);
             $where = '1=2';
             for ($i = 1; $i < count($tmp) - 1; $i++) {
                 $where = $where . ' OR bxxsid=' . $tmp[$i];
             }
             $bxxs = M('bxxs');
             $bxxsls = $bxxs->where($where)->select();
             $this->assign('bxxsls', $bxxsls);
             //q特殊
             $stt = M('stt');
             //因为你站点可能木有了,但是站点已经招的学生阔能还在,因此要保留站点
             $sttls = $stt->where('sttid=1')->select();
             $this->assign('sttls', $sttls);
             //q特殊
             $cc = M('cc');
             $ccls = $cc->where('ccid=3')->select();
             $this->assign('ccls', $ccls);
             //q特殊
             $kl = M('kl');
             $klls = $kl->select();
             $this->assign('klls', $klls);
             //q特殊
             $xxxs = M('xxxs');
             $xxxsls = $xxxs->where('xxxsid=2')->select();
             $this->assign('xxxsls', $xxxsls);
             //q特殊
             $zsfw = M('zsfw');
             $zsfwls = $zsfw->where('zsfwid=2')->select();
             $this->assign('zsfwls', $zsfwls);
             //q特殊
             $xz = M('xz');
             $xzls = $xz->where('xzid=2')->select();
             $this->assign('xzls', $xzls);
             //q特殊
             $grd = M('grd');
             $grdls = $grd->where('grdid=' . $zsszo['f_zssz_grdid'])->order('grdnm DESC')->select();
             $this->assign('grdls', $grdls);
             $dm = M('dm');
             $dmls = $dm->select();
             $this->assign('dmls', $dmls);
             //q特殊
             $sex = M('sex');
             $sexls = $sex->select();
             $this->assign('sexls', $sexls);
             //q特殊
             $rc = M('rc');
             $rcls = $rc->select();
             $this->assign('rcls', $rcls);
             //q特殊
             $zzmm = M('zzmm');
             $zzmmls = $zzmm->select();
             $this->assign('zzmmls', $zzmmls);
             //q特殊
             $xl = M('xl');
             $xlls = $xl->select();
             $this->assign('xlls', $xlls);
             //q特殊
             $stat = M('stat');
             $statls = $stat->where("statactvt=1 AND statmk='zs'")->select();
             $this->assign('statls', $statls);
             //搞介绍人
             if ($mo['stdrcmdnm'] || $mo['stdrcmdcp']) {
                 $this->assign('ifrcmd', '是');
                 $this->assign('rcmdcls', '');
             } else {
                 $this->assign('ifrcmd', '否');
                 $this->assign('rcmdcls', 'readonly');
             }
             $this->display('update');
         } else {
             if ($x == 'ylqtz') {
                 //根据学期获得学年
                 $xq = M('xq');
                 $xqo = $xq->where('xqid=' . $xqid)->find();
                 if (preg_match('/第1学期/', $xqo['xqnm'])) {
                     $tmp = explode('-', $xqo[xqnm]);
                     $xnnm = $tmp[0];
                 } else {
                     $tmp = explode('-', $xqo[xqnm]);
                     $tmp = explode('学年', $tmp[1]);
                     $xnnm = $tmp[0];
                 }
                 $xn = M('xn');
                 $xno = $xn->where("xnnm='" . $xnnm . "'")->find();
                 $stdid = $_GET['stdid'];
                 $grd = M('grd');
                 $grdo = $grd->where('grdid=' . $grdid)->find();
                 $cwo = M($grdo['grdnm'] . '_cw')->where('f_cw_stdid=' . $stdid . ' AND f_cw_xnid=' . $xno['xnid'])->find();
                 $cwid = $cwo['cwid'];
                 $xqid = $cwo['cwzcxqid'];
                 $cw = M($grdo['grdnm'] . '_cw')->join('tb_' . $grdo['grdnm'] . '_std ON f_cw_stdid=stdid')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_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');
                 $mo = $cw->join('tb_xn ON f_cw_xnid=xnid')->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_dm ON f_stdxqdm_dmid=dmid')->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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_stdxqdm_xqid=" . $xqid . " AND cwid=" . $cwid)->find();
                 //给专业多点修饰
                 if (preg_match('/技能/', $mo['bxxsnm'])) {
                     $mo['bxxsnmst'] = '技能';
                 } else {
                     if (preg_match('/自考/', $mo['bxxsnm'])) {
                         $mo['bxxsnmst'] = '自考';
                     } else {
                         $mo['bxxsnmst'] = '普通';
                     }
                 }
                 //需要看下如果是其他函授站的可以能要第一学期,第二学期,第三学期之类的很BT的东西
                 //适应一些站点用一二三
                 import('@.XQ.XQAction');
                 $xqw = new XQAction();
                 //外来的学期
                 $xqnm = $xqw->getxqnm($grdid, $mo['f_std_sttid'], $xqid);
                 $mo['xqnm'] = $xqnm;
                 $mo['cwyjze'] = $mo['cwyjxfsm'] + $mo['cwyjjckwfsm'] + $mo['cwyjzsfsm'];
                 $mo['cwsjze'] = $mo['cwsjxfsm'] + $mo['cwsjjckwfsm'] + $mo['cwsjzsfsm'];
                 $this->assign('mo', $mo);
                 //添加缴费信息1、学费教材考务费2、住宿费
                 $mj = M($grdo['grdnm'] . '_mj');
                 $mjo = $mj->where('mjid=' . $mo['f_stdxqmj_mjid'])->find();
                 $xf = M($grdo['grdnm'] . '_xf');
                 $xfo = $xf->where('f_xf_sttid=' . $mo['f_std_sttid'] . ' AND f_xf_bxxsid=' . $mjo['f_mj_bxxsid'] . ' AND f_xf_ccid=' . $mjo['f_mj_ccid'] . ' AND f_xf_klid=' . $mjo['f_mj_klid'])->find();
                 $zsf = M($grdo['grdnm'] . '_zsf');
                 $zsfo = $zsf->where('f_zsf_dmid=' . $mo['f_stdxqdm_dmid'])->find();
                 $this->assign('xfo', $xfo);
                 $this->assign('zsfo', $zsfo);
                 $this->assign('title', '预录取通知书电子版');
                 $this->assign('theme', '预录取通知书电子版');
                 $this->display('ylqtz');
             } else {
                 if ($x == 'stdda') {
                     //学生档案
                     $stdid = $_GET['stdid'];
                     $grd = M('grd');
                     $grdo = $grd->where('grdid=' . $grdid)->find();
                     $std = M($grdo['grdnm'] . '_std')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_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');
                     $mo = $std->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_dm ON f_stdxqdm_dmid=dmid')->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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_stdxqdm_xqid=" . $xqid . " AND stdid=" . $stdid)->find();
                     $this->assign('mo', $mo);
                     $this->assign('title', '学生档案流程单');
                     $this->assign('theme', '档案流程单');
                     $this->display('stdda');
                 } else {
                     if ($x == 'mdf') {
                         $stdid = $_GET['stdid'];
                         $grd = M('grd');
                         $grdo = $grd->where('grdid=' . $grdid)->find();
                         $std = M($grdo['grdnm'] . '_std')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_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');
                         $mo = $std->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_dm ON f_stdxqdm_dmid=dmid')->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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_stdxqdm_xqid=" . $xqid . " AND stdid=" . $stdid)->find();
                         $this->assign('title', '修改');
                         $this->assign('theme', '修改:');
                         $this->assign('btnvl', '修改');
                         //q特殊
                         import('@.XQ.XQAction');
                         $xqw = new XQAction();
                         //外来的学期
                         $xqls = $xqw->getxqls($grdo['grdid'], 1, 'DESC');
                         $this->assign('xqls', $xqls);
                         $where = '1=1';
                         $where = $where . ' AND f_cls_sttid=1';
                         //之前已经确定过到底是看哪个年级
                         $where = $where . ' AND f_cls_grdid=' . $grdid . ' AND clsactvt=1';
                         $cls = M($grdo['grdnm'] . '_cls');
                         $clsls = $cls->join('tb_stt ON f_cls_sttid=sttid')->where($where)->order('clsnm ASC')->select();
                         $this->assign('clsls', $clsls);
                         $where = '1=1';
                         $where = $where . " AND mjsttu LIKE '%-1-%' AND f_mj_bxxsid=" . $mo['f_mj_bxxsid'];
                         //之前已经确定过到底是看哪个年级
                         $where = $where . ' AND f_mj_grdid=' . $grdid;
                         $mj = M($grdo['grdnm'] . '_mj');
                         $mjls = $mj->join('tb_bxxs ON f_mj_bxxsid=bxxsid')->where($where)->order('f_mj_bxxsid ASC,mjdm ASC')->select();
                         $mjlsnw = array();
                         foreach ($mjls as $v) {
                             //给专业多点修饰
                             if (preg_match('/技能/', $v['bxxsnm'])) {
                                 $v['bxxsnmst'] = '技能';
                             } else {
                                 if (preg_match('/自考/', $v['bxxsnm'])) {
                                     $v['bxxsnmst'] = '自考';
                                 } else {
                                     $v['bxxsnmst'] = '普通';
                                 }
                             }
                             array_push($mjlsnw, $v);
                         }
                         $this->assign('mjls', $mjlsnw);
                         //特殊情况
                         $tsqk = M($grdo['grdnm'] . '_tsqk');
                         $tsqkls = $tsqk->where('f_tsqk_stdid=' . $stdid)->order('tsqktm DESC')->select();
                         $this->assign('tsqkls', $tsqkls);
                         // 			//搞学生照片
                         // 			if(file_exists('./Uploads/std/'.$grdo['grdnm'].'/'.$mo['f_std_sttid'].'/'.$mo['stdno'].'.jpg')){
                         // 				$mo['stdpt']=__ROOT__.'/Uploads/std/'.$grdo['grdnm'].'/'.$mo['f_std_sttid'].'/'.$mo['stdno'].'.jpg';
                         // 			}else{
                         // 				$mo['stdpt']=C('PUBLIC').'/IMG/default.jpg';
                         // 			}
                         $this->assign('mo', $mo);
                         //q特殊
                         $tmp = explode('-', $zsszo['zsszbxxsu']);
                         $where = '1=2';
                         for ($i = 1; $i < count($tmp) - 1; $i++) {
                             $where = $where . ' OR bxxsid=' . $tmp[$i];
                         }
                         $bxxs = M('bxxs');
                         $bxxsls = $bxxs->where($where)->select();
                         $this->assign('bxxsls', $bxxsls);
                         //q特殊
                         $stt = M('stt');
                         //因为你站点可能木有了,但是站点已经招的学生阔能还在,因此要保留站点
                         $sttls = $stt->where('sttid=1')->select();
                         $this->assign('sttls', $sttls);
                         //q特殊
                         $cc = M('cc');
                         $ccls = $cc->where('ccid=3')->select();
                         $this->assign('ccls', $ccls);
                         //q特殊
                         $kl = M('kl');
                         $klls = $kl->select();
                         $this->assign('klls', $klls);
                         //q特殊
                         $xxxs = M('xxxs');
                         $xxxsls = $xxxs->where('xxxsid=2')->select();
                         $this->assign('xxxsls', $xxxsls);
                         //q特殊
                         $zsfw = M('zsfw');
                         $zsfwls = $zsfw->where('zsfwid=2')->select();
                         $this->assign('zsfwls', $zsfwls);
                         //q特殊
                         $xz = M('xz');
                         $xzls = $xz->where('xzid=2')->select();
                         $this->assign('xzls', $xzls);
                         //q特殊
                         $grd = M('grd');
                         $grdls = $grd->where('grdid=' . $zsszo['f_zssz_grdid'])->order('grdnm DESC')->select();
                         $this->assign('grdls', $grdls);
                         $dm = M('dm');
                         $dmls = $dm->select();
                         $this->assign('dmls', $dmls);
                         //q特殊
                         $sex = M('sex');
                         $sexls = $sex->select();
                         $this->assign('sexls', $sexls);
                         //q特殊
                         $rc = M('rc');
                         $rcls = $rc->select();
                         $this->assign('rcls', $rcls);
                         //q特殊
                         $zzmm = M('zzmm');
                         $zzmmls = $zzmm->select();
                         $this->assign('zzmmls', $zzmmls);
                         //q特殊
                         $xl = M('xl');
                         $xlls = $xl->select();
                         $this->assign('xlls', $xlls);
                         //q特殊
                         $stat = M('stat');
                         $statls = $stat->where("statactvt=1 AND statmk='zs'")->select();
                         $this->assign('statls', $statls);
                         //搞介绍人
                         if ($mo['stdrcmdnm'] || $mo['stdrcmdcp']) {
                             $this->assign('ifrcmd', '是');
                             $this->assign('rcmdcls', '');
                         } else {
                             $this->assign('ifrcmd', '否');
                             $this->assign('rcmdcls', 'readonly');
                         }
                         $this->display('update');
                     } else {
                         if ($x = 'stddtfx') {
                             $xqiddq = $xqid;
                             $bxxs = M('bxxs');
                             $bxxsls = $bxxs->select();
                             $dm = M('dm');
                             $dmls = $dm->select();
                             //先分开算再合起来
                             $grd = M('grd');
                             $grdls = $grd->where('grdid=' . $grdid)->order('grdnm DESC')->select();
                             $grdlsfn = array();
                             foreach ($grdls as $grdv) {
                                 $zl = array();
                                 //资料
                                 $cls = M($grdv['grdnm'] . '_cls');
                                 $clsls = $cls->where('clsactvt=1 AND f_cls_sttid=' . $sttid)->order('clsnm ASC')->select();
                                 $mj = M($grdv['grdnm'] . '_mj');
                                 $mjls = $mj->join('tb_bxxs ON f_mj_bxxsid=bxxsid')->where("mjsttu LIKE '%-" . $sttid . "-%' AND mjbbzs=1")->order('bxxsid ASC,mjnm ASC')->select();
                                 $std = M($grdv['grdnm'] . '_std');
                                 if ($std->count() == 0) {
                                     continue;
                                 }
                                 $zongsm = $std->count();
                                 $zl['zongsm'] = $zongsm;
                                 //总大小
                                 $bulaism = $std->where('f_std_statid=9')->count();
                                 $zl['bulaism'] = $bulaism;
                                 $kenenglaism = $std->where('f_std_statid<>9')->count();
                                 $zl['kenenglaism'] = $kenenglaism;
                                 $zongnb = $std->where('f_std_statid<>9')->count();
                                 $zl['zongnb'] = $zongnb;
                                 //
                                 $bynb = $std->where('f_std_statid<>9 AND f_std_sexid=1')->count();
                                 $zl['bynb'] = $bynb;
                                 $glnb = $std->where('f_std_statid<>9 AND f_std_sexid=2')->count();
                                 $zl['glnb'] = $glnb;
                                 //查看办学形式
                                 $bxxsarr = array();
                                 foreach ($bxxsls as $bxxsv) {
                                     $bxxscnt = $std->join('inner join tb_' . $grdv['grdnm'] . '_stdxqcls ON stdid=f_stdxqcls_stdid')->join('inner join tb_' . $grdv['grdnm'] . '_stdxqmj ON stdid=f_stdxqmj_stdid')->join('tb_' . $grdv['grdnm'] . '_mj ON f_stdxqmj_mjid=mjid')->where("f_stdxqcls_xqid=" . $xqiddq . " AND f_stdxqmj_xqid=" . $xqiddq . ' AND f_mj_bxxsid=' . $bxxsv['bxxsid'] . ' AND f_std_statid<>9')->count();
                                     if ($bxxscnt == 0) {
                                         continue;
                                     }
                                     $bxxsv['bxxscnt'] = $bxxscnt;
                                     array_push($bxxsarr, $bxxsv);
                                 }
                                 $zl['bxxs'] = $bxxsarr;
                                 //查看住宿
                                 $dmarr = array();
                                 foreach ($dmls as $dmv) {
                                     $dmcnt = $std->join('inner join tb_' . $grdv['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_stdid')->where("f_stdxqdm_xqid=" . $xqiddq . ' AND f_stdxqdm_dmid=' . $dmv['dmid'] . ' AND f_std_statid<>9')->count();
                                     if ($dmcnt == 0) {
                                         continue;
                                     }
                                     $dmv['dmcnt'] = $dmcnt;
                                     array_push($dmarr, $dmv);
                                 }
                                 $zl['dm'] = $dmarr;
                                 //查看港澳台西藏
                                 $hknb = $std->where("stdnp LIKE '%香港%' AND f_std_statid<>9")->count();
                                 $zl['hknb'] = $hknb;
                                 $mcnb = $std->where("stdnp LIKE '%澳门%' AND f_std_statid<>9")->count();
                                 $zl['mcnb'] = $mcnb;
                                 $twnb = $std->where("stdnp LIKE '%台湾%' AND f_std_statid<>9")->count();
                                 $zl['twnb'] = $twnb;
                                 $tbnb = $std->where("stdnp LIKE '%西藏%' AND f_std_statid<>9")->count();
                                 $zl['tbnb'] = $tbnb;
                                 $otnb = $std->where("stdnp NOT LIKE '%香港%' AND stdnp NOT LIKE '%澳门%' AND stdnp NOT LIKE '%台湾%' AND stdnp NOT LIKE '%西藏%' AND f_std_statid<>9")->count();
                                 $zl['otnb'] = $otnb;
                                 //PS:这里发现了个彩蛋,mysql在利用某个字段搜索的时候都是有个默认前提的,就是在这个字段有值的 条目中进行筛选
                                 // 				//查看班级
                                 // 				$clsarr=array();
                                 // 				foreach ($clsls as $clsv){
                                 // 					$clscnt=$std->join('inner join tb_'.$grdv['grdnm'].'_stdxqcls ON stdid=f_stdxqcls_stdid')->join('inner join tb_'.$grdv['grdnm'].'_stdxqmj ON stdid=f_stdxqmj_stdid')->join('tb_'.$grdv['grdnm'].'_cls ON f_stdxqcls_clsid=clsid')->where("f_stdxqcls_xqid=".$xqiddq." AND f_stdxqmj_xqid=".$xqiddq.' AND f_stdxqcls_clsid='.$clsv['clsid'].' AND f_std_statid=5')->count();
                                 // 					if($clscnt==0){
                                 // 						continue;
                                 // 					}
                                 // 					$clsv['clscnt']=$clscnt;
                                 // 					array_push($clsarr, $clsv);
                                 // 				}
                                 // 				$zl['cls']=$clsarr;
                                 //查看专业
                                 $mjarr = array();
                                 foreach ($mjls as $mjv) {
                                     $mjcnt = $std->join('inner join tb_' . $grdv['grdnm'] . '_stdxqcls ON stdid=f_stdxqcls_stdid')->join('inner join tb_' . $grdv['grdnm'] . '_stdxqmj ON stdid=f_stdxqmj_stdid')->join('tb_' . $grdv['grdnm'] . '_mj ON f_stdxqmj_mjid=mjid')->where("f_stdxqcls_xqid=" . $xqiddq . " AND f_stdxqmj_xqid=" . $xqiddq . ' AND f_stdxqmj_mjid=' . $mjv['mjid'] . ' AND f_std_statid<>9')->count();
                                     if ($mjcnt == 0) {
                                         continue;
                                     }
                                     $mjv['mjcnt'] = $mjcnt;
                                     array_push($mjarr, $mjv);
                                 }
                                 $zl['mj'] = $mjarr;
                                 //查看班级
                                 $clsarr = array();
                                 foreach ($clsls as $clsv) {
                                     $clscnt = $std->join('inner join tb_' . $grdv['grdnm'] . '_stdxqcls ON stdid=f_stdxqcls_stdid')->join('inner join tb_' . $grdv['grdnm'] . '_stdxqmj ON stdid=f_stdxqmj_stdid')->join('tb_' . $grdv['grdnm'] . '_cls ON f_stdxqcls_clsid=clsid')->where("f_stdxqcls_xqid=" . $xqiddq . " AND f_stdxqmj_xqid=" . $xqiddq . ' AND f_stdxqcls_clsid=' . $clsv['clsid'] . ' AND f_std_statid<>9')->count();
                                     if ($clscnt == 0) {
                                         continue;
                                     }
                                     $clsv['clscnt'] = $clscnt;
                                     array_push($clsarr, $clsv);
                                 }
                                 $zl['cls'] = $clsarr;
                                 $grdv['zl'] = $zl;
                                 array_push($grdlsfn, $grdv);
                             }
                             $this->assign('grdls', $grdlsfn);
                             $begin = '2015-05-01';
                             $end = date("Y-m-d", time());
                             import('@.TM.TMAction');
                             $tm = new TMAction();
                             $datels = $tm->timelist($begin, $end);
                             $dtls = array();
                             $rsls = array();
                             //人数
                             foreach ($datels as $k => $dtv) {
                                 $dateo = date("m-d", $dtv);
                                 $tmp = array();
                                 //清空一下,一面造成累计
                                 $tmp['rq'] = $dateo;
                                 array_push($dtls, $tmp);
                                 $cnt = $std->where("stdaddtm LIKE '%" . $dateo . "%'")->count();
                                 $tmp = array();
                                 //清空一下,一面造成累计
                                 $tmp['rs'] = $cnt;
                                 array_push($rsls, $tmp);
                             }
                             $this->assign('dtls', $dtls);
                             $this->assign('rsls', $rsls);
                             $this->assign('title', '招生学生数据分析');
                             $this->assign('theme', '招生学生数据分析详细');
                             $this->display('stddtfx');
                         }
                     }
                 }
             }
         }
     }
 }
Example #4
0
 function gtxpg()
 {
     //先给hd设置好些东西,他自身是无法提取的
     import('@.SS.SSAction');
     $ss = new SSAction();
     $ss->setss();
     $x = $_GET['x'];
     //鉴权 如果OK的就正常显示,或者出现查看神马的,否则就呵呵了,query he gtxpg两处
     $mdII = M('md');
     $mdo = $mdII->where("mdmk='Cjzx'")->find();
     import('@.IDTATH.IdtathAction');
     $Idtath = new IdtathAction();
     $athofn = $Idtath->identify($mdo['mdid'], $x);
     // 		import('@.NTF.NTFAction');
     // 		$ntf = new NTFAction();
     // 		$ntf->setntf();
     import('@.KZMB.KZMBAction');
     $kzmb = new KZMBAction();
     $kzmb->setkzmb($mdo['mdid']);
     if ($x == 'vw') {
         $grdid = $_GET['grdid'];
         $cjzxid = $_GET['cjzxid'];
         $grd = M('grd');
         $grdo = $grd->where('grdid=' . $grdid)->find();
         $cjzx = M($grdo['grdnm'] . '_cjzx');
         $cjzxo = $cjzx->where('cjzxid=' . $cjzxid)->find();
         $mo = $cjzx->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_stdxqcls_xqid=" . $cjzxo['f_cjzx_xqid'] . " AND f_stdxqmj_xqid=" . $cjzxo['f_cjzx_xqid'] . " AND f_std_statid=5 AND cjzxid=" . $cjzxid)->find();
         if ($mo['pkzkkm'] == 1) {
             $mo['pkzkkm'] = '【自考科目】';
         } else {
             if ($mo['pkzkkm'] == 0) {
                 $mo['pkzkkm'] = '';
             }
         }
         //需要看下如果是其他函授站的可以能要第一学期,第二学期,第三学期之类的很BT的东西
         //适应一些站点用一二三
         import('@.XQ.XQAction');
         $xqw = new XQAction();
         //外来的学期
         $xqnm = $xqw->getxqnm($grdid, $mo['f_cjzx_sttid'], $mo['f_cjzx_xqid']);
         $mo['xqnm'] = $xqnm;
         if ($mo['cjzxxk'] == 1) {
             $mo['cjzxxk'] = '是';
         } else {
             $mo['cjzxxk'] = '否';
         }
         if ($mo['cjzxqk'] == 1) {
             $mo['cjzxqk'] = '是';
         } else {
             $mo['cjzxqk'] = '否';
         }
         if ($mo['cjzxhk'] == 1) {
             $mo['cjzxhk'] = '是';
         } else {
             $mo['cjzxhk'] = '否';
         }
         $this->assign('mo', $mo);
         $this->assign('title', '查看');
         $this->assign('theme', '查看详细');
         $this->display('view');
     } else {
         if ($x == 'updt') {
             $grdid = $_GET['grdid'];
             $cjzxid = $_GET['cjzxid'];
             // 			$usr=M('usr');
             // 			$usro=$usr->where('usrid='.session('usridss'))->find();
             // 			//鉴权对用户对stt的权限,若为设置权限,说明是教务的人,可以全管,否则只能管自己函授站的 ntf为不用this assign的
             // 			$mdII=M('md');
             // 			$mdo=$mdII->where("mdmk='Stt'")->find();
             // 			import('@.IDTATH.IdtathAction');
             // 			$Idtath = new IdtathAction();
             // 			$athofnstt=$Idtath->identify($mdo['mdid'],'ntf');
             if ($cjzxid == 0) {
                 // 				$mo['cjzxid']=0;
                 // 				//默认年级是当前年级
                 // 				$grd=M('grd');
                 // 				$grdo=$grd->order('grdnm DESC')->find();
                 // 				$grdid=$grdo['grdid'];
                 // 				$mo['f_cjzx_grdid']=$grdid;
                 // 				//默认站点,有主的找有主的,没主的找本部
                 // 				if($athofnstt['aths']!=1){
                 // 					$mo['f_cjzx_sttid']=$usro['f_usr_sttid'];
                 // 				}else{
                 // 					$mo['f_cjzx_sttid']=1;
                 // 				}
                 // 				//默认学期 为XX年级XX站点的起始学期
                 // 				$xq=M('xq');
                 // 				$xqo=$xq->where('xqdq=1')->find();
                 // 				$xqid=$xqo['xqid'];
                 // 				$sttintxq=M($grdo['grdnm'].'_sttintxq');
                 // 				$sttintxqo=$sttintxq->where('f_sttintxq_grdid='.$grdo['grdid'].' AND f_sttintxq_sttid='.$mo['f_cjzx_sttid'])->find();
                 // 				if($xqid<$sttintxqo['f_sttintxq_xqid']){$xqid=$sttintxqo['f_sttintxq_xqid'];}//①如果激活的学期在初始学期后范围内的那么就选激活的学期②如果...在范围外的话呢就选择第初始学期为默认学期
                 // 				$mo['f_cjzx_xqid']=$xqid;
                 // 				$this->assign('title','添加');
                 // 				$this->assign('theme','添加:');
                 // 				$this->assign('btnvl','添加');
             } else {
                 $grd = M('grd');
                 $grdo = $grd->where('grdid=' . $grdid)->find();
                 $cjzx = M($grdo['grdnm'] . '_cjzx');
                 $cjzxo = $cjzx->where('cjzxid=' . $cjzxid)->find();
                 $mo = $cjzx->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_stdxqcls_xqid=" . $cjzxo['f_cjzx_xqid'] . " AND f_stdxqmj_xqid=" . $cjzxo['f_cjzx_xqid'] . " AND f_std_statid=5 AND cjzxid=" . $cjzxid)->find();
                 if ($mo['pkzkkm'] == 1) {
                     $mo['pkzkkm'] = '【自考科目】';
                 } else {
                     if ($mo['pkzkkm'] == 0) {
                         $mo['pkzkkm'] = '';
                     }
                 }
                 $this->assign('title', '修改');
                 $this->assign('theme', '修改:');
                 $this->assign('btnvl', '修改');
             }
             $this->assign('mo', $mo);
             // 			//q特殊
             // 			$where='1=1';
             // 			if($athofnstt['aths']!=1){
             // 				$where=$where.' AND sttid='.$usro['f_usr_sttid'];
             // 			}
             // 			$stt=M('stt');
             // 			$sttls=$stt->where($where)->select();
             // 			$this->assign('sttls',$sttls);
             // 			//q特殊
             // 			$grd=M('grd');
             // 			$grdls=$grd->order('grdnm DESC')->select();
             // 			$this->assign('grdls',$grdls);
             // 			import('@.XQ.XQAction');
             // 			$xqw = new XQAction();//外来的学期
             // 			$xqls=$xqw->getxqls($grdo['grdid'], $mo['f_cjzx_sttid'], 'DESC');
             // 			$this->assign('xqls',$xqls);
             // 			//课程
             // 			//q特殊
             // 			$kc=M($grdo['grdnm'].'_kc');
             // 			$kcls=$kc->where('f_kc_grdid='.$grdo['grdid'])->select();
             // 			$this->assign('kcls',$kcls);
             // 			//教师
             // 			//q特殊
             // 			$tcr=M('tcr');
             // 			$tcrls=$tcr->where('f_tcr_sttid='.$mo['f_cjzx_sttid'])->select();
             // 			$this->assign('tcrls',$tcrls);
             $this->display('update');
         }
     }
 }
Example #5
0
 function gtxpg()
 {
     //先给hd设置好些东西,他自身是无法提取的
     import('@.SS.SSAction');
     $ss = new SSAction();
     $ss->setss();
     $x = $_GET['x'];
     //鉴权 如果OK的就正常显示,或者出现查看神马的,否则就呵呵了,query he gtxpg两处
     $mdII = M('md');
     $mdo = $mdII->where("mdmk='Jjqk'")->find();
     import('@.IDTATH.IdtathAction');
     $Idtath = new IdtathAction();
     $athofn = $Idtath->identify($mdo['mdid'], $x);
     import('@.NTF.NTFAction');
     $ntf = new NTFAction();
     $ntf->setntf();
     import('@.KZMB.KZMBAction');
     $kzmb = new KZMBAction();
     $kzmb->setkzmb($mdo['mdid']);
     //鉴权对用户对stt的权限,若为设置权限,说明是教务的人,可以全管,否则只能管自己函授站的 ntf为不用this assign的
     $mdII = M('md');
     $mdo = $mdII->where("mdmk='Stt'")->find();
     import('@.IDTATH.IdtathAction');
     $Idtath = new IdtathAction();
     $athofnstt = $Idtath->identify($mdo['mdid'], 'ntf');
     $usr = M('usr');
     $usro = $usr->where('usrid=' . session('usridss'))->find();
     if ($x == 'vw') {
         $grdid = $_GET['grdid'];
         $xkid = $_GET['xkid'];
         $grd = M('grd');
         $grdo = $grd->where('grdid=' . $grdid)->find();
         $xk = M($grdo['grdnm'] . '_xk');
         $mo = $xk->join('tb_stt ON f_xk_sttid=sttid')->join('tb_grd ON f_xk_grdid=grdid')->join('tb_xq ON f_xk_xqid=xqid')->join('tb_' . $grdo['grdnm'] . '_kc ON f_xk_kcid=kcid')->join('tb_tcr ON f_xk_tcrid=tcrid')->where("xkid=" . $xkid)->find();
         //需要看下如果是其他函授站的可以能要第一学期,第二学期,第三学期之类的很BT的东西
         //适应一些站点用一二三
         import('@.XQ.XQAction');
         $xqw = new XQAction();
         //外来的学期
         $xqnm = $xqw->getxqnm($grdid, $mo['f_xk_sttid'], $mo['f_xk_xqid']);
         $mo['xqnm'] = $xqnm;
         $this->assign('mo', $mo);
         $this->assign('title', '查看');
         $this->assign('theme', '查看详细');
         $this->display('view');
     } else {
         if ($x == 'updt') {
             $grdid = $_GET['grdid'];
             $xkid = $_GET['xkid'];
             $usr = M('usr');
             $usro = $usr->where('usrid=' . session('usridss'))->find();
             //鉴权对用户对stt的权限,若为设置权限,说明是教务的人,可以全管,否则只能管自己函授站的 ntf为不用this assign的
             $mdII = M('md');
             $mdo = $mdII->where("mdmk='Stt'")->find();
             import('@.IDTATH.IdtathAction');
             $Idtath = new IdtathAction();
             $athofnstt = $Idtath->identify($mdo['mdid'], 'ntf');
             if ($xkid == 0) {
                 $mo['xkid'] = 0;
                 //默认年级是当前年级
                 $grd = M('grd');
                 $grdo = $grd->order('grdnm DESC')->find();
                 $grdid = $grdo['grdid'];
                 $mo['f_xk_grdid'] = $grdid;
                 //默认站点,有主的找有主的,没主的找本部
                 if ($athofnstt['aths'] != 1) {
                     $mo['f_xk_sttid'] = $usro['f_usr_sttid'];
                 } else {
                     $mo['f_xk_sttid'] = 1;
                 }
                 //默认学期 为XX年级XX站点的起始学期
                 $xq = M('xq');
                 $xqo = $xq->where('xqdq=1')->find();
                 $xqid = $xqo['xqid'];
                 $sttintxq = M($grdo['grdnm'] . '_sttintxq');
                 $sttintxqo = $sttintxq->where('f_sttintxq_grdid=' . $grdo['grdid'] . ' AND f_sttintxq_sttid=' . $mo['f_xk_sttid'])->find();
                 if ($xqid < $sttintxqo['f_sttintxq_xqid']) {
                     $xqid = $sttintxqo['f_sttintxq_xqid'];
                 }
                 //①如果激活的学期在初始学期后范围内的那么就选激活的学期②如果...在范围外的话呢就选择第初始学期为默认学期
                 $mo['f_xk_xqid'] = $xqid;
                 $this->assign('title', '添加');
                 $this->assign('theme', '添加:');
                 $this->assign('btnvl', '添加');
             } else {
                 $grd = M('grd');
                 $grdo = $grd->where('grdid=' . $grdid)->find();
                 $xk = M($grdo['grdnm'] . '_xk');
                 $mo = $xk->join('tb_stt ON f_xk_sttid=sttid')->join('tb_grd ON f_xk_grdid=grdid')->join('tb_xq ON f_xk_xqid=xqid')->join('tb_' . $grdo['grdnm'] . '_kc ON f_xk_kcid=kcid')->join('tb_tcr ON f_xk_tcrid=tcrid')->where("xkid=" . $xkid)->find();
                 $this->assign('title', '修改');
                 $this->assign('theme', '修改:');
                 $this->assign('btnvl', '修改');
             }
             $this->assign('mo', $mo);
             //q特殊
             $where = '1=1';
             if ($athofnstt['aths'] != 1) {
                 $where = $where . ' AND sttid=' . $usro['f_usr_sttid'];
             }
             $stt = M('stt');
             $sttls = $stt->where($where)->select();
             $this->assign('sttls', $sttls);
             //q特殊
             $grd = M('grd');
             $grdls = $grd->order('grdnm DESC')->select();
             $this->assign('grdls', $grdls);
             import('@.XQ.XQAction');
             $xqw = new XQAction();
             //外来的学期
             $xqls = $xqw->getxqls($grdo['grdid'], $mo['f_xk_sttid'], 'DESC');
             $this->assign('xqls', $xqls);
             //课程
             //q特殊
             $kc = M($grdo['grdnm'] . '_kc');
             $kcls = $kc->where('f_kc_grdid=' . $grdo['grdid'])->select();
             $this->assign('kcls', $kcls);
             //教师
             //q特殊
             $tcr = M('tcr');
             $tcrls = $tcr->where('f_tcr_sttid=' . $mo['f_xk_sttid'])->select();
             $this->assign('tcrls', $tcrls);
             $this->display('update');
         }
     }
 }
Example #6
0
 function gtxpg()
 {
     header("Content-Type:text/html; charset=utf-8");
     //先给hd设置好些东西,他自身是无法提取的
     import('@.SS.SSAction');
     $ss = new SSAction();
     $ss->setss();
     $x = $_GET['x'];
     // 		//鉴权 如果OK的就正常显示,或者出现查看神马的,否则就呵呵了,query he gtxpg两处
     // 		$mdII=M('md');
     // 		$mdo=$mdII->where("mdmk='Cjzx'")->find();
     // 		import('@.IDTATH.IdtathAction');
     // 		$Idtath = new IdtathAction();
     // 		$athofn=$Idtath->identify($mdo['mdid'],$x);
     // 		import('@.NTF.NTFAction');
     // 		$ntf = new NTFAction();
     // 		$ntf->setntf();
     import('@.KZMB.KZMBAction');
     $kzmb = new KZMBAction();
     $kzmb->setkzmb($mdo['mdid']);
     if ($x == 'vw') {
         $grdid = $_GET['grdid'];
         $cjzxid = $_GET['cjzxid'];
         $grd = M('grd');
         $grdo = $grd->where('grdid=' . $grdid)->find();
         $cjzx = M($grdo['grdnm'] . '_cjzx');
         $mo = $cjzx->join('tb_stt ON f_cjzx_sttid=sttid')->join('tb_grd ON f_cjzx_grdid=grdid')->join('tb_xq ON f_cjzx_xqid=xqid')->join('tb_' . $grdo['grdnm'] . '_kc ON f_cjzx_kcid=kcid')->join('tb_tcr ON f_cjzx_tcrid=tcrid')->where("cjzxid=" . $cjzxid)->find();
         //需要看下如果是其他函授站的可以能要第一学期,第二学期,第三学期之类的很BT的东西
         //适应一些站点用一二三
         import('@.XQ.XQAction');
         $xqw = new XQAction();
         //外来的学期
         $xqnm = $xqw->getxqnm($grdid, $mo['f_cjzx_sttid'], $mo['f_cjzx_xqid']);
         $mo['xqnm'] = $xqnm;
         $this->assign('mo', $mo);
         $this->assign('title', '查看');
         $this->assign('theme', '查看详细');
         $this->display('view');
     } else {
         if ($x == 'updt') {
             $grdid = $_GET['grdid'];
             $cjzxid = $_GET['cjzxid'];
             $usr = M('usr');
             $usro = $usr->where('usrid=' . session('usridss'))->find();
             //鉴权对用户对stt的权限,若为设置权限,说明是教务的人,可以全管,否则只能管自己函授站的 ntf为不用this assign的
             $mdII = M('md');
             $mdo = $mdII->where("mdmk='Stt'")->find();
             import('@.IDTATH.IdtathAction');
             $Idtath = new IdtathAction();
             $athofnstt = $Idtath->identify($mdo['mdid'], 'ntf');
             if ($cjzxid == 0) {
                 $mo['cjzxid'] = 0;
                 //默认年级是当前年级
                 $grd = M('grd');
                 $grdo = $grd->order('grdnm DESC')->find();
                 $grdid = $grdo['grdid'];
                 $mo['f_cjzx_grdid'] = $grdid;
                 //默认站点,有主的找有主的,没主的找本部
                 if ($athofnstt['aths'] != 1) {
                     $mo['f_cjzx_sttid'] = $usro['f_usr_sttid'];
                 } else {
                     $mo['f_cjzx_sttid'] = 1;
                 }
                 //默认学期 为XX年级XX站点的起始学期
                 $xq = M('xq');
                 $xqo = $xq->where('xqdq=1')->find();
                 $xqid = $xqo['xqid'];
                 $sttintxq = M($grdo['grdnm'] . '_sttintxq');
                 $sttintxqo = $sttintxq->where('f_sttintxq_grdid=' . $grdo['grdid'] . ' AND f_sttintxq_sttid=' . $mo['f_cjzx_sttid'])->find();
                 if ($xqid < $sttintxqo['f_sttintxq_xqid']) {
                     $xqid = $sttintxqo['f_sttintxq_xqid'];
                 }
                 //①如果激活的学期在初始学期后范围内的那么就选激活的学期②如果...在范围外的话呢就选择第初始学期为默认学期
                 $mo['f_cjzx_xqid'] = $xqid;
                 $this->assign('title', '添加');
                 $this->assign('theme', '添加:');
                 $this->assign('btnvl', '添加');
             } else {
                 $grd = M('grd');
                 $grdo = $grd->where('grdid=' . $grdid)->find();
                 $cjzx = M($grdo['grdnm'] . '_cjzx');
                 $mo = $cjzx->join('tb_stt ON f_cjzx_sttid=sttid')->join('tb_grd ON f_cjzx_grdid=grdid')->join('tb_xq ON f_cjzx_xqid=xqid')->join('tb_' . $grdo['grdnm'] . '_kc ON f_cjzx_kcid=kcid')->join('tb_tcr ON f_cjzx_tcrid=tcrid')->where("cjzxid=" . $cjzxid)->find();
                 $this->assign('title', '修改');
                 $this->assign('theme', '修改:');
                 $this->assign('btnvl', '修改');
             }
             $this->assign('mo', $mo);
             //q特殊
             $where = '1=1';
             if ($athofnstt['aths'] != 1) {
                 $where = $where . ' AND sttid=' . $usro['f_usr_sttid'];
             }
             $stt = M('stt');
             $sttls = $stt->where($where)->select();
             $this->assign('sttls', $sttls);
             //q特殊
             $grd = M('grd');
             $grdls = $grd->order('grdnm DESC')->select();
             $this->assign('grdls', $grdls);
             import('@.XQ.XQAction');
             $xqw = new XQAction();
             //外来的学期
             $xqls = $xqw->getxqls($grdo['grdid'], $mo['f_cjzx_sttid'], 'DESC');
             $this->assign('xqls', $xqls);
             //课程
             //q特殊
             $kc = M($grdo['grdnm'] . '_kc');
             $kcls = $kc->where('f_kc_grdid=' . $grdo['grdid'])->select();
             $this->assign('kcls', $kcls);
             //教师
             //q特殊
             $tcr = M('tcr');
             $tcrls = $tcr->where('f_tcr_sttid=' . $mo['f_cjzx_sttid'])->select();
             $this->assign('tcrls', $tcrls);
             $this->display('update');
         } else {
             if ($x = 'skxx') {
                 //授课信息
                 //获得这个人id
                 $tcrid = session('tcridss');
                 $tcr = M('tcr');
                 $tcro = $tcr->where('tcrid=' . $tcrid)->find();
                 //sttid tcrid
                 $xq = M('xq');
                 $xqo = $xq->where('xqdq=1')->find();
                 //xqid
                 $grd = M('grd');
                 $grdls = $grd->order('grdnm DESC')->select();
                 $grdlsfn = array();
                 foreach ($grdls as $v) {
                     //grdid
                     $pk = M($v['grdnm'] . '_pk');
                     $pkls = $pk->join('tb_' . $v['grdnm'] . '_kc ON f_pk_kcid=kcid')->where('f_pk_grdid=' . $v['grdid'] . ' AND f_pk_sttid=' . $tcro['f_tcr_sttid'] . ' AND f_pk_xqid=' . $xqo['xqid'] . ' AND f_pk_tcrid=' . $tcro['tcrid'])->select();
                     if (!$pkls) {
                         continue;
                     }
                     $pklsfn = array();
                     foreach ($pkls as $u) {
                         $cjzx = M($v['grdnm'] . '_cjzx');
                         $cjzx->join('tb_' . $v['grdnm'] . '_std ON f_cjzx_stdid=stdid')->join('inner join tb_' . $v['grdnm'] . '_stdxqcls ON stdid=f_stdxqcls_stdid')->join('inner join tb_' . $v['grdnm'] . '_stdxqmj ON stdid=f_stdxqmj_stdid');
                         $cjzx->join('tb_' . $v['grdnm'] . '_pk ON f_cjzx_pkid=pkid')->join('tb_stt ON f_cjzx_sttid=sttid')->join('tb_grd ON f_cjzx_grdid=grdid')->join('tb_' . $v['grdnm'] . '_kc ON f_pk_kcid=kcid')->join('tb_tcr ON f_pk_tcrid=tcrid')->join('tb_xq ON f_cjzx_xqid=xqid')->join('tb_' . $v['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_' . $v['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');
                         $cjzxls = $cjzx->Distinct(true)->field('clsid,clsnm,cjzxsftj')->where('f_stdxqcls_xqid=' . $xqo['xqid'] . ' AND f_stdxqmj_xqid=' . $xqo['xqid'] . ' AND f_cjzx_pkid=' . $u['pkid'] . ' AND f_std_statid=5')->select();
                         $u['clsls'] = $cjzxls;
                         array_push($pklsfn, $u);
                     }
                     $v['pkls'] = $pklsfn;
                     array_push($grdlsfn, $v);
                 }
                 $this->assign('grdls', $grdlsfn);
                 $this->assign('title', '授课信息');
                 $this->assign('theme', '授课信息:');
                 $this->assign('btnvl', '');
                 $this->display('skxx');
             }
         }
     }
 }
Example #7
0
 function gtxpg()
 {
     //先给hd设置好些东西,他自身是无法提取的
     import('@.SS.SSAction');
     $ss = new SSAction();
     $ss->setss();
     $x = $_GET['x'];
     if ($x == 'vw') {
         $zssz = M('zssz');
         $zsszo = $zssz->find();
         $grdid = $zsszo['f_zssz_grdid'];
         $xqid = $zsszo['f_zssz_xqid'];
         //根据学期获得学年
         $xq = M('xq');
         $xqo = $xq->where('xqid=' . $xqid)->find();
         if (preg_match('/第1学期/', $xqo['xqnm'])) {
             $tmp = explode('-', $xqo[xqnm]);
             $xnnm = $tmp[0];
         } else {
             $tmp = explode('-', $xqo[xqnm]);
             $tmp = explode('学年', $tmp[1]);
             $xnnm = $tmp[0];
         }
         $xn = M('xn');
         $xno = $xn->where("xnnm='" . $xnnm . "'")->find();
         $stdid = $_GET['stdid'];
         $grd = M('grd');
         $grdo = $grd->where('grdid=' . $grdid)->find();
         $cwo = M($grdo['grdnm'] . '_cw')->where('f_cw_stdid=' . $stdid . ' AND f_cw_xnid=' . $xno['xnid'])->find();
         $cwid = $cwo['cwid'];
         $xqid = $cwo['cwzcxqid'];
         $cw = M($grdo['grdnm'] . '_cw')->join('tb_' . $grdo['grdnm'] . '_std ON f_cw_stdid=stdid')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_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');
         $mo = $cw->join('tb_xn ON f_cw_xnid=xnid')->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_dm ON f_stdxqdm_dmid=dmid')->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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_stdxqdm_xqid=" . $xqid . " AND cwid=" . $cwid)->find();
         //给专业多点修饰
         if (preg_match('/技能/', $mo['bxxsnm'])) {
             $mo['bxxsnmst'] = '技能';
         } else {
             if (preg_match('/自考/', $mo['bxxsnm'])) {
                 $mo['bxxsnmst'] = '自考';
             } else {
                 $mo['bxxsnmst'] = '普通';
             }
         }
         //需要看下如果是其他函授站的可以能要第一学期,第二学期,第三学期之类的很BT的东西
         //适应一些站点用一二三
         import('@.XQ.XQAction');
         $xqw = new XQAction();
         //外来的学期
         $xqnm = $xqw->getxqnm($grdid, $mo['f_std_sttid'], $xqid);
         $mo['xqnm'] = $xqnm;
         $mo['cwyjze'] = $mo['cwyjxfsm'] + $mo['cwyjjckwfsm'] + $mo['cwyjzsfsm'];
         $mo['cwsjze'] = $mo['cwsjxfsm'] + $mo['cwsjjckwfsm'] + $mo['cwsjzsfsm'];
         $this->assign('mo', $mo);
         $this->assign('title', '查看');
         $this->assign('theme', '查看缴费信息');
         $this->display('view');
     } else {
         if ($x == 'updt') {
             $cwid = $_GET['cwid'];
             $grdid = $_GET['grdid'];
             $grd = M('grd');
             $grdo = $grd->where('grdid=' . $grdid)->find();
             $cwo = M($grdo['grdnm'] . '_cw')->where('cwid=' . $cwid)->find();
             $xqid = $cwo['cwzcxqid'];
             $usr = M('usr');
             $usro = $usr->where('usrid=' . session('usridss'))->find();
             //鉴权对用户对stt的权限,若为设置权限,说明是教务的人,可以全管,否则只能管自己函授站的 ntf为不用this assign的
             $mdII = M('md');
             $mdo = $mdII->where("mdmk='Stt'")->find();
             import('@.IDTATH.IdtathAction');
             $Idtath = new IdtathAction();
             $athofnstt = $Idtath->identify($mdo['mdid'], 'ntf');
             if ($cwid == 0) {
                 // 				$mo['stdid']=0;
                 // 				$mo['stdsol']='无';
                 // 				$mo['stdpt']=C('PUBLIC').'/IMG/default.jpg';
                 // 				//第几学年 第几学期的班级 第几学年 第几学期的专业 ...
                 // 				//因为grd无法定下来,所以stdxqcls stdxqmj_xqid 定下来也没有意义,干脆就不定了,等搜索时候自由分晓
                 // 				//默认年级是当前年级
                 // 				$grd=M('grd');
                 // 				$grdo=$grd->order('grdnm DESC')->find();
                 // 				$grdid=$grdo['grdid'];
                 // 				$mo['f_std_grdid']=$grdid;
                 // 				$mo['grdnm']=$grdo['grdnm'];
                 // 				//默认站点,有主的找有主的,没主的找本部
                 // 				if($athofnstt['aths']!=1){
                 // 					$mo['f_std_sttid']=$usro['f_usr_sttid'];
                 // 				}else{
                 // 					$mo['f_std_sttid']=1;
                 // 				}
                 // 				//默认学期 为XX年级XX站点的起始学期
                 // 				$sttintxq=M($grdo['grdnm'].'_sttintxq');
                 // 				$sttintxqo=$sttintxq->where('f_sttintxq_grdid='.$grdo['grdid'].' AND f_sttintxq_sttid='.$mo['f_std_sttid'])->find();
                 // 				$xqid=$sttintxqo['f_sttintxq_xqid'];
                 // 				$mo['f_stdxqcls_xqid']=$xqid;
                 // 				$mo['f_stdxqmj_xqid']=$xqid;
                 // 				$this->assign('title','添加');
                 // 				$this->assign('theme','添加:');
                 // 				$this->assign('btnvl','添加');
                 // 				//q特殊
                 // 				$xq=M('xq');
                 // 				$xqls=$xq->where('xqid='.$xqid)->select();//我TMD就为了一个置顶的xq来了
                 // 				$this->assign('xqls',$xqls);
                 // 				$where='1=1';
                 // 				if($athofnstt['aths']!=1){
                 // 					$where=$where.' AND f_cls_sttid='.$usro['f_usr_sttid'];
                 // 				}
                 // 				//之前已经确定过到底是看哪个年级
                 // 				$where=$where.' AND f_cls_grdid='.$grdid;
                 // 				$cls=M($grdo['grdnm'].'_cls');
                 // 				$clsls=$cls->join('tb_stt ON f_cls_sttid=sttid')->where($where)->order('clsnm ASC')->select();
                 // 				$this->assign('clsls',$clsls);
                 // 				$where='1=1';
                 // 				if($athofnstt['aths']!=1){
                 // 					$where=$where." AND mjsttu LIKE '%-".$usro['f_usr_sttid']."-%'";
                 // 				}
                 // 				//之前已经确定过到底是看哪个年级
                 // 				$where=$where.' AND f_mj_grdid='.$grdid;
                 // 				$mj=M($grdo['grdnm'].'_mj');
                 // 				$mjls=$mj->join('tb_bxxs ON f_mj_bxxsid=bxxsid')->where($where)->order('f_mj_bxxsid ASC,mjdm ASC')->select();
                 // 				$mjlsnw=array();
                 // 				foreach($mjls as $v){
                 // 					//给专业多点修饰
                 // 					if(preg_match('/技能/',$v['bxxsnm'])){
                 // 						$v['bxxsnmst']='技能';
                 // 					}else if(preg_match('/自考/',$v['bxxsnm'])){
                 // 						$v['bxxsnmst']='自考';
                 // 					}else{
                 // 						$v['bxxsnmst']='普通';
                 // 					}
                 // 					array_push($mjlsnw, $v);
                 // 				}
                 // 				$this->assign('mjls',$mjlsnw);
             } else {
                 $grd = M('grd');
                 $cw = M($grdo['grdnm'] . '_cw')->join('tb_' . $grdo['grdnm'] . '_std ON f_cw_stdid=stdid')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_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');
                 $mo = $cw->join('tb_xn ON f_cw_xnid=xnid')->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_dm ON f_stdxqdm_dmid=dmid')->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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_stdxqdm_xqid=" . $xqid . " AND cwid=" . $cwid)->find();
                 if (preg_match('/技能/', $mo['bxxsnm'])) {
                     $mo['bxxsnmst'] = '技能';
                 } else {
                     if (preg_match('/自考/', $mo['bxxsnm'])) {
                         $mo['bxxsnmst'] = '自考';
                     } else {
                         $mo['bxxsnmst'] = '普通';
                     }
                 }
                 $mo['cwyjze'] = $mo['cwyjxfsm'] + $mo['cwyjjckwfsm'] + $mo['cwyjzsfsm'];
                 $mo['cwsjze'] = $mo['cwsjxfsm'] + $mo['cwsjjckwfsm'] + $mo['cwsjzsfsm'];
                 $this->assign('title', '修改');
                 $this->assign('theme', '修改:');
                 $this->assign('btnvl', '修改');
                 //所有的注册信息,哪个学期哪个班哪个专业
                 //应该具备哪些注册信息
                 //学期
                 import('@.XQ.XQAction');
                 $xqw = new XQAction();
                 //外来的学期
                 $xqls = $xqw->getxqls($grdid, $mo['f_std_sttid'], 'ASC');
                 //年级确定开始,学制确定过程
                 $stdxqcls = M($grdo['grdnm'] . '_stdxqcls');
                 $stdxqmj = M($grdo['grdnm'] . '_stdxqmj');
                 for ($i = 0; $i < count($xqls); $i++) {
                     $xqid = $xqls[$i]['xqid'];
                     if ($stdxqcls->where('f_stdxqcls_stdid=' . $mo['f_cw_stdid'] . ' AND f_stdxqcls_xqid=' . $xqid)->find() && $stdxqmj->where('f_stdxqmj_stdid=' . $mo['f_cw_stdid'] . ' AND f_stdxqmj_xqid=' . $xqid)->find()) {
                         $xqls[$i]['zcf'] = 'active';
                         //注册否?
                         $xqls[$i]['zczt'] = '已注册';
                     } else {
                         $xqls[$i]['zcf'] = 'disabled';
                         $xqls[$i]['zczt'] = '未注册';
                     }
                     $stdxqclso = $stdxqcls->join('tb_' . $grdo['grdnm'] . '_cls ON f_stdxqcls_clsid=clsid')->where('f_stdxqcls_stdid=' . $mo['f_cw_stdid'] . ' AND f_stdxqcls_xqid=' . $xqid)->find();
                     $stdxqmjo = $stdxqmj->join('tb_' . $grdo['grdnm'] . '_mj ON f_stdxqmj_mjid=mjid')->where('f_stdxqmj_stdid=' . $mo['f_cw_stdid'] . ' AND f_stdxqmj_xqid=' . $xqid)->find();
                     $xqls[$i]['clsnm'] = $stdxqclso['clsnm'];
                     $xqls[$i]['mjnm'] = $stdxqmjo['mjnm'];
                 }
                 $this->assign('zcls', $xqls);
                 //注册列表
                 //特殊情况
                 $tsqk = M($grdo['grdnm'] . '_tsqk');
                 $tsqkls = $tsqk->where('f_tsqk_stdid=' . $mo['f_cw_stdid'])->order('tsqktm DESC')->select();
                 $this->assign('tsqkls', $tsqkls);
             }
             $this->assign('mo', $mo);
             $this->display('update');
         } else {
             if ($x == 'center') {
                 $zssz = M('zssz');
                 $zsszo = $zssz->find();
                 $grdid = $zsszo['f_zssz_grdid'];
                 $xqid = $zsszo['f_zssz_xqid'];
                 //根据学期获得学年
                 $xq = M('xq');
                 $xqo = $xq->where('xqid=' . $xqid)->find();
                 if (preg_match('/第1学期/', $xqo['xqnm'])) {
                     $tmp = explode('-', $xqo[xqnm]);
                     $xnnm = $tmp[0];
                 } else {
                     $tmp = explode('-', $xqo[xqnm]);
                     $tmp = explode('学年', $tmp[1]);
                     $xnnm = $tmp[0];
                 }
                 $xn = M('xn');
                 $xno = $xn->where("xnnm='" . $xnnm . "'")->find();
                 $stdid = session('stdidss');
                 $grd = M('grd');
                 $grdo = $grd->where('grdid=' . $grdid)->find();
                 $cwo = M($grdo['grdnm'] . '_cw')->where('f_cw_stdid=' . $stdid . ' AND f_cw_xnid=' . $xno['xnid'])->find();
                 $cwid = $cwo['cwid'];
                 $xqid = $cwo['cwzcxqid'];
                 $cw = M($grdo['grdnm'] . '_cw')->join('tb_' . $grdo['grdnm'] . '_std ON f_cw_stdid=stdid')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_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');
                 $mo = $cw->join('tb_xn ON f_cw_xnid=xnid')->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_dm ON f_stdxqdm_dmid=dmid')->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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_stdxqdm_xqid=" . $xqid . " AND cwid=" . $cwid)->find();
                 //给专业多点修饰
                 if (preg_match('/技能/', $mo['bxxsnm'])) {
                     $mo['bxxsnmst'] = '技能';
                 } else {
                     if (preg_match('/自考/', $mo['bxxsnm'])) {
                         $mo['bxxsnmst'] = '自考';
                     } else {
                         $mo['bxxsnmst'] = '普通';
                     }
                 }
                 //需要看下如果是其他函授站的可以能要第一学期,第二学期,第三学期之类的很BT的东西
                 //适应一些站点用一二三
                 import('@.XQ.XQAction');
                 $xqw = new XQAction();
                 //外来的学期
                 $xqnm = $xqw->getxqnm($grdid, $mo['f_std_sttid'], $xqid);
                 $mo['xqnm'] = $xqnm;
                 $mo['cwyjze'] = $mo['cwyjxfsm'] + $mo['cwyjjckwfsm'] + $mo['cwyjzsfsm'];
                 $mo['cwsjze'] = $mo['cwsjxfsm'] + $mo['cwsjjckwfsm'] + $mo['cwsjzsfsm'];
                 $this->assign('mo', $mo);
                 $this->assign('title', '个人财务中心');
                 $this->assign('theme', '个人财务中心');
                 $this->display('center');
             }
         }
     }
 }
Example #8
0
 function gtxpg()
 {
     //先给hd设置好些东西,他自身是无法提取的
     import('@.SS.SSAction');
     $ss = new SSAction();
     $ss->setss();
     $x = $_GET['x'];
     //鉴权 如果OK的就正常显示,或者出现查看神马的,否则就呵呵了,query he gtxpg两处
     $mdII = M('md');
     $mdo = $mdII->where("mdmk='Xk'")->find();
     import('@.IDTATH.IdtathAction');
     $Idtath = new IdtathAction();
     $athofn = $Idtath->identify($mdo['mdid'], $x);
     import('@.NTF.NTFAction');
     $ntf = new NTFAction();
     $ntf->setntf();
     import('@.KZMB.KZMBAction');
     $kzmb = new KZMBAction();
     $kzmb->setkzmb($mdo['mdid']);
     //鉴权对用户对stt的权限,若为设置权限,说明是教务的人,可以全管,否则只能管自己函授站的 ntf为不用this assign的
     $mdII = M('md');
     $mdo = $mdII->where("mdmk='Stt'")->find();
     import('@.IDTATH.IdtathAction');
     $Idtath = new IdtathAction();
     $athofnstt = $Idtath->identify($mdo['mdid'], 'ntf');
     $usr = M('usr');
     $usro = $usr->where('usrid=' . session('usridss'))->find();
     if ($x == 'clsjtxk') {
         //NB初始化,开始
         $cdt = $_GET['cdt'];
         $grd = M('grd');
         if (preg_match('/f_cjzx_grdid/', $cdt)) {
             //获取该键的值
             $tmp = explode('f_cjzx_grdid', $cdt);
             $tmp = explode('-eq-', $tmp[1]);
             $tmp = explode('-sp-', $tmp[1]);
             $grdid = $tmp[0];
         } else {
             //默认grdid
             $grdo = $grd->order('grdid DESC')->find();
             $grdid = $grdo['grdid'];
         }
         $this->assign('grdiddft', $grdid);
         $grdo = $grd->where('grdid=' . $grdid)->find();
         $cjzx = clone M($grdo['grdnm'] . '_cjzx');
         $cjzxforcls = clone M($grdo['grdnm'] . '_cjzx');
         $cjzx->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');
         // 		$cjzxls=$cjzx->select();
         $fldint = '-cjzxid-f_cjzx_grdid-stdno-stdnm-sexnm-pkzkkm-cjzxpsf-cjzxsftj-cjzxxk-cjzxqk-xqnm-f_cjzx_pkid-f_cjzx_xqid-kcnm-tcrnn-';
         if (preg_match('/f_cjzx_sttid/', $cdt)) {
             //获取该键的值
             $tmp = explode('f_cjzx_sttid', $cdt);
             $tmp = explode('-eq-', $tmp[1]);
             $tmp = explode('-sp-', $tmp[1]);
             $sttid = $tmp[0];
         } else {
             //默认sttid
             if ($athofnstt['aths'] == 1) {
                 $sttid = 1;
             } else {
                 $sttid = $usro['f_usr_sttid'];
             }
         }
         $this->assign('sttiddft', $sttid);
         if (preg_match('/f_cjzx_xqid/', $cdt)) {
             //获取该键的值
             $tmp = explode('f_cjzx_xqid', $cdt);
             $tmp = explode('-eq-', $tmp[1]);
             $tmp = explode('-sp-', $tmp[1]);
             $xqid = $tmp[0];
         } else {
             $xq = M('xq');
             $xqo = $xq->where('xqdq=1')->find();
             $xqid = $xqo['xqid'];
             $sttintxq = M($grdo['grdnm'] . '_sttintxq');
             $sttintxqo = $sttintxq->where('f_sttintxq_grdid=' . $grdo['grdid'] . ' AND f_sttintxq_sttid=' . $sttid)->find();
             if ($xqid < $sttintxqo['f_sttintxq_xqid']) {
                 $xqid = $sttintxqo['f_sttintxq_xqid'];
             }
             //①如果激活的学期在初始学期后范围内的那么就选激活的学期②如果...在范围外的话呢就选择第初始学期为默认学期
         }
         $this->assign('xqiddft', $xqid);
         $cdtint = "-sp-f_cjzx_grdid-eq-" . $grdid . "-sp-f_cjzx_sttid-eq-" . $sttid . "-sp-f_cjzx_xqid-eq-" . $xqid . '-sp-' . "f_pk_grdid-eq-" . $grdid . "-sp-f_pk_sttid-eq-" . $sttid . "-sp-f_pk_xqid-eq-" . $xqid . '-sp-' . "f_std_grdid-eq-" . $grdid . "-sp-f_std_sttid-eq-" . $sttid . "-sp-f_std_statid-eq-5-sp-f_stdxqcls_xqid-eq-" . $xqid . "-sp-f_stdxqmj_xqid-eq-" . $xqid . '-sp-';
         $spccdtint = '-sp-';
         ////
         $odrint = '-f_mj_bxxsid ASC-clsid ASC-mjid ASC-stdno ASC-pkzkkm ASC-kcnm ASC-';
         $lmtint = 100;
         $jn = 'tb_' . $grdo['grdnm'] . '_pk ON f_cjzx_pkid=pkid-jn-tb_stt ON f_cjzx_sttid=sttid-jn-tb_grd ON f_cjzx_grdid=grdid-jn-tb_' . $grdo['grdnm'] . '_kc ON f_pk_kcid=kcid-jn-tb_tcr ON f_pk_tcrid=tcrid-jn-tb_xq ON f_cjzx_xqid=xqid' . '-jn-tb_' . $grdo['grdnm'] . '_mj ON f_stdxqmj_mjid=mjid-jn-tb_bxxs ON f_mj_bxxsid=bxxsid-jn-tb_cc ON f_mj_ccid=ccid-jn-tb_kl ON f_mj_klid=klid-jn-tb_xxxs ON f_mj_xxxsid=xxxsid-jn-tb_zsfw ON f_mj_zsfwid=zsfwid-jn-tb_xz ON f_mj_xzid=xzid-jn-tb_' . $grdo['grdnm'] . '_cls ON f_stdxqcls_clsid=clsid-jn-tb_sex ON f_std_sexid=sexid-jn-tb_rc ON f_std_rcid=rcid-jn-tb_zzmm ON f_std_zzmmid=zzmmid-jn-tb_xl ON f_std_xlid=xlid-jn-tb_stat ON f_std_statid=statid';
         import('@.NB.NBAction');
         $NB = new NBAction();
         $cls = M($grdo['grdnm'] . '_cls');
         $clsls = $cls->where('clsactvt=1 AND f_cls_sttid=' . $sttid)->order('clsnm ASC')->select();
         $stdxqcls = M($grdo['grdnm'] . '_stdxqcls');
         $clslsfn = array();
         foreach ($clsls as $v) {
             $clsid = $v['clsid'];
             //找学生代表//万一这个学生代表有些课没选咋办?所以要采用高大上的DISTINCT
             $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=" . $v['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();
             // 				$stdo=$stdxqcls->join('tb_'.$grdo['grdnm'].'_std ON f_stdxqcls_stdid=stdid')->where('f_stdxqcls_xqid='.$xqid.' AND f_stdxqcls_clsid='.$clsid.' AND f_std_statid=5')->order('stdno ASC')->find();
             // 				$cdtintII=$cdtint.'stdid-eq-'.$stdo['stdid'].'-sp-';
             // 				$arr=$NB->NB($cjzx,$fldint,$cdtintII,$spccdtint,$odrint,$lmtint,$jn,'n','n');////
             // 				$v['pkls']=$arr['mls'];
             $v['pkls'] = $pkls;
             array_push($clslsfn, $v);
         }
         //为了确保有NB过程,所以我们不管是有没有班级,统一NB一次,反正得到的ARR也不用,且却得到很多必要参数
         $arr = $NB->NB($cjzx, $fldint, $cdtint, $spccdtint, $odrint, $lmtint, $jn, 'n', 'n');
         ////
         $this->assign('fstrw', $arr['fstrw']);
         $this->assign('sqlstc', $arr['sqlstc']);
         $this->assign('fld', $arr['fld']);
         $this->assign('cdt', $arr['cdt']);
         $this->assign('spccdt', $arr['spccdt']);
         ////
         $this->assign('odr', $arr['odr']);
         $this->assign('lmt', $arr['lmt']);
         $this->assign('count', $arr['count']);
         $this->assign('clsls', $clslsfn);
         $grdls = $grd->order('grdnm DESC')->select();
         $this->assign('grdls', $grdls);
         $stt = M('stt');
         $sttls = $stt->order('sttid ASC')->select();
         $this->assign('sttls', $sttls);
         import('@.XQ.XQAction');
         $xqw = new XQAction();
         //外来的学期
         $xqls = $xqw->getxqls($grdo['grdid'], $sttid, 'DESC');
         $this->assign('xqls', $xqls);
         $this->assign('title', '班级集体选课');
         $this->assign('theme', '班级集体选课');
         $this->display('clsjtxk');
     } else {
         if ($x == 'clsjtxksz') {
             $grdid = $_GET['grdid'];
             $sttid = $_GET['sttid'];
             $xqid = $_GET['xqid'];
             $clsid = $_GET['clsid'];
             $grd = M('grd');
             $grdo = $grd->where('grdid=' . $grdid)->find();
             $this->assign('grdo', $grdo);
             $stt = M('stt');
             $stto = $stt->where('sttid=' . $sttid)->find();
             $this->assign('stto', $stto);
             $xq = M('xq');
             $xqo = $xq->where('xqid=' . $xqid)->find();
             $this->assign('xqo', $xqo);
             $cls = M($grdo['grdnm'] . '_cls');
             $clso = $cls->where('clsid=' . $clsid)->find();
             $this->assign('clso', $clso);
             //用高大上的方式看看整个班整体选了那几门课,然后可以在下面剔除掉这些课,避免重复选
             $cjzx = M($grdo['grdnm'] . '_cjzx');
             $pkidls = $cjzx->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=" . $clsid)->select();
             $where = '1=2';
             foreach ($pkidls as $vI) {
                 $where = $where . ' OR pkid=' . $vI['pkid'];
             }
             $pk = m($grdo['grdnm'] . '_pk');
             $pklsyx = $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();
             $where = '';
             foreach ($pklsyx as $v) {
                 $where = $where . ' AND pkid<>' . $v['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('f_pk_grdid=' . $grdid . ' AND f_pk_sttid=' . $sttid . ' AND f_pk_xqid=' . $xqid . $where)->select();
             $pklsfn = array();
             foreach ($pkls as $v) {
                 if ($v['pkzkkm'] == 1) {
                     $v['pkzkkm'] = '【自考科目】';
                 } else {
                     $v['pkzkkm'] = '';
                 }
                 array_push($pklsfn, $v);
             }
             $this->assign('pkls', $pklsfn);
             $this->assign('title', '班级集体选课实战');
             $this->assign('theme', '班级集体选课实战');
             $this->assign('btnvl', '确认选课');
             $this->display('clsjtxksz');
         } else {
             if ($x == 'stdgrxk') {
                 //NB初始化,开始
                 $cdt = $_GET['cdt'];
                 $grd = M('grd');
                 if (preg_match('/f_cjzx_grdid/', $cdt)) {
                     //获取该键的值
                     $tmp = explode('f_cjzx_grdid', $cdt);
                     $tmp = explode('-eq-', $tmp[1]);
                     $tmp = explode('-sp-', $tmp[1]);
                     $grdid = $tmp[0];
                 } else {
                     //默认grdid
                     $grdo = $grd->order('grdid DESC')->find();
                     $grdid = $grdo['grdid'];
                 }
                 $this->assign('grdiddft', $grdid);
                 $grdo = $grd->where('grdid=' . $grdid)->find();
                 $cjzx = clone M($grdo['grdnm'] . '_cjzx');
                 $cjzxforstd = clone M($grdo['grdnm'] . '_cjzx');
                 $cjzx->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');
                 // 		$cjzxls=$cjzx->select();
                 $fldint = '-cjzxid-f_cjzx_grdid-stdno-stdnm-sexnm-pkzkkm-cjzxpsf-cjzxsftj-cjzxxk-cjzxqk-xqnm-f_cjzx_pkid-f_cjzx_xqid-kcnm-tcrnn-';
                 if (preg_match('/f_cjzx_sttid/', $cdt)) {
                     //获取该键的值
                     $tmp = explode('f_cjzx_sttid', $cdt);
                     $tmp = explode('-eq-', $tmp[1]);
                     $tmp = explode('-sp-', $tmp[1]);
                     $sttid = $tmp[0];
                 } else {
                     //默认sttid
                     if ($athofnstt['aths'] == 1) {
                         $sttid = 1;
                     } else {
                         $sttid = $usro['f_usr_sttid'];
                     }
                 }
                 $this->assign('sttiddft', $sttid);
                 if (preg_match('/f_cjzx_xqid/', $cdt)) {
                     //获取该键的值
                     $tmp = explode('f_cjzx_xqid', $cdt);
                     $tmp = explode('-eq-', $tmp[1]);
                     $tmp = explode('-sp-', $tmp[1]);
                     $xqid = $tmp[0];
                 } else {
                     $xq = M('xq');
                     $xqo = $xq->where('xqdq=1')->find();
                     $xqid = $xqo['xqid'];
                     $sttintxq = M($grdo['grdnm'] . '_sttintxq');
                     $sttintxqo = $sttintxq->where('f_sttintxq_grdid=' . $grdo['grdid'] . ' AND f_sttintxq_sttid=' . $sttid)->find();
                     if ($xqid < $sttintxqo['f_sttintxq_xqid']) {
                         $xqid = $sttintxqo['f_sttintxq_xqid'];
                     }
                     //①如果激活的学期在初始学期后范围内的那么就选激活的学期②如果...在范围外的话呢就选择第初始学期为默认学期
                 }
                 $this->assign('xqiddft', $xqid);
                 $cdtint = "-sp-f_cjzx_grdid-eq-" . $grdid . "-sp-f_cjzx_sttid-eq-" . $sttid . "-sp-f_cjzx_xqid-eq-" . $xqid . '-sp-' . "f_pk_grdid-eq-" . $grdid . "-sp-f_pk_sttid-eq-" . $sttid . "-sp-f_pk_xqid-eq-" . $xqid . '-sp-' . "f_std_grdid-eq-" . $grdid . "-sp-f_std_sttid-eq-" . $sttid . "-sp-f_std_statid-eq-5-sp-f_stdxqcls_xqid-eq-" . $xqid . "-sp-f_stdxqmj_xqid-eq-" . $xqid . '-sp-';
                 if (preg_match('/f_stdxqcls_clsid/', $cdt)) {
                     //获取该键的值
                     $tmp = explode('f_stdxqcls_clsid', $cdt);
                     $tmp = explode('-eq-', $tmp[1]);
                     $tmp = explode('-sp-', $tmp[1]);
                     $clsid = $tmp[0];
                     $cdtint = $cdtint . 'f_stdxqcls_clsid-eq-' . $clsid . '-sp-';
                 }
                 $this->assign('clsiddft', $clsid);
                 if (preg_match('/stdid/', $cdt)) {
                     //获取该键的值
                     $tmp = explode('stdid', $cdt);
                     $tmp = explode('-eq-', $tmp[1]);
                     $tmp = explode('-sp-', $tmp[1]);
                     $stdid = $tmp[0];
                     $cdtint = $cdtint . 'stdid-eq-' . $stdid . '-sp-';
                 }
                 $this->assign('stdiddft', $stdid);
                 $spccdtint = '-sp-';
                 ////
                 $odrint = '-f_mj_bxxsid ASC-clsid ASC-mjid ASC-stdno ASC-pkzkkm ASC-kcnm ASC-';
                 $lmtint = 100;
                 $jn = 'tb_' . $grdo['grdnm'] . '_pk ON f_cjzx_pkid=pkid-jn-tb_stt ON f_cjzx_sttid=sttid-jn-tb_grd ON f_cjzx_grdid=grdid-jn-tb_' . $grdo['grdnm'] . '_kc ON f_pk_kcid=kcid-jn-tb_tcr ON f_pk_tcrid=tcrid-jn-tb_xq ON f_cjzx_xqid=xqid' . '-jn-tb_' . $grdo['grdnm'] . '_mj ON f_stdxqmj_mjid=mjid-jn-tb_bxxs ON f_mj_bxxsid=bxxsid-jn-tb_cc ON f_mj_ccid=ccid-jn-tb_kl ON f_mj_klid=klid-jn-tb_xxxs ON f_mj_xxxsid=xxxsid-jn-tb_zsfw ON f_mj_zsfwid=zsfwid-jn-tb_xz ON f_mj_xzid=xzid-jn-tb_' . $grdo['grdnm'] . '_cls ON f_stdxqcls_clsid=clsid-jn-tb_sex ON f_std_sexid=sexid-jn-tb_rc ON f_std_rcid=rcid-jn-tb_zzmm ON f_std_zzmmid=zzmmid-jn-tb_xl ON f_std_xlid=xlid-jn-tb_stat ON f_std_statid=statid';
                 import('@.NB.NBAction');
                 $NB = new NBAction();
                 $cls = M($grdo['grdnm'] . '_cls');
                 $clsls = $cls->where('clsactvt=1 AND f_cls_sttid=' . $sttid)->order('clsnm ASC')->order('clsnm ASC')->select();
                 if ($stdid) {
                     //获取学生信息
                     $std = M($grdo['grdnm'] . '_std');
                     $stdo = $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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_std_statid=5 AND  stdid=" . $stdid)->find();
                     $pkls = $cjzxforstd->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')->where("f_cjzx_grdid=" . $grdid . " AND f_cjzx_sttid=" . $sttid . " AND f_cjzx_xqid=" . $xqid . " AND f_cjzx_stdid=" . $stdid)->order('pkzkkm ASC,kcnm ASC')->select();
                     $this->assign('stdo', $stdo);
                     $this->assign('pkls', $pkls);
                 }
                 //为了确保有NB过程,所以我们不管是有没有班级,统一NB一次,反正得到的ARR也不用,且却得到很多必要参数
                 $arr = $NB->NB($cjzx, $fldint, $cdtint, $spccdtint, $odrint, $lmtint, $jn, 'n', 'n');
                 ////
                 $this->assign('fstrw', $arr['fstrw']);
                 $this->assign('sqlstc', $arr['sqlstc']);
                 $this->assign('fld', $arr['fld']);
                 $this->assign('cdt', $arr['cdt']);
                 $this->assign('spccdt', $arr['spccdt']);
                 ////
                 $this->assign('odr', $arr['odr']);
                 $this->assign('lmt', $arr['lmt']);
                 $this->assign('count', $arr['count']);
                 $grdls = $grd->order('grdnm DESC')->select();
                 $this->assign('grdls', $grdls);
                 $stt = M('stt');
                 $sttls = $stt->order('sttid ASC')->select();
                 $this->assign('sttls', $sttls);
                 import('@.XQ.XQAction');
                 $xqw = new XQAction();
                 //外来的学期
                 $xqls = $xqw->getxqls($grdo['grdid'], $sttid, 'DESC');
                 $this->assign('xqls', $xqls);
                 $cls = M($grdo['grdnm'] . '_cls');
                 $clsls = $cls->join('tb_stt ON f_cls_sttid=sttid')->where('f_cls_grdid=' . $grdid . ' AND f_cls_sttid=' . $sttid)->select();
                 $this->assign('clsls', $clsls);
                 $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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_std_statid=5 AND  f_std_sttid=" . $sttid . ' AND f_stdxqcls_clsid=' . $clsid)->order('f_mj_bxxsid ASC,mjid ASC,stdno ASC')->select();
                 $this->assign('stdls', $stdls);
                 $this->assign('title', '学生个人选课');
                 $this->assign('theme', '学生个人选课');
                 $this->display('stdgrxk');
             } else {
                 if ($x == 'stdgrxksz') {
                     $grdid = $_GET['grdid'];
                     $sttid = $_GET['sttid'];
                     $xqid = $_GET['xqid'];
                     $clsid = $_GET['clsid'];
                     $stdid = $_GET['stdid'];
                     $grd = M('grd');
                     $grdo = $grd->where('grdid=' . $grdid)->find();
                     $this->assign('grdo', $grdo);
                     $stt = M('stt');
                     $stto = $stt->where('sttid=' . $sttid)->find();
                     $this->assign('stto', $stto);
                     $xq = M('xq');
                     $xqo = $xq->where('xqid=' . $xqid)->find();
                     $this->assign('xqo', $xqo);
                     $cls = M($grdo['grdnm'] . '_cls');
                     $clso = $cls->where('clsid=' . $clsid)->find();
                     $this->assign('clso', $clso);
                     //用高大上的办法看看他所在班都选了那几门课,并看看他自己选了哪几门课,万一已选就算蛋
                     $stdxqcls = M($grdo['grdnm'] . '_stdxqcls');
                     $stdo = $stdxqcls->join('tb_' . $grdo['grdnm'] . '_std ON f_stdxqcls_stdid=stdid')->where('f_stdxqcls_xqid=' . $xqid . ' AND f_stdxqcls_clsid=' . $clsid . ' AND f_std_statid=5 AND stdid=' . $stdid)->find();
                     $this->assign('stdo', $stdo);
                     $cjzx = M($grdo['grdnm'] . '_cjzx');
                     //获取班级选课信息 以及学生选课信息,进行比对,留下学生未选的哪些课程
                     $pkidls = $cjzx->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=" . $clsid)->select();
                     $pklsstd = $cjzx->where("f_cjzx_grdid=" . $grdid . " AND f_cjzx_sttid=" . $sttid . " AND f_cjzx_xqid=" . $xqid . " AND f_cjzx_stdid=" . $stdid)->select();
                     $pkidlsfn = array();
                     foreach ($pkidls as $v) {
                         $duishangflg = 0;
                         //对上
                         foreach ($pklsstd as $vI) {
                             if ($v['pkid'] == $vI['f_cjzx_pkid']) {
                                 $duishangflg = 1;
                                 break;
                             }
                         }
                         if ($duishangflg == 0) {
                             array_push($pkidlsfn, $v);
                         }
                     }
                     //得出已选的PKLS
                     $where = '1=2';
                     foreach ($pkidlsfn as $v) {
                         $where = $where . ' OR pkid=' . $v['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)->select();
                     $pklsfn = array();
                     foreach ($pkls as $v) {
                         if ($v['pkzkkm'] == 1) {
                             $v['pkzkkm'] = '【自考科目】';
                         } else {
                             $v['pkzkkm'] = '';
                         }
                         array_push($pklsfn, $v);
                     }
                     $this->assign('pkls', $pklsfn);
                     $this->assign('title', '学生个人选课实战');
                     $this->assign('theme', '学生个人选课实战');
                     $this->assign('btnvl', '确认选课');
                     $this->display('stdgrxksz');
                 } else {
                     if ($x == 'vw') {
                         $grdid = $_GET['grdid'];
                         $xkid = $_GET['xkid'];
                         $grd = M('grd');
                         $grdo = $grd->where('grdid=' . $grdid)->find();
                         $xk = M($grdo['grdnm'] . '_xk');
                         $mo = $xk->join('tb_stt ON f_xk_sttid=sttid')->join('tb_grd ON f_xk_grdid=grdid')->join('tb_xq ON f_xk_xqid=xqid')->join('tb_' . $grdo['grdnm'] . '_kc ON f_xk_kcid=kcid')->join('tb_tcr ON f_xk_tcrid=tcrid')->where("xkid=" . $xkid)->find();
                         //需要看下如果是其他函授站的可以能要第一学期,第二学期,第三学期之类的很BT的东西
                         //适应一些站点用一二三
                         import('@.XQ.XQAction');
                         $xqw = new XQAction();
                         //外来的学期
                         $xqnm = $xqw->getxqnm($grdid, $mo['f_xk_sttid'], $mo['f_xk_xqid']);
                         $mo['xqnm'] = $xqnm;
                         $this->assign('mo', $mo);
                         $this->assign('title', '查看');
                         $this->assign('theme', '查看详细');
                         $this->display('view');
                     } else {
                         if ($x == 'updt') {
                             $grdid = $_GET['grdid'];
                             $xkid = $_GET['xkid'];
                             $usr = M('usr');
                             $usro = $usr->where('usrid=' . session('usridss'))->find();
                             //鉴权对用户对stt的权限,若为设置权限,说明是教务的人,可以全管,否则只能管自己函授站的 ntf为不用this assign的
                             $mdII = M('md');
                             $mdo = $mdII->where("mdmk='Stt'")->find();
                             import('@.IDTATH.IdtathAction');
                             $Idtath = new IdtathAction();
                             $athofnstt = $Idtath->identify($mdo['mdid'], 'ntf');
                             if ($xkid == 0) {
                                 $mo['xkid'] = 0;
                                 //默认年级是当前年级
                                 $grd = M('grd');
                                 $grdo = $grd->order('grdnm DESC')->find();
                                 $grdid = $grdo['grdid'];
                                 $mo['f_xk_grdid'] = $grdid;
                                 //默认站点,有主的找有主的,没主的找本部
                                 if ($athofnstt['aths'] != 1) {
                                     $mo['f_xk_sttid'] = $usro['f_usr_sttid'];
                                 } else {
                                     $mo['f_xk_sttid'] = 1;
                                 }
                                 //默认学期 为XX年级XX站点的起始学期
                                 $xq = M('xq');
                                 $xqo = $xq->where('xqdq=1')->find();
                                 $xqid = $xqo['xqid'];
                                 $sttintxq = M($grdo['grdnm'] . '_sttintxq');
                                 $sttintxqo = $sttintxq->where('f_sttintxq_grdid=' . $grdo['grdid'] . ' AND f_sttintxq_sttid=' . $mo['f_xk_sttid'])->find();
                                 if ($xqid < $sttintxqo['f_sttintxq_xqid']) {
                                     $xqid = $sttintxqo['f_sttintxq_xqid'];
                                 }
                                 //①如果激活的学期在初始学期后范围内的那么就选激活的学期②如果...在范围外的话呢就选择第初始学期为默认学期
                                 $mo['f_xk_xqid'] = $xqid;
                                 $this->assign('title', '添加');
                                 $this->assign('theme', '添加:');
                                 $this->assign('btnvl', '添加');
                             } else {
                                 $grd = M('grd');
                                 $grdo = $grd->where('grdid=' . $grdid)->find();
                                 $xk = M($grdo['grdnm'] . '_xk');
                                 $mo = $xk->join('tb_stt ON f_xk_sttid=sttid')->join('tb_grd ON f_xk_grdid=grdid')->join('tb_xq ON f_xk_xqid=xqid')->join('tb_' . $grdo['grdnm'] . '_kc ON f_xk_kcid=kcid')->join('tb_tcr ON f_xk_tcrid=tcrid')->where("xkid=" . $xkid)->find();
                                 $this->assign('title', '修改');
                                 $this->assign('theme', '修改:');
                                 $this->assign('btnvl', '修改');
                             }
                             $this->assign('mo', $mo);
                             //q特殊
                             $where = '1=1';
                             if ($athofnstt['aths'] != 1) {
                                 $where = $where . ' AND sttid=' . $usro['f_usr_sttid'];
                             }
                             $stt = M('stt');
                             $sttls = $stt->where($where)->select();
                             $this->assign('sttls', $sttls);
                             //q特殊
                             $grd = M('grd');
                             $grdls = $grd->order('grdnm DESC')->select();
                             $this->assign('grdls', $grdls);
                             import('@.XQ.XQAction');
                             $xqw = new XQAction();
                             //外来的学期
                             $xqls = $xqw->getxqls($grdo['grdid'], $mo['f_xk_sttid'], 'DESC');
                             $this->assign('xqls', $xqls);
                             //课程
                             //q特殊
                             $kc = M($grdo['grdnm'] . '_kc');
                             $kcls = $kc->where('f_kc_grdid=' . $grdo['grdid'])->select();
                             $this->assign('kcls', $kcls);
                             //教师
                             //q特殊
                             $tcr = M('tcr');
                             $tcrls = $tcr->where('f_tcr_sttid=' . $mo['f_xk_sttid'])->select();
                             $this->assign('tcrls', $tcrls);
                             $this->display('update');
                         }
                     }
                 }
             }
         }
     }
 }
Example #9
0
 function gtxpg()
 {
     //先给hd设置好些东西,他自身是无法提取的
     import('@.SS.SSAction');
     $ss = new SSAction();
     $ss->setss();
     $x = $_GET['x'];
     //鉴权 如果OK的就正常显示,或者出现查看神马的,否则就呵呵了,query he gtxpg两处
     $mdII = M('md');
     $mdo = $mdII->where("mdmk='Zscw'")->find();
     import('@.IDTATH.IdtathAction');
     $Idtath = new IdtathAction();
     $athofn = $Idtath->identify($mdo['mdid'], $x);
     import('@.NTF.NTFAction');
     $ntf = new NTFAction();
     $ntf->setntf();
     import('@.KZMB.KZMBAction');
     $kzmb = new KZMBAction();
     $kzmb->setkzmb($mdo['mdid']);
     $zssz = M('zssz');
     $zsszo = $zssz->find();
     $grdid = $zsszo['f_zssz_grdid'];
     $xqid = $zsszo['f_zssz_xqid'];
     if ($x == 'vw') {
         $cwid = $_GET['cwid'];
         $grd = M('grd');
         $grdo = $grd->where('grdid=' . $grdid)->find();
         $cwo = M($grdo['grdnm'] . '_cw')->where('cwid=' . $cwid)->find();
         $xqid = $cwo['cwzcxqid'];
         $cw = M($grdo['grdnm'] . '_cw')->join('tb_' . $grdo['grdnm'] . '_std ON f_cw_stdid=stdid')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_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');
         $mo = $cw->join('tb_xn ON f_cw_xnid=xnid')->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_dm ON f_stdxqdm_dmid=dmid')->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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_stdxqdm_xqid=" . $xqid . " AND cwid=" . $cwid)->find();
         //给专业多点修饰
         if (preg_match('/技能/', $mo['bxxsnm'])) {
             $mo['bxxsnmst'] = '技能';
         } else {
             if (preg_match('/自考/', $mo['bxxsnm'])) {
                 $mo['bxxsnmst'] = '自考';
             } else {
                 $mo['bxxsnmst'] = '普通';
             }
         }
         //需要看下如果是其他函授站的可以能要第一学期,第二学期,第三学期之类的很BT的东西
         //适应一些站点用一二三
         import('@.XQ.XQAction');
         $xqw = new XQAction();
         //外来的学期
         $xqnm = $xqw->getxqnm($grdid, $mo['f_std_sttid'], $xqid);
         $mo['xqnm'] = $xqnm;
         $mo['cwyjze'] = $mo['cwyjxfsm'] + $mo['cwyjjckwfsm'] + $mo['cwyjzsfsm'];
         $mo['cwsjze'] = $mo['cwsjxfsm'] + $mo['cwsjjckwfsm'] + $mo['cwsjzsfsm'];
         $this->assign('mo', $mo);
         //搞推荐人
         if ($mo['stdrcmdnm'] || $mo['stdrcmdcp']) {
             $this->assign('ifrcmd', '是');
         } else {
             $this->assign('ifrcmd', '否');
         }
         //特殊情况
         $tsqk = M($grdo['grdnm'] . '_tsqk');
         $tsqkls = $tsqk->where('f_tsqk_stdid=' . $stdid)->order('tsqktm DESC')->select();
         $this->assign('tsqkls', $tsqkls);
         $this->assign('title', '查看');
         $this->assign('theme', '查看详细');
         $this->display('view');
     } else {
         if ($x == 'updt') {
             $cwid = $_GET['cwid'];
             $grd = M('grd');
             $grdo = $grd->where('grdid=' . $grdid)->find();
             $cwo = M($grdo['grdnm'] . '_cw')->where('cwid=' . $cwid)->find();
             $xqid = $cwo['cwzcxqid'];
             if ($cwid == 0) {
                 // 				$mo['stdid']=0;
                 // 				$mo['stdsol']='无';
                 // 				$mo['stdpt']=C('PUBLIC').'/IMG/default.jpg';
                 // 				//第几学年 第几学期的班级 第几学年 第几学期的专业 ...
                 // 				//因为grd无法定下来,所以stdxqcls stdxqmj_xqid 定下来也没有意义,干脆就不定了,等搜索时候自由分晓
                 // 				//默认年级是当前年级
                 // 				$grd=M('grd');
                 // 				$grdo=$grd->order('grdnm DESC')->find();
                 // 				$grdid=$grdo['grdid'];
                 // 				$mo['f_std_grdid']=$grdid;
                 // 				$mo['grdnm']=$grdo['grdnm'];
                 // 				//默认站点,有主的找有主的,没主的找本部
                 // 				if($athofnstt['aths']!=1){
                 // 					$mo['f_std_sttid']=$usro['f_usr_sttid'];
                 // 				}else{
                 // 					$mo['f_std_sttid']=1;
                 // 				}
                 // 				//默认学期 为XX年级XX站点的起始学期
                 // 				$sttintxq=M($grdo['grdnm'].'_sttintxq');
                 // 				$sttintxqo=$sttintxq->where('f_sttintxq_grdid='.$grdo['grdid'].' AND f_sttintxq_sttid='.$mo['f_std_sttid'])->find();
                 // 				$xqid=$sttintxqo['f_sttintxq_xqid'];
                 // 				$mo['f_stdxqcls_xqid']=$xqid;
                 // 				$mo['f_stdxqmj_xqid']=$xqid;
                 // 				$this->assign('title','添加');
                 // 				$this->assign('theme','添加:');
                 // 				$this->assign('btnvl','添加');
                 // 				//q特殊
                 // 				$xq=M('xq');
                 // 				$xqls=$xq->where('xqid='.$xqid)->select();//我TMD就为了一个置顶的xq来了
                 // 				$this->assign('xqls',$xqls);
                 // 				$where='1=1';
                 // 				if($athofnstt['aths']!=1){
                 // 					$where=$where.' AND f_cls_sttid='.$usro['f_usr_sttid'];
                 // 				}
                 // 				//之前已经确定过到底是看哪个年级
                 // 				$where=$where.' AND f_cls_grdid='.$grdid;
                 // 				$cls=M($grdo['grdnm'].'_cls');
                 // 				$clsls=$cls->join('tb_stt ON f_cls_sttid=sttid')->where($where)->order('clsnm ASC')->select();
                 // 				$this->assign('clsls',$clsls);
                 // 				$where='1=1';
                 // 				if($athofnstt['aths']!=1){
                 // 					$where=$where." AND mjsttu LIKE '%-".$usro['f_usr_sttid']."-%'";
                 // 				}
                 // 				//之前已经确定过到底是看哪个年级
                 // 				$where=$where.' AND f_mj_grdid='.$grdid;
                 // 				$mj=M($grdo['grdnm'].'_mj');
                 // 				$mjls=$mj->join('tb_bxxs ON f_mj_bxxsid=bxxsid')->where($where)->order('f_mj_bxxsid ASC,mjdm ASC')->select();
                 // 				$mjlsnw=array();
                 // 				foreach($mjls as $v){
                 // 					//给专业多点修饰
                 // 					if(preg_match('/技能/',$v['bxxsnm'])){
                 // 						$v['bxxsnmst']='技能';
                 // 					}else if(preg_match('/自考/',$v['bxxsnm'])){
                 // 						$v['bxxsnmst']='自考';
                 // 					}else{
                 // 						$v['bxxsnmst']='普通';
                 // 					}
                 // 					array_push($mjlsnw, $v);
                 // 				}
                 // 				$this->assign('mjls',$mjlsnw);
             } else {
                 $grd = M('grd');
                 $cw = M($grdo['grdnm'] . '_cw')->join('tb_' . $grdo['grdnm'] . '_std ON f_cw_stdid=stdid')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_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');
                 $mo = $cw->join('tb_xn ON f_cw_xnid=xnid')->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_dm ON f_stdxqdm_dmid=dmid')->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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_stdxqdm_xqid=" . $xqid . " AND cwid=" . $cwid)->find();
                 if (preg_match('/技能/', $mo['bxxsnm'])) {
                     $mo['bxxsnmst'] = '技能';
                 } else {
                     if (preg_match('/自考/', $mo['bxxsnm'])) {
                         $mo['bxxsnmst'] = '自考';
                     } else {
                         $mo['bxxsnmst'] = '普通';
                     }
                 }
                 $mo['cwyjze'] = $mo['cwyjxfsm'] + $mo['cwyjjckwfsm'] + $mo['cwyjzsfsm'];
                 $mo['cwsjze'] = $mo['cwsjxfsm'] + $mo['cwsjjckwfsm'] + $mo['cwsjzsfsm'];
                 $this->assign('title', '修改');
                 $this->assign('theme', '修改:');
                 $this->assign('btnvl', '修改');
                 //特殊情况
                 $tsqk = M($grdo['grdnm'] . '_tsqk');
                 $tsqkls = $tsqk->where('f_tsqk_stdid=' . $mo['f_cw_stdid'])->order('tsqktm DESC')->select();
                 $this->assign('tsqkls', $tsqkls);
             }
             $this->assign('mo', $mo);
             $this->display('update');
         } else {
             if ($x = 'cwdtfx') {
                 $xqiddq = $xqid;
                 $bxxs = M('bxxs');
                 $bxxsls = $bxxs->select();
                 $dm = M('dm');
                 $dmls = $dm->select();
                 //先分开算再合起来
                 $grd = M('grd');
                 $grdls = $grd->where('grdid=' . $grdid)->order('grdnm DESC')->select();
                 $grdlsfn = array();
                 foreach ($grdls as $grdv) {
                     $zl = array();
                     //资料
                     $cw = M($grdv['grdnm'] . '_cw');
                     if ($cw->join('tb_' . $grdv['grdnm'] . '_std ON f_cw_stdid=stdid')->where('f_std_statid<>9')->count() == 0) {
                         continue;
                     }
                     $zongnb = $cw->join('tb_' . $grdv['grdnm'] . '_std ON f_cw_stdid=stdid')->where('f_std_statid<>9')->count();
                     $zl['zongnb'] = $zongnb;
                     //
                     $wjfnb = $cw->join('tb_' . $grdv['grdnm'] . '_std ON f_cw_stdid=stdid')->where('f_std_statid<>9 AND cwsjxfsm+cwsjjckwfsm+cwsjzsfsm=0')->count();
                     $zl['wjfnb'] = $wjfnb;
                     //未交费
                     $bfjnb = $cw->join('tb_' . $grdv['grdnm'] . '_std ON f_cw_stdid=stdid')->where('f_std_statid<>9 AND cwyjxfsm+cwyjjckwfsm+cwyjzsfsm>cwsjxfsm+cwsjjckwfsm+cwsjzsfsm AND cwsjxfsm+cwsjjckwfsm+cwsjzsfsm>0')->count();
                     $zl['bfjnb'] = $bfjnb;
                     //部分缴
                     $yjqnb = $cw->join('tb_' . $grdv['grdnm'] . '_std ON f_cw_stdid=stdid')->where('f_std_statid<>9 AND cwyjxfsm+cwyjjckwfsm+cwyjzsfsm=cwsjxfsm+cwsjjckwfsm+cwsjzsfsm')->count();
                     $zl['yjqnb'] = $yjqnb;
                     //已缴清
                     $grdv['zl'] = $zl;
                     array_push($grdlsfn, $grdv);
                 }
                 $this->assign('grdls', $grdlsfn);
                 $this->assign('title', '招生财务数据分析');
                 $this->assign('theme', '招生财务数据分析详细');
                 $this->display('cwdtfx');
             }
         }
     }
 }
Example #10
0
 function gtxpg()
 {
     //先给hd设置好些东西,他自身是无法提取的
     import('@.SS.SSAction');
     $ss = new SSAction();
     $ss->setss();
     $x = $_GET['x'];
     if ($x == 'vw') {
         if ($_GET['bmcg']) {
             $this->assign('bmcg', 'y');
         }
         $zssz = M('zssz');
         $zsszo = $zssz->find();
         $grdid = $zsszo['f_zssz_grdid'];
         $xqid = $zsszo['f_zssz_xqid'];
         $stdid = $_GET['stdid'];
         $grd = M('grd');
         $grdo = $grd->where('grdid=' . $grdid)->find();
         $std = M($grdo['grdnm'] . '_std')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_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');
         $mo = $std->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_dm ON f_stdxqdm_dmid=dmid')->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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_stdxqdm_xqid=" . $xqid . " AND stdid=" . $stdid)->find();
         //给专业多点修饰
         if (preg_match('/技能/', $mo['bxxsnm'])) {
             $mo['bxxsnmst'] = '技能';
         } else {
             if (preg_match('/自考/', $mo['bxxsnm'])) {
                 $mo['bxxsnmst'] = '自考';
             } else {
                 $mo['bxxsnmst'] = '普通';
             }
         }
         //需要看下如果是其他函授站的可以能要第一学期,第二学期,第三学期之类的很BT的东西
         //适应一些站点用一二三
         import('@.XQ.XQAction');
         $xqw = new XQAction();
         //外来的学期
         $xqnm = $xqw->getxqnm($grdid, $mo['f_std_sttid'], $xqid);
         $mo['xqnm'] = $xqnm;
         $this->assign('mo', $mo);
         //搞推荐人
         if ($mo['stdrcmdnm'] || $mo['stdrcmdcp']) {
             $this->assign('ifrcmd', '是');
         } else {
             $this->assign('ifrcmd', '否');
         }
         // 			//所有的注册信息,哪个学期哪个班哪个专业
         // 			//应该具备哪些注册信息
         // 			//学期
         // 			import('@.XQ.XQAction');
         // 			$xqw = new XQAction();//外来的学期
         // 			$xqls=$xqw->getxqls($grdid, $mo['f_std_sttid'], 'ASC');//年级确定开始,学制确定过程
         // 			$stdxqcls=M($grdo['grdnm'].'_stdxqcls');
         // 			$stdxqmj=M($grdo['grdnm'].'_stdxqmj');
         // 			for($i=0;$i<count($xqls);$i++){
         // 				$xqid=$xqls[$i]['xqid'];
         // 				if($stdxqcls->where('f_stdxqcls_stdid='.$stdid.' AND f_stdxqcls_xqid='.$xqid)->find()&&$stdxqmj->where('f_stdxqmj_stdid='.$stdid.' AND f_stdxqmj_xqid='.$xqid)->find()){
         // 					$xqls[$i]['zcf']='active';//注册否?
         // 					$xqls[$i]['zczt']='已注册';
         // 				}else{
         // 					$xqls[$i]['zcf']='disabled';
         // 					$xqls[$i]['zczt']='未注册';
         // 				}
         // 				$stdxqclso=$stdxqcls->join('tb_'.$grdo['grdnm'].'_cls ON f_stdxqcls_clsid=clsid')->where('f_stdxqcls_stdid='.$stdid.' AND f_stdxqcls_xqid='.$xqid)->find();
         // 				$stdxqmjo=$stdxqmj->join('tb_'.$grdo['grdnm'].'_mj ON f_stdxqmj_mjid=mjid')->where('f_stdxqmj_stdid='.$stdid.' AND f_stdxqmj_xqid='.$xqid)->find();
         // 				$xqls[$i]['clsnm']=$stdxqclso['clsnm'];
         // 				$xqls[$i]['mjnm']=$stdxqmjo['mjnm'];
         // 			}
         // 			$this->assign('zcls',$xqls);//注册列表
         //特殊情况
         $tsqk = M($grdo['grdnm'] . '_tsqk');
         $tsqkls = $tsqk->where('f_tsqk_stdid=' . $stdid)->order('tsqktm DESC')->select();
         $this->assign('tsqkls', $tsqkls);
         $this->assign('title', '查看');
         $this->assign('theme', '查看详细');
         $this->display('view');
     } else {
         if ($x == 'updt') {
             $zssz = M('zssz');
             $zsszo = $zssz->find();
             $grdid = $zsszo['f_zssz_grdid'];
             $xqid = $zsszo['f_zssz_xqid'];
             $stdid = $_GET['stdid'];
             if ($stdid == 0) {
                 $mo['stdid'] = 0;
                 $mo['stdsol'] = '无';
                 $mo['stdpt'] = C('PUBLIC') . '/IMG/default.jpg';
                 //第几学年 第几学期的班级 第几学年 第几学期的专业 ...
                 //因为grd无法定下来,所以stdxqcls stdxqmj_xqid 定下来也没有意义,干脆就不定了,等搜索时候自由分晓
                 //默认年级是当前年级
                 $grd = M('grd');
                 $grdo = $grd->where('grdid=' . $zsszo['f_zssz_grdid'])->find();
                 $mo['grdnm'] = $grdo['grdnm'];
                 $this->assign('title', '报名');
                 $this->assign('theme', '报名(填写基本信息&选择专业)');
                 $this->assign('btnvl', '报名');
                 $where = '1=1';
                 $where = $where . ' AND f_cls_sttid=1';
                 //之前已经确定过到底是看哪个年级
                 $where = $where . ' AND f_cls_grdid=' . $grdid;
                 $cls = M($grdo['grdnm'] . '_cls');
                 $clsls = $cls->join('tb_stt ON f_cls_sttid=sttid')->where($where)->order('clsnm ASC')->select();
                 $this->assign('clsls', $clsls);
                 $where = '1=1 AND mjbbzs=1';
                 $where = $where . " AND mjsttu LIKE '%-1-%'";
                 $tmp = explode('-', $zsszo['zsszbxxsu']);
                 $wr = ' AND (1=2';
                 for ($i = 1; $i < count($tmp) - 1; $i++) {
                     $wr = $wr . ' OR f_mj_bxxsid=' . $tmp[$i];
                 }
                 $wr = $wr . ')';
                 $where = $where . $wr;
                 //之前已经确定过到底是看哪个年级
                 $where = $where . ' AND f_mj_grdid=' . $grdid;
                 $mj = M($grdo['grdnm'] . '_mj');
                 $mjls = $mj->select();
                 $mjls = $mj->join('tb_bxxs ON f_mj_bxxsid=bxxsid')->join('tb_kl ON f_mj_klid=klid')->where($where)->order('f_mj_bxxsid ASC,mjdm ASC')->select();
                 $mjlsnw = array();
                 foreach ($mjls as $v) {
                     //给专业多点修饰
                     if (preg_match('/技能/', $v['bxxsnm'])) {
                         $v['bxxsnmst'] = '技能';
                     } else {
                         if (preg_match('/自考/', $v['bxxsnm'])) {
                             $v['bxxsnmst'] = '自考';
                         } else {
                             $v['bxxsnmst'] = '普通';
                         }
                     }
                     array_push($mjlsnw, $v);
                 }
                 $this->assign('mjls', $mjlsnw);
             } else {
                 $grd = M('grd');
                 $grdo = $grd->where('grdid=' . $grdid)->find();
                 $std = M($grdo['grdnm'] . '_std')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_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');
                 $mo = $std->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_dm ON f_stdxqdm_dmid=dmid')->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=' . $xqid . ' AND f_stdxqmj_xqid=' . $xqid . ' AND f_stdxqdm_xqid=' . $xqid . " AND stdid=" . $stdid)->find();
                 $this->assign('title', '修改');
                 $this->assign('theme', '修改:');
                 $this->assign('btnvl', '修改');
                 //q特殊
                 import('@.XQ.XQAction');
                 $xqw = new XQAction();
                 //外来的学期
                 $xqls = $xqw->getxqls($grdo['grdid'], $mo['f_std_sttid'], 'DESC');
                 $this->assign('xqls', $xqls);
                 $where = '1=1';
                 $where = $where . ' AND f_cls_sttid=' . $mo['f_std_sttid'];
                 //之前已经确定过到底是看哪个年级
                 $where = $where . ' AND f_cls_grdid=' . $grdid;
                 $cls = M($grdo['grdnm'] . '_cls');
                 $clsls = $cls->join('tb_stt ON f_cls_sttid=sttid')->where($where)->order('clsnm ASC')->select();
                 $this->assign('clsls', $clsls);
                 $where = '1=1';
                 $where = $where . " AND mjsttu LIKE '%-" . $mo['f_std_sttid'] . "-%' AND f_mj_bxxsid=" . $mo['f_mj_bxxsid'];
                 //之前已经确定过到底是看哪个年级
                 $where = $where . ' AND f_mj_grdid=' . $grdid;
                 $mj = M($grdo['grdnm'] . '_mj');
                 $mjls = $mj->join('tb_bxxs ON f_mj_bxxsid=bxxsid')->where($where)->order('f_mj_bxxsid ASC,mjdm ASC')->select();
                 $mjlsnw = array();
                 foreach ($mjls as $v) {
                     //给专业多点修饰
                     if (preg_match('/技能/', $v['bxxsnm'])) {
                         $v['bxxsnmst'] = '技能';
                     } else {
                         if (preg_match('/自考/', $v['bxxsnm'])) {
                             $v['bxxsnmst'] = '自考';
                         } else {
                             $v['bxxsnmst'] = '普通';
                         }
                     }
                     array_push($mjlsnw, $v);
                 }
                 $this->assign('mjls', $mjlsnw);
                 //所有的注册信息,哪个学期哪个班哪个专业
                 //应该具备哪些注册信息
                 //学期
                 import('@.XQ.XQAction');
                 $xqw = new XQAction();
                 //外来的学期
                 $xqls = $xqw->getxqls($grdid, $mo['f_std_sttid'], 'ASC');
                 //年级确定开始,学制确定过程
                 $stdxqcls = M($grdo['grdnm'] . '_stdxqcls');
                 $stdxqmj = M($grdo['grdnm'] . '_stdxqmj');
                 for ($i = 0; $i < count($xqls); $i++) {
                     $xqid = $xqls[$i]['xqid'];
                     if ($stdxqcls->where('f_stdxqcls_stdid=' . $stdid . ' AND f_stdxqcls_xqid=' . $xqid)->find() && $stdxqmj->where('f_stdxqmj_stdid=' . $stdid . ' AND f_stdxqmj_xqid=' . $xqid)->find()) {
                         $xqls[$i]['zcf'] = 'active';
                         //注册否?
                         $xqls[$i]['zczt'] = '已注册';
                     } else {
                         $xqls[$i]['zcf'] = 'disabled';
                         $xqls[$i]['zczt'] = '未注册';
                     }
                     $stdxqclso = $stdxqcls->join('tb_' . $grdo['grdnm'] . '_cls ON f_stdxqcls_clsid=clsid')->where('f_stdxqcls_stdid=' . $stdid . ' AND f_stdxqcls_xqid=' . $xqid)->find();
                     $stdxqmjo = $stdxqmj->join('tb_' . $grdo['grdnm'] . '_mj ON f_stdxqmj_mjid=mjid')->where('f_stdxqmj_stdid=' . $stdid . ' AND f_stdxqmj_xqid=' . $xqid)->find();
                     $xqls[$i]['clsnm'] = $stdxqclso['clsnm'];
                     $xqls[$i]['mjnm'] = $stdxqmjo['mjnm'];
                 }
                 $this->assign('zcls', $xqls);
                 //注册列表
                 //特殊情况
                 $tsqk = M($grdo['grdnm'] . '_tsqk');
                 $tsqkls = $tsqk->where('f_tsqk_stdid=' . $stdid)->order('tsqktm DESC')->select();
                 $this->assign('tsqkls', $tsqkls);
             }
             $this->assign('mo', $mo);
             $tmp = explode('-', $zsszo['zsszbxxsu']);
             $where = '1=1';
             $wr = ' AND (1=2';
             for ($i = 1; $i < count($tmp) - 1; $i++) {
                 $wr = $wr . ' OR bxxsid=' . $tmp[$i];
             }
             $wr = $wr . ')';
             $where = $where . $wr;
             //q特殊
             $bxxs = M('bxxs');
             $bxxsls = $bxxs->where($where)->select();
             if (count($bxxsls) == 1) {
                 $this->assign('bxxssg', 'y');
             } else {
                 $this->assign('bxxssg', 'n');
             }
             //bxxs single
             $this->assign('bxxsls', $bxxsls);
             //q特殊
             $sex = M('sex');
             $sexls = $sex->select();
             $this->assign('sexls', $sexls);
             //q特殊
             $rc = M('rc');
             $rcls = $rc->select();
             $this->assign('rcls', $rcls);
             //q特殊
             $zzmm = M('zzmm');
             $zzmmls = $zzmm->select();
             $this->assign('zzmmls', $zzmmls);
             //q特殊
             $xl = M('xl');
             $xlls = $xl->select();
             $this->assign('xlls', $xlls);
             $dm = M('dm');
             $dmls = $dm->select();
             $this->assign('dmls', $dmls);
             //q特殊
             $stat = M('stat');
             $statls = $stat->select();
             $this->assign('statls', $statls);
             //搞介绍人
             if ($mo['stdrcmdnm'] || $mo['stdrcmdcp']) {
                 $this->assign('ifrcmd', '是');
                 $this->assign('rcmdcls', '');
             } else {
                 $this->assign('ifrcmd', '否');
                 $this->assign('rcmdcls', 'readonly');
             }
             $this->display('update');
         } else {
             if ($x == 'ylqtz') {
                 $zssz = M('zssz');
                 $zsszo = $zssz->find();
                 $grdid = $zsszo['f_zssz_grdid'];
                 $xqid = $zsszo['f_zssz_xqid'];
                 //根据学期获得学年
                 $xq = M('xq');
                 $xqo = $xq->where('xqid=' . $xqid)->find();
                 if (preg_match('/第1学期/', $xqo['xqnm'])) {
                     $tmp = explode('-', $xqo[xqnm]);
                     $xnnm = $tmp[0];
                 } else {
                     $tmp = explode('-', $xqo[xqnm]);
                     $tmp = explode('学年', $tmp[1]);
                     $xnnm = $tmp[0];
                 }
                 $xn = M('xn');
                 $xno = $xn->where("xnnm='" . $xnnm . "'")->find();
                 $stdid = session('stdidss');
                 $grd = M('grd');
                 $grdo = $grd->where('grdid=' . $grdid)->find();
                 $cwo = M($grdo['grdnm'] . '_cw')->where('f_cw_stdid=' . $stdid . ' AND f_cw_xnid=' . $xno['xnid'])->find();
                 $cwid = $cwo['cwid'];
                 $xqid = $cwo['cwzcxqid'];
                 $cw = M($grdo['grdnm'] . '_cw')->join('tb_' . $grdo['grdnm'] . '_std ON f_cw_stdid=stdid')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_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');
                 $mo = $cw->join('tb_xn ON f_cw_xnid=xnid')->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_dm ON f_stdxqdm_dmid=dmid')->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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_stdxqdm_xqid=" . $xqid . " AND cwid=" . $cwid)->find();
                 //给专业多点修饰
                 if (preg_match('/技能/', $mo['bxxsnm'])) {
                     $mo['bxxsnmst'] = '技能';
                 } else {
                     if (preg_match('/自考/', $mo['bxxsnm'])) {
                         $mo['bxxsnmst'] = '自考';
                     } else {
                         $mo['bxxsnmst'] = '普通';
                     }
                 }
                 //需要看下如果是其他函授站的可以能要第一学期,第二学期,第三学期之类的很BT的东西
                 //适应一些站点用一二三
                 import('@.XQ.XQAction');
                 $xqw = new XQAction();
                 //外来的学期
                 $xqnm = $xqw->getxqnm($grdid, $mo['f_std_sttid'], $xqid);
                 $mo['xqnm'] = $xqnm;
                 $mo['cwyjze'] = $mo['cwyjxfsm'] + $mo['cwyjjckwfsm'] + $mo['cwyjzsfsm'];
                 $mo['cwsjze'] = $mo['cwsjxfsm'] + $mo['cwsjjckwfsm'] + $mo['cwsjzsfsm'];
                 $this->assign('mo', $mo);
                 //添加缴费信息1、学费教材考务费2、住宿费
                 $mj = M($grdo['grdnm'] . '_mj');
                 $mjo = $mj->where('mjid=' . $mo['f_stdxqmj_mjid'])->find();
                 $xf = M($grdo['grdnm'] . '_xf');
                 $xfo = $xf->where('f_xf_sttid=' . $mo['f_std_sttid'] . ' AND f_xf_bxxsid=' . $mjo['f_mj_bxxsid'] . ' AND f_xf_ccid=' . $mjo['f_mj_ccid'] . ' AND f_xf_klid=' . $mjo['f_mj_klid'])->find();
                 $zsf = M($grdo['grdnm'] . '_zsf');
                 $zsfo = $zsf->where('f_zsf_dmid=' . $mo['f_stdxqdm_dmid'])->find();
                 $this->assign('xfo', $xfo);
                 $this->assign('zsfo', $zsfo);
                 $this->assign('title', '预录取通知书电子版');
                 $this->assign('theme', '预录取通知书电子版');
                 $this->display('ylqtz');
             } else {
                 if ($x == 'center') {
                     if ($_GET['bmcg']) {
                         $this->assign('bmcg', 'y');
                     }
                     $zssz = M('zssz');
                     $zsszo = $zssz->find();
                     $grdid = $zsszo['f_zssz_grdid'];
                     $xqid = $zsszo['f_zssz_xqid'];
                     $stdid = session('stdidss');
                     $grd = M('grd');
                     $grdo = $grd->where('grdid=' . $grdid)->find();
                     $std = M($grdo['grdnm'] . '_std')->join('inner join tb_' . $grdo['grdnm'] . '_stdxqdm ON stdid=f_stdxqdm_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');
                     $mo = $std->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_dm ON f_stdxqdm_dmid=dmid')->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=" . $xqid . " AND f_stdxqmj_xqid=" . $xqid . " AND f_stdxqdm_xqid=" . $xqid . " AND stdid=" . $stdid)->find();
                     //给专业多点修饰
                     if (preg_match('/技能/', $mo['bxxsnm'])) {
                         $mo['bxxsnmst'] = '技能';
                     } else {
                         if (preg_match('/自考/', $mo['bxxsnm'])) {
                             $mo['bxxsnmst'] = '自考';
                         } else {
                             $mo['bxxsnmst'] = '普通';
                         }
                     }
                     //需要看下如果是其他函授站的可以能要第一学期,第二学期,第三学期之类的很BT的东西
                     //适应一些站点用一二三
                     import('@.XQ.XQAction');
                     $xqw = new XQAction();
                     //外来的学期
                     $xqnm = $xqw->getxqnm($grdid, $mo['f_std_sttid'], $xqid);
                     $mo['xqnm'] = $xqnm;
                     $this->assign('mo', $mo);
                     //搞推荐人
                     if ($mo['stdrcmdnm'] || $mo['stdrcmdcp']) {
                         $this->assign('ifrcmd', '是');
                     } else {
                         $this->assign('ifrcmd', '否');
                     }
                     //特殊情况
                     $tsqk = M($grdo['grdnm'] . '_tsqk');
                     $tsqkls = $tsqk->where('f_tsqk_stdid=' . $stdid)->order('tsqktm DESC')->select();
                     $this->assign('tsqkls', $tsqkls);
                     $this->assign('title', '个人中心');
                     $this->assign('theme', '个人中心');
                     $this->display('center');
                 }
             }
         }
     }
 }
Example #11
0
 function query()
 {
     header("Content-Type:text/html; charset=utf-8");
     //先给hd设置好些东西,他自身是无法提取的
     import('@.SS.SSAction');
     $ss = new SSAction();
     $ss->setss();
     //鉴权 如果OK的就正常显示,或者出现查看神马的,否则就呵呵了,query he gtxpg两处
     $mdII = M('md');
     $mdo = $mdII->where("mdmk='Pl'")->find();
     import('@.IDTATH.IdtathAction');
     $Idtath = new IdtathAction();
     $athofn = $Idtath->identify($mdo['mdid'], 'qry');
     import('@.NTF.NTFAction');
     $ntf = new NTFAction();
     $ntf->setntf();
     import('@.KZMB.KZMBAction');
     $kzmb = new KZMBAction();
     $kzmb->setkzmb($mdo['mdid']);
     //鉴权对用户对stt的权限,若为设置权限,说明是教务的人,可以全管,否则只能管自己函授站的 ntf为不用this assign的
     $mdII = M('md');
     $mdo = $mdII->where("mdmk='Stt'")->find();
     import('@.IDTATH.IdtathAction');
     $Idtath = new IdtathAction();
     $athofnstt = $Idtath->identify($mdo['mdid'], 'ntf');
     $usr = M('usr');
     $usro = $usr->where('usrid=' . session('usridss'))->find();
     //第几学年 第几学期的班级 第几学年 第几学期的专业 ...
     //因为grd无法定下来,所以stdxqcls stdxqmj_xqid 定下来也没有意义,干脆就不定了,等搜索时候自由分晓
     //NB初始化,开始
     $cdt = $_GET['cdt'];
     $grd = M('grd');
     if (preg_match('/f_std_grdid/', $cdt)) {
         //获取该键的值
         $tmp = explode('f_std_grdid', $cdt);
         $tmp = explode('-eq-', $tmp[1]);
         $tmp = explode('-sp-', $tmp[1]);
         $grdid = $tmp[0];
     } else {
         //默认grdid
         $grdo = $grd->order('grdid DESC')->find();
         $grdid = $grdo['grdid'];
     }
     $grdo = $grd->where('grdid=' . $grdid)->find();
     $this->assign('grdid', $grdid);
     $std = M($grdo['grdnm'] . '_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');
     $fldint = '-stdid-f_std_grdid-grdnm-f_std_sttid-sttnm-f_stdxqcls_xqid-xqnm-f_stdxqcls_clsid-bxxsnm-clsnm-stdno-stdnm-sexnm-';
     //默认学期,
     $xq = M('xq');
     $xqo = $xq->where('xqdq=1')->find();
     $xqid = $xqo['xqid'];
     if ($athofnstt['aths'] == 1) {
         $f_usr_sttid = 1;
         $sttintxq = M($grdo['grdnm'] . '_sttintxq');
         $sttintxqo = $sttintxq->where('f_sttintxq_grdid=' . $grdo['grdid'] . ' AND f_sttintxq_sttid=' . $f_usr_sttid)->find();
         if ($xqid < $sttintxqo['f_sttintxq_xqid']) {
             $xqid = $sttintxqo['f_sttintxq_xqid'];
         }
         //①如果激活的学期在初始学期后范围内的那么就选激活的学期②如果...在范围外的话呢就选择第初始学期为默认学期
         $cdtint = "-sp-f_std_grdid-eq-" . $grdid . "-sp-f_std_sttid-eq-" . $f_usr_sttid . "-sp-f_std_statid-eq-5-sp-f_stdxqcls_xqid-eq-" . $xqid . "-sp-f_stdxqmj_xqid-eq-" . $xqid . '-sp-';
         //接下来产生学期
     } else {
         $f_usr_sttid = $usro['f_usr_sttid'];
         $sttintxq = M($grdo['grdnm'] . '_sttintxq');
         $sttintxqo = $sttintxq->where('f_sttintxq_grdid=' . $grdo['grdid'] . ' AND f_sttintxq_sttid=' . $f_usr_sttid)->find();
         if ($xqid < $sttintxqo['f_sttintxq_xqid']) {
             $xqid = $sttintxqo['f_sttintxq_xqid'];
         }
         //①如果激活的学期在初始学期后范围内的那么就选激活的学期②如果...在范围外的话呢就选择第初始学期为默认学期
         $cdtint = "-sp-f_std_grdid-eq-" . $grdid . "-sp-f_std_sttid-eq-" . $f_usr_sttid . "-sp-f_std_statid-eq-5-sp-f_stdxqcls_xqid-eq-" . $xqid . "-sp-f_stdxqmj_xqid-eq-" . $xqid . '-sp-';
         //接下来产生学期
     }
     if (preg_match('/f_stdxqcls_xqid/', $cdt)) {
         //获取该键的值
         $tmp = explode('f_stdxqcls_xqid', $cdt);
         $tmp = explode('-eq-', $tmp[1]);
         $tmp = explode('-sp-', $tmp[1]);
         $xqid = $tmp[0];
     }
     $this->assign('xqid', $xqid);
     if (preg_match('/f_std_sttid/', $cdt)) {
         //获取该键的值
         $tmp = explode('f_std_sttid', $cdt);
         $tmp = explode('-eq-', $tmp[1]);
         $tmp = explode('-sp-', $tmp[1]);
         $sttid = $tmp[0];
     }
     $this->assign('sttid', $sttid);
     if (preg_match('/f_stdxqcls_clsid/', $cdt)) {
         //获取该键的值
         $tmp = explode('f_stdxqcls_clsid', $cdt);
         $tmp = explode('-eq-', $tmp[1]);
         $tmp = explode('-sp-', $tmp[1]);
         $clsid = $tmp[0];
     }
     $this->assign('clsid', $clsid);
     import('@.XQ.XQAction');
     $xqw = new XQAction();
     //外来的学期
     $xqnm = $xqw->getxqnm($grdid, $sttid, $xqid);
     $this->assign('xqnmsx', $xqnm);
     //sx 筛选
     $stt = M('stt');
     $stto = $stt->where('sttid=' . $sttid)->find();
     $this->assign('sttnmsx', $stto['sttnm']);
     $cls = M($grdo['grdnm'] . '_cls');
     $clso = $cls->where('clsid=' . $clsid)->find();
     $this->assign('clsnmsx', $clso['clsnm']);
     $spccdtint = '-sp-';
     ////
     $odrint = '-f_mj_bxxsid ASC-clsid ASC-mjid ASC-stdno ASC-';
     $lmtint = 100;
     $jn = 'tb_stt ON f_std_sttid=sttid-jn-tb_grd ON f_std_grdid=grdid-jn-tb_' . $grdo['grdnm'] . '_mj ON f_stdxqmj_mjid=mjid-jn-tb_bxxs ON f_mj_bxxsid=bxxsid-jn-tb_cc ON f_mj_ccid=ccid-jn-tb_kl ON f_mj_klid=klid-jn-tb_xxxs ON f_mj_xxxsid=xxxsid-jn-tb_zsfw ON f_mj_zsfwid=zsfwid-jn-tb_xz ON f_mj_xzid=xzid-jn-tb_' . $grdo['grdnm'] . '_cls ON f_stdxqcls_clsid=clsid-jn-tb_sex ON f_std_sexid=sexid-jn-tb_rc ON f_std_rcid=rcid-jn-tb_zzmm ON f_std_zzmmid=zzmmid-jn-tb_xl ON f_std_xlid=xlid-jn-tb_stat ON f_std_statid=statid-jn-tb_xq ON f_stdxqcls_xqid=xqid';
     import('@.NB.NBAction');
     $NB = new NBAction();
     $arr = $NB->NB($std, $fldint, $cdtint, $spccdtint, $odrint, $lmtint, $jn);
     ////
     if (preg_match('/f_stdxqcls_clsid/', $arr['cdt'])) {
         $tmp = explode('f_stdxqcls_clsid', $cdt);
         $tmp = explode('-eq-', $tmp[1]);
         $tmp = explode('-sp-', $tmp[1]);
         $clsid = $tmp[0];
         //判断std所在的班级,当前人员能否修改。。。其实就是看他是教务的还是管理员还是他亲生班主任
         $mls = $arr['mls'];
         $bzr = M($grdo['grdnm'] . '_bzr');
         $mlsfn = array();
         $cjzx = M($grdo['grdnm'] . '_cjzx');
         //获取有多少该班最多有多少门课
         $pkidls = $cjzx->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=" . $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();
         $iforcnt = 0;
         foreach ($mls as $v) {
             $iforcnt++;
             $v['xh'] = $iforcnt;
             $bzro = $bzr->where('f_bzr_clsid=' . $v['f_stdxqcls_clsid'])->find();
             if ($athofn['aths'] == 1 || session('usridss') == $bzro['f_bzr_usrid']) {
                 //aths==1说明是教务的人或者是管理员
                 $v['mdf'] = 1;
             } else {
                 $v['mdf'] = 0;
             }
             $cjzxls = array();
             foreach ($pkls as $vI) {
                 $cjzxo = $cjzx->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')->where('f_cjzx_grdid=' . $grdid . ' AND f_cjzx_sttid=' . $sttid . ' AND f_cjzx_xqid=' . $xqid . ' AND f_cjzx_stdid=' . $v['stdid'] . ' AND f_cjzx_pkid=' . $vI['pkid'])->find();
                 if ($cjzxo) {
                     if ($cjzxo['cjzxsftj'] == 0) {
                         if ($cjzxo['cjzxxk'] == 0 && $cjzxo['cjzxqk'] == 0 && $cjzxo['cjzxhk'] == 0) {
                             $cjzxo['cjzxzf'] = '';
                         }
                     }
                 } else {
                     $cjzxo['cjzxzf'] = '未选该课';
                 }
                 array_push($cjzxls, $cjzxo);
             }
             $v['cjzxls'] = $cjzxls;
             //查看是否有评论过
             $pl = M($grdo['grdnm'] . '_pl');
             if ($pl->where('f_pl_grdid=' . $grdid . ' AND f_pl_sttid=' . $sttid . ' AND f_pl_xqid=' . $xqid . ' AND f_pl_stdid=' . $v['stdid'])->find()) {
                 $plo = $pl->where('f_pl_grdid=' . $grdid . ' AND f_pl_sttid=' . $sttid . ' AND f_pl_xqid=' . $xqid . ' AND f_pl_stdid=' . $v['stdid'])->find();
                 $v['plid'] = $plo['plid'];
             } else {
                 $v['plid'] = 0;
             }
             array_push($mlsfn, $v);
         }
         //已最后一个学生选课为例
         $this->assign('pkls', $pkls);
         $this->assign('mls', $mlsfn);
         $this->assign('page_method', $arr['page_method']);
     }
     $this->assign('fstrw', $arr['fstrw']);
     $this->assign('sqlstc', $arr['sqlstc']);
     $this->assign('fld', $arr['fld']);
     $this->assign('cdt', $arr['cdt']);
     $this->assign('spccdt', $arr['spccdt']);
     ////
     $this->assign('odr', $arr['odr']);
     $this->assign('lmt', $arr['lmt']);
     $this->assign('count', $arr['count']);
     //NB初始化,结束
     //q特殊
     $grd = M('grd');
     $grdls = $grd->order('grdnm DESC')->select();
     $this->assign('grdls', $grdls);
     $stt = M('stt');
     //因为你站点可能木有了,但是站点已经招的学生阔能还在,因此要保留站点
     if ($athofnstt['aths'] == 1) {
         $sttls = $stt->select();
     } else {
         $sttls = $stt->where('sttid=' . $usro['f_usr_sttid'])->select();
     }
     $this->assign('sttls', $sttls);
     //q特殊
     $xq = M('xq');
     if (preg_match('/f_std_sttid/', $cdt)) {
         //获取该键的值
         $tmp = explode('f_std_sttid', $cdt);
         $tmp = explode('-eq-', $tmp[1]);
         $tmp = explode('-sp-', $tmp[1]);
         $sttid = $tmp[0];
         import('@.XQ.XQAction');
         $xqw = new XQAction();
         //外来的学期
         $xqls = $xqw->getxqls($grdo['grdid'], $sttid, 'DESC');
     } else {
         $xqls = $xq->order('xqnm DESC')->select();
     }
     $this->assign('xqls', $xqls);
     //q特殊
     $cdt = $arr['cdt'];
     $where = '1=1';
     if (preg_match('/f_std_sttid/', $cdt)) {
         //获取该键的值
         $tmp = explode('f_std_sttid', $cdt);
         $tmp = explode('-eq-', $tmp[1]);
         $tmp = explode('-sp-', $tmp[1]);
         $where = $where . ' AND f_cls_sttid=' . $tmp[0];
     } else {
         if ($athofnstt['aths'] == 1) {
             $where = $where . ' AND f_cls_sttid=1';
         } else {
             $where = $where . ' AND f_cls_sttid=' . $usro['f_usr_sttid'];
         }
     }
     //之前已经确定过到底是看哪个年级
     $where = $where . ' AND f_cls_grdid=' . $grdid . ' AND clsactvt=1';
     $cls = M($grdo['grdnm'] . '_cls');
     $clsls = $cls->join('tb_stt ON f_cls_sttid=sttid')->where($where)->order('clsnm ASC')->select();
     $this->assign('clsls', $clsls);
     //用于生成xls
     $this->assign('grdnm', $grdo['grdnm']);
     //q特殊
     $this->assign('title', '浏览成绩单列表');
     $this->assign('theme', '成绩管理');
     $this->display('query');
 }