public function actionSetSessionVar()
{
if (isset($_POST['uid'])) {
$university = new University();
if (!is_numeric($_POST['uid'])) {
$max_id = University::model()->find(array('order' => 'did DESC'));
$university->name = $_POST['uid'];
$university->did = $max_id->did + 1;
$university->validate();
$university->save();
} else {
$university->did = $_POST['uid'];
}
$_SESSION['uid'] = $university->did;
}
if (isset($_POST['did'])) {
$degree = new Degree();
if (!is_numeric($_POST['did'])) {
$max_id = Degree::model()->find(array('order' => 'did DESC'));
$degree->name = $_POST['did'];
$degree->did = $max_id->did + 1;
$degree->university_id = $_SESSION['uid'];
$degree->validate();
$degree->save();
} else {
$degree->did = $_POST['did'];
}
$_SESSION['did'] = $degree->did;
}
}
public function saveDegree(Degree $degree)
{
try {
$degree->save();
} catch (Exception $e) {
throw new DaoException($e->getMessage(), $e->getCode(), $e);
}
}
public static function addDegree($name, $abbreviation = null)
{
$name = trim($name);
$abbreviation = trim($abbreviation);
if (self::getByText($name) || self::getByText($abbreviation)) {
return false;
}
$degree = new Degree();
$degree->name = $name;
$degree->abbreviation = $abbreviation;
$degree->save();
return self::getByText($name);
}
public function executeBulkupload()
{
if ($this->getRequest()->getFileName('csvfile')) {
$fileName = md5($this->getRequest()->getFileName('csvfile') . time() . rand(0, 99999));
$ext = $this->getRequest()->getFileExtension('csvfile');
$this->getRequest()->moveFile('csvfile', sfConfig::get('sf_upload_dir') . "//csvfiles//" . $fileName . ".csv");
$fullname = $fileName . ".csv";
//$fullpath = '/uploads/csvfiles/'.$fullname;
$fp = sfConfig::get('sf_upload_dir') . "//csvfiles//" . $fileName . ".csv";
$reader = new sfCsvReader($fp, ',', '"');
$reader->open();
$i = 1;
$exist;
$ignore;
$log;
$ignoreflag = 0;
$success = 0;
while ($data = $reader->read()) {
$name[] = array();
$name = explode(' ', $data[0]);
$roll = $data[1];
$enrol = $data[2];
$branch = $data[3];
$degree = $data[4];
$year = $data[5];
$c = new Criteria();
$c->add(UserPeer::ENROLMENT, $enrol);
$user = UserPeer::doSelectOne($c);
if (!$user) {
$c = new Criteria();
$c->add(BranchPeer::CODE, $branch);
$br = BranchPeer::doSelectOne($c);
if (!$br) {
$br = new Branch();
$br->setName($branch);
$br->setCode($branch);
$br->save();
}
$c = new Criteria();
$c->add(DegreePeer::NAME, $degree);
$dg = DegreePeer::doSelectOne($c);
if (!$dg) {
$dg = new Degree();
$dg->setName($degree);
$dg->save();
}
$user = new User();
if ($roll) {
$user->setRoll($roll);
$user->setRollflag(sfConfig::get('app_defaultprivacy_roll'));
}
if ($enrol) {
$user->setEnrolment($enrol);
$user->setEnrolflag(sfConfig::get('app_defaultprivacy_enrol'));
} else {
$ignoreflag = 1;
}
if ($year) {
$user->setGraduationyear($year);
$user->setGraduationyearflag(sfConfig::get('app_defaultprivacy_year'));
}
$user->setBranchId($br->getId());
$user->setBranchflag(sfConfig::get('app_defaultprivacy_branch'));
$user->setDegreeId($dg->getId());
$user->setDegreeflag(sfConfig::get('app_defaultprivacy_degree'));
$user->setIslocked(sfConfig::get('app_islocked_unclaimed'));
$user->setUsertype(sfConfig::get('app_usertypecode_Alumni'));
$lastname = '';
$personal = new Personal();
$name[0] = str_replace('.', '', $name[0]);
$personal->setFirstname($name[0]);
if ($name[3]) {
$name[1] = str_replace('.', '', $name[1]);
$name[2] = str_replace('.', '', $name[2]);
$name[3] = str_replace('.', '', $name[3]);
$midname = $name[1] . " " . $name[2];
$personal->setMiddlename($midname);
$personal->setLastname($name[3]);
$lastname = $name[3];
} elseif ($name[2]) {
$name[1] = str_replace('.', '', $name[1]);
$name[2] = str_replace('.', '', $name[2]);
$personal->setMiddlename($name[1]);
$personal->setLastname($name[2]);
$lastname = $name[2];
} elseif ($name[1]) {
$name[1] = str_replace('.', '', $name[1]);
$personal->setLastname($name[1]);
$lastname = $name[1];
}
$uname_suffix = $branch . substr($year, -2);
if ($lastname) {
$username = $name[0] . '.' . $lastname . '@';
} else {
$username = $name[0] . '@';
}
$temp = 1;
$tempusername = $username;
while ($this->uniqueuser($tempusername . $uname_suffix)) {
$tempusername = $username . $temp;
$temp++;
}
$tempusername = $tempusername . $uname_suffix;
$user->setUsername($tempusername);
if ($ignoreflag == 0) {
$e = $user->save();
$personal->setUserId($user->getId());
$personal->save();
$success++;
$log[$i][0] = $e == 1 ? "{$i}) Uploaded Successfully" : $e;
$log[$i][1] = $data[0];
} else {
$ignore[] = $i;
$ignoreflag = 0;
$log[$i][0] = "{$i}) NO enrolment number";
$log[$i][1] = $data[0];
}
} else {
$exist[] = $i;
$log[$i][0] = "{$i}) In Database as " . $user->getFullname() . ", " . $user->getBranchname() . " " . $user->getGraduationyear();
$log[$i][1] = $data[0];
}
$i++;
}
// while ($data = $reader->read()) ends here
$reader->close();
$this->log = $log;
$this->success = $success;
$this->ignored = $ignore;
$this->exists = $exist;
}
}
}
//Iterate through each given degree
foreach ($degrees as $code) {
//Format the urls for information about the given degree
$site = "http://www.uq.edu.au/study/program.html?acad_prog=" . $code;
$courseurl = "http://www.uq.edu.au/study/program_list.html?acad_prog=" . $code;
//Collects the title abbreviation from the UQ website
$html = new simple_html_dom();
$html->load_file($site);
$title = $html->find('span[id=program-abbreviation]', 0)->innertext;
//Creates a new Degree object from the information collected
$degree = new Degree($code, $site, $title, $courseurl);
//Indexes the degree
$degree->index();
//Saves the degree
$degree->save();
}
//Degree object which provides functions which index and save information collected given degree information
class Degree
{
//Initializes the class and stores local variables
function Degree($code, $website, $title, $coursesite)
{
$this->code = $code;
$this->website = $website;
$this->coursesite = $coursesite;
$this->title = $title;
$this->indexed = false;
}
//Creates information about the degree in the degree index
function index()
