<?php
include_once("d:/dsn/banner_prod_student.config");
$Oracleconn = oci_connect($user, $pass, $connection);
if (!$Oracleconn) {
    exit;
}
$term_array = array();
$filename = $min_term_code."-".$max_term_code.".json";
//check to see if updated more than 7 days
$diff=time()-filemtime( $filename );
$days = round($diff/86400);
if ($days >= 7) {
    $getterms = "select distinct TERM_CODE, TERM_DESC from BANINST1.Z_WEB_DEAN_PRES_LIST where TERM_CODE >= " . $min_term_code . " and TERM_CODE <= " . $max_term_code . " order by TERM_CODE DESC";

    $results = oci_parse($Oracleconn, $getterms);
    oci_execute($results);
    while (($row = oci_fetch_array($results, OCI_ASSOC)) != false) {
        $term_array[] = ['term_code' => $row['TERM_CODE'], 'term_desc' => $row['TERM_DESC']];
    }
    $term_json = json_encode($term_array);
    $fp = fopen($filename, 'w');
    fwrite($fp, $term_json);
       fclose($fp);
}