Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class SCORE
- {
- public static function get($args)
- {
- $studentID = $args['ID_student'];
- $time = $args['LearnYear'];
- $term = $args['term'];
- $get_all= $args['get_all'];
- $arr = array();
- $ret_arr = array();
- $count = 0;//科目数目
- $TotalCredits1 = 0;//总学分含C类课
- $TotalCredits2 = 0;//总学分不含C类课
- $GPA1 = 0;//含C类课的加权绩点
- $GPA2 = 0;//不含C类课的加权绩点
- $dangerous = !preg_match('/^20\d\d-2017$/',$time) + !preg_match('/[12]/',$term);
- if($dangerous){
- die("Don't hack me!");
- }
- $conn = oci_connect('hduapi','karbom571','192.168.100.21/hziee','UTF8') or die('Connect to Oracle DB failed.');
- if($get_all==1)
- {
- $sql = "SELECT KCMC,XF,ZSCJ,JD,XKKH,CJ FROM ZFSOFT.CJB WHERE XH='$studentID'ORDER BY XN,XQ";
- }
- else
- {!
- if(!($term && $time))
- {
- $year = (int)date("Y");
- $month = (int)date("m");
- $month < 6 ? $term = 1 : $term = 2;
- $time=(string)($year-1)."-".(string)$year;
- }
- $sql = "SELECT KCMC,XF,ZSCJ,JD,XKKH,CJ FROM ZFSOFT.CJB WHERE XH='$studentID' AND XN='$time' AND XQ='$term'";
- }
- $stid = oci_parse($conn, $sql);
- $results = oci_execute($stid, OCI_DEFAULT);
- while ($res = oci_fetch_array($stid,OCI_ASSOC))
- {
- $TotalCredits1 += $res['XF'];
- $arr[$count] = $res;
- ++$count;
- }
- for ($i = 0;$i < $count;++$i)
- {
- $GPA1 += $arr[$i]['XF'] * $arr[$i]['JD'];
- if (!preg_match('/C\d{7+}/',$arr[$i]['XKKH'])) {
- $GPA2 += arr[$i]["XF"] * arr[$i]["JD"];
- $TotalCredits2 += arr[$i]["CJ"];
- }
- $ret_arr[$i]['credit'] = $arr[$i]['XF'];
- $ret_arr[$i]['name'] = $arr[$i]['KCMC'];
- $ret_arr[$i]['score'] = $arr[$i]['CJ'];
- $ret_arr[$i]['point'] = $arr[$i]['JD'];
- $ret_arr[$i]['id'] = $arr[$i]['XKKH'];
- }
- }
- $GPA1 /= $TotalCredits1;
- $GPA2 /= $TotalCredits2;
- return array('count'=> $count,'totalcredits1'=> $TotalCredits1,'totalcredits2'=> $TotalCredits2,'list' => $ret_arr, 'gpa1'=> $GPA1,'gpa2'=> $GPA2);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement