function _resetdb()
{
if (!isset($_POST['dataOption'])) {
echo "error";
exit;
}
$dataOption = $_POST['dataOption'];
try {
$dbh = getdbh();
$list = explode(",", "v_leaderboard_main,v_ext_ranks,v_leaderboard_ext");
foreach ($list as $view) {
dropView($dbh, $view);
}
//
// rPI challenge data
//
$list = explode(",", "t_cts_data,t_fsl_data,t_hmb_data,t_cpa_data,t_ext_data");
foreach ($list as $table) {
dropTable($dbh, $table);
}
$list = explode(",", "t_event,t_user,t_rpi,t_station,t_stationtype,t_team,t_school");
foreach ($list as $table) {
dropTable($dbh, $table);
}
create_t_user($dbh);
create_t_stationtype($dbh);
create_t_station($dbh);
create_t_school($dbh);
create_t_team($dbh);
create_t_event($dbh);
create_t_rpi($dbh);
create_v_leaderboard_main($dbh);
create_v_ext_ranks($dbh);
create_v_leaderboard_ext($dbh);
//
// rPI challenge data
//
create_t_cts_data($dbh);
create_t_fsl_data($dbh);
create_t_hmb_data($dbh);
create_t_cpa_data($dbh);
create_t_ext_data($dbh);
$admin = new User();
$admin->set('username', "admin");
$admin->setPassword('pass');
$admin->set('email', "*****@*****.**");
$admin->set('fullname', "administrator");
$admin->setRoll(USER::ROLL_ADMIN);
$admin->create();
$stationType = StationType::makeStationType(StationType::STATION_TYPE_REG, "Register", false, 60, "Hello! You have been successfully registered and may start the competition. Good luck!", "If you see this message there was an internal error 1", "If you see this message there was an internal error 2", "If you see this message there was an internal error 3");
if ($stationType === false) {
echo "Create StationType REG failed";
} else {
createStations(1, "reg", $stationType->get('OID'));
}
$stationType = StationType::makeStationType(StationType::STATION_TYPE_CTS, "Crack The Safe", true, 60, "Welcome, Team! Your first assignment is to break into Professor Aardvark's safe where you will find the first clue to his Secret Laboratory. Measure the interior angles and pick the three correct angles for the safe combination. Good luck! [clue=[clue]]", "Success! Go quickly to the next team queue.", "You have failed the challenge. Go quickly to the next team queue.", "No luck, better try again!");
$numStations = $dataOption == 1 ? 1 : 6;
if ($stationType === false) {
echo "Create StationType CTS failed";
} else {
createStations($numStations, "cts", $stationType->get('OID'));
}
$stationType = StationType::makeStationType(StationType::STATION_TYPE_FSL, "Find Secret Lab", false, 60, "Find and scan the [ordinal] at [waypoint-lat=[lat]] [waypoint-lon=[lng]].", "Success! Find and scan the [ordinal] marker at [waypoint-lat=[lat]] [waypoint-lon=[lng]].", "Too bad, you failed. Find and scan the [ordinal] marker at [waypoint-lat=[lat]] [waypoint-lon=[lng]].", "Wrong marker, try again!");
if ($stationType === false) {
echo "Create StationType FSL failed";
} else {
createStations(1, "fsl", $stationType->get('OID'));
}
$stationType = StationType::makeStationType(StationType::STATION_TYPE_HMB, "Defuse Hypermutation Bomb", true, 60, "The HMB has been triggered! Send the Energy Pulsator cycle time quickly!", "Success! Go quickly to the next team queue.", "Oops. Enough said. Go quickly to the next team queue.", "Nope, better try again!");
$numStations = $dataOption == 1 ? 1 : 6;
if ($stationType === false) {
echo "Create StationType HMB failed";
} else {
createStations($numStations, "hmb", $stationType->get('OID'));
}
$stationType = StationType::makeStationType(StationType::STATION_TYPE_CPA, "Catch Provessor Aardvark", true, 2000, "PA is trying to escape. Quickly measure the [fence=label] [building=[label]] and scan Start QR Code.", "Watch now as the professor attempts to escape. Get him!", "Success! Go quickly to the team finish area.", "Professor Aardvark has escaped. Oh well. Go quickly to the team finish area.", "Miss! Try again!");
$numStations = $dataOption == 1 ? 1 : 6;
if ($stationType === false) {
echo "Create StationType CPA failed";
} else {
createStations($numStations, "cpa", $stationType->get('OID'));
}
$stationType = StationType::makeStationType(StationType::STATION_TYPE_EXT, "Extra", false, 60, "You have 20 (TBR) minutes to provide the tower location and height. Good luck." . " [waypoint1-lat=[a_lat]] [waypoint1-lon=[a_lng]]" . " [waypoint2-lat=[b_lat]] [waypoint2-lon=[b_lng]]" . " [waypoint3-lat=[c_lat]] [waypoint3-lon=[c_lng]]", "Message received, return to base", "M didn't understand your message", "If you see this message there was an internal error 5");
if ($stationType === false) {
echo "Create StationType EXT failed";
} else {
createStations(1, "ext", $stationType->get('OID'));
}
if ($dataOption == 0) {
redirect('mgmt_main', 'Database Initialized without test data!');
return;
}
// generate test data
// for ($i=1;$i < 21; $i++) {
// $user = new User();
// $user->set('username','user'.$i);
// $user->setPassword('pass'.$i);
// $user->set('email','email'.$i."@harris.com");
// $user->set('fullname','User #'.$i);
// if ($user->create()===false) echo "Create user $i failed";
// }
// keep an equal number of each of these items.
$mascots = explode(",", "Unencoded,Encoded,Unencoded,Encoded,Unencoded,Encoded,Unencoded,Encoded,Unencoded,Encoded,Unencoded,Encoded,Unencoded,Encoded");
$schools = explode(",", "Titusville HS,Edgewood Jr/Sr HS,Holy Trinity,West Shore Jr/Sr HS,Melbourne HS,Palm Bay Magnet HS,Bayside HS");
// keep twice as many name&pins we will populate 2 teams / school
$names = explode(",", "team1,team2,team3,team4,team5,team6,team7,team8,team9,team10,team11,team12,team13,team14");
$pins = explode(",", "00001,00002,00003,00004,00005,00006,00007,00008,00009,00010,00011,00012,00013,00014");
// always make the schools
$numSchools = count($schools);
for ($i = 0; $i < $numSchools; $i++) {
$school = new School();
$school->set("name", $schools[$i]);
$school->set("mascot", $mascots[$i]);
if ($school->create() === false) {
echo "Create School {$i} failed";
}
$schools[$i] = $school->get('OID');
// replace school name with OID for next part
}
// TODO always make the teams with random ids
$numTeams = $dataOption == 1 ? 2 : count($names);
for ($i = 0; $i < $numTeams; $i++) {
$team = new Team();
$team->set("name", $names[$i]);
$team->set("schoolId", $schools[$i / 2]);
/*use OID from previous step two teams / school */
$team->set("pin", $pins[$i]);
// to test ext we need special test data
$team->set('extDuration', $i * 100);
$team->set('towerH', $i);
$team->set('towerD', $i);
if ($team->create() === false) {
echo "Create team {$i} failed";
}
}
for ($i = 1; $i <= ($dataOption == 1 ? 1 : 5); $i++) {
$cts = new CTSData();
$station = Station::getFromTag("cts0" . $i);
if ($station === false) {
break;
}
$cts->set('stationId', $station->get('OID'));
// hack assume get works
if (isStudentServer() && $i == 1) {
$cts->set('_1st', 39);
$cts->set('_2nd', 57);
$cts->set('_3rd', 13);
$cts->set('_4th', 23);
$cts->set('_5th', 48);
} else {
$cts->set('_1st', 10 + $i);
$cts->set('_2nd', 20 + $i);
$cts->set('_3rd', 30 + $i);
$cts->set('_4th', 40 + $i);
$cts->set('_5th', 50 + $i);
}
$cts->set('tolerance', 5.0);
if ($cts->create() === false) {
echo "Create CTS {$i} failed";
}
}
for ($i = 1; $i <= ($dataOption == 1 ? 1 : 5); $i++) {
$cpa = new CPAData();
$station = Station::getFromTag("cpa0" . $i);
if ($station === false) {
break;
}
$cpa->set('stationId', $station->get('OID'));
// hack assume get works
if ($i == 1) {
$cpa->set('label', $i);
$cpa->set('fence', 240);
$cpa->set('building', 127);
$cpa->set('sum', 367);
} else {
$cpa->set('label', $i);
$cpa->set('fence', 240 + $i);
$cpa->set('building', 127 - $i);
$cpa->set('sum', 367);
}
if ($cpa->create() === false) {
echo "Create CTA {$i} failed";
}
}
$hmb = new HMBData();
$hmb->set('_1st_on', 1);
$hmb->set('_1st_off', 1);
$hmb->set('_2nd_on', 1);
$hmb->set('_2nd_off', 10);
$hmb->set('_3rd_on', 1);
$hmb->set('_3rd_off', 22);
$hmb->set('cycle', 506);
if ($hmb->create() === false) {
echo "Create HMB {$i} failed";
}
$fsl_data = array(array("1", +28.030924, -80.601834, "1", +28.032708, -80.600032, "1", +28.03167, -80.59855899999999, "1", +28.031062, -80.600013, 665.8, 600.1, 574.6), array("1", +28.030924, -80.601834, "1", +28.032708, -80.600032, "1", +28.03167, -80.59855899999999, "2", +28.030975, -80.60010699999999, 629.9, 632.4, 618.6), array("1", +28.030924, -80.601834, "1", +28.032708, -80.600032, "1", +28.03167, -80.59855899999999, "3", +28.030859, -80.60001800000001, 662.5, 674.1, 608.6));
for ($i = 0; $i < count($fsl_data); $i++) {
$fsl = new FSLData();
$fsl->set('a_tag', $fsl_data[$i][0]);
$fsl->set('a_lat', $fsl_data[$i][1]);
$fsl->set('a_lng', $fsl_data[$i][2]);
$fsl->set('b_tag', $fsl_data[$i][3]);
$fsl->set('b_lat', $fsl_data[$i][4]);
$fsl->set('b_lng', $fsl_data[$i][5]);
$fsl->set('c_tag', $fsl_data[$i][6]);
$fsl->set('c_lat', $fsl_data[$i][7]);
$fsl->set('c_lng', $fsl_data[$i][8]);
$fsl->set('l_tag', $fsl_data[$i][9]);
$fsl->set('l_lat', $fsl_data[$i][10]);
$fsl->set('l_lng', $fsl_data[$i][11]);
$fsl->set('a_rad', $fsl_data[$i][12]);
$fsl->set('b_rad', $fsl_data[$i][13]);
$fsl->set('c_rad', $fsl_data[$i][14]);
if ($fsl->create() === false) {
echo "Create FSLData {$i} failed";
}
}
$ext = new EXTData();
$ext->set('a_lat', +28.031848);
$ext->set('a_lng', -80.600938);
$ext->set('b_lat', +28.031695);
$ext->set('b_lng', -80.600413);
$ext->set('c_lat', +28.031579);
$ext->set('c_lng', -80.60087300000001);
$ext->set('t_lat', +28.031698);
$ext->set('t_lng', -80.60075500000001);
$ext->set('height', 102);
if ($ext->create() === false) {
echo "Create EXTData {$i} failed";
}
redirect('mgmt_main', 'Database Initialized test data!');
} catch (ErrorInfo $e) {
echo $e->getMessage();
die;
}
}
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;
}
}
public function executeRegistration()
{
$userid = $this->getRequestParameter('userid');
$this->getUser()->getAttributeHolder()->remove('claimerid');
$roll = $this->getRequestParameter('roll');
$hawa = $this->getRequestParameter('hawa');
$city = $this->getRequestParameter('city');
$hod = $this->getRequestParameter('hod');
$director = $this->getRequestParameter('director');
$teacher = $this->getRequestParameter('favteacher');
$lanka = $this->getRequestParameter('favlankashop');
$email = $this->getRequestParameter('email');
$other = $this->getRequestParameter('otherinfo');
$dusername = $this->getRequestParameter('dusername');
$mob = $this->getRequestParameter('mob');
if (!$userid) {
$fname = $this->getRequestParameter('fname');
$mname = $this->getRequestParameter('mname');
$lname = $this->getRequestParameter('lname');
$year = $this->getRequestParameter('year');
$dusername = $this->getRequestParameter('dusername');
$formerrors1 = array();
if (!$fname) {
$formerrors1[] = 'Please enter first name';
}
if (!$lname) {
$formerrors1[] = 'Please enter last name';
}
if (!$dusername) {
$formerrors1[] = 'Please enter username';
}
if ($formerrors1) {
$this->getRequest()->setErrors($formerrors1);
$this->forward('home', 'getmyaccount');
}
$branchn = BranchPeer::retrieveByPK($this->getRequestParameter('branchid'));
$degreen = DegreePeer::retrieveByPK($this->getRequestParameter('degreeid'));
if (!$dusername) {
$newusername = $fname . "." . $lname . "@" . $branchn->getCode() . substr($year, -2);
} else {
$newusername = $dusername;
}
$currentyear = date('Y');
if ($currentyear <= $year) {
$usertype = '0';
} else {
$usertype = '1';
}
$user = new User();
$user->setUsername($newusername);
$user->setRoll($roll);
$user->setRollflag(sfConfig::get('app_defaultprivacy_roll'));
$user->setGraduationyear($year);
$user->setGraduationyearflag(sfConfig::get('app_defaultprivacy_year'));
$user->setBranchId($branchn->getId());
$user->setBranchflag(sfConfig::get('app_defaultprivacy_branch'));
$user->setDegreeId($degreen->getId());
$user->setDegreeflag(sfConfig::get('app_defaultprivacy_degree'));
$user->setUsertype($usertype);
$user->setTempemail($email);
$user->setIslocked(sfConfig::get('app_islocked_newreg'));
$user->save();
$personal = new Personal();
$personal->setUserId($user->getId());
$personal->setFirstname($fname);
$personal->setMiddlename($mname);
$personal->setLastname($lname);
$personal->setEmail($email);
$personal->setMobile($mob);
$personal->save();
$userid = $user->getId();
} else {
$user = UserPeer::retrieveByPK($userid);
$user->setIslocked(sfConfig::get('app_islocked_claimed'));
$user->save();
}
$c = new Criteria();
$c->add(ClaiminfoPeer::USER_ID, $userid);
$claiminfo = ClaiminfoPeer::doSelectOne($c);
if ($claiminfo) {
$this->user = $claiminfo->getUser();
$this->claiminfo = $claiminfo;
} else {
$claiminfo = new Claiminfo();
$claiminfo->setUserId($userid);
$claiminfo->setRoll($roll);
$claiminfo->setHawa($hawa);
$claiminfo->setCity($city);
$claiminfo->setHod($hod);
$claiminfo->setDirector($director);
$claiminfo->setTeacher($teacher);
$claiminfo->setLankashop($lanka);
$claiminfo->setOther($other);
$claiminfo->setDusername($dusername);
$claiminfo->save();
$this->claiminfo = $claiminfo;
$this->user = $user;
if ($user) {
$username = $user->getUsername();
$personal = $user->getPersonal();
$personal->setEmail($email);
$personal->save();
$sendermail = sfConfig::get('app_from_mail');
$sendername = sfConfig::get('app_from_name');
$to = sfConfig::get('app_to_adminmail');
$subject = "Registration request for ITBHU Global Org";
$body = '
Hi,
I want to connect to ITBHU Global. My verification information is:
';
$body = $body . 'Roll Number : ' . $roll . '
';
$body = $body . 'HAWA : ' . $hawa . '
';
$body = $body . 'City : ' . $city . '
';
$body = $body . 'HoD : ' . $hod . '
';
$body = $body . 'Director : ' . $director . '
';
$body = $body . 'Favourite Teacher : ' . $teacher . '
';
$body = $body . 'Favuorite Lanka Shop : ' . $lanka . '
';
$body = $body . 'My Email : ' . $email . '
';
$body = $body . 'Username I am claiming: ' . $username . '
';
$body = $body . 'Desired Username : '******'
';
$body = $body . 'Thanks,';
$body = $body . '
' . $user->getFullname();
//send mail to admin
$mail = myUtility::sendmail($sendermail, $sendername, $sendermail, $sendername, $sendermail, $to, $subject, $body);
//send mail to class authorizer
$ca = new Criteria();
$ca->add(UserPeer::GRADUATIONYEAR, $user->getGraduationyear());
$ca->add(UserPeer::BRANCH_ID, $user->getBranchId());
$ca->addJoin(UserPeer::ID, UserrolePeer::USER_ID);
$ca->add(UserrolePeer::ROLE_ID, sfConfig::get('app_role_auth'));
$authusers = UserPeer::doSelect($ca);
//if class authorizers are available.
if ($authusers) {
foreach ($authusers as $authuser) {
$toauth = $authuser->getEmail();
$mail = myUtility::sendmail($sendermail, $sendername, $sendermail, $sendername, $sendermail, $toauth, $subject, $body);
}
$user->setAuthcode(sfConfig::get('app_authcode_classauth'));
$user->save();
} else {
//get other authorizers
$ugyear = $user->getGraduationyear() - 2;
$lgyear = $user->getGraduationyear() + 2;
$oa = new Criteria();
$oa->add(UserPeer::GRADUATIONYEAR, $ugyear, Criteria::GREATER_EQUAL);
$oa->add(UserPeer::GRADUATIONYEAR, $lgyear, Criteria::LESS_EQUAL);
$oa->add(UserPeer::BRANCH_ID, $user->getBranchId());
$oa->addJoin(UserPeer::ID, UserrolePeer::USER_ID);
$oa->add(UserrolePeer::ROLE_ID, sfConfig::get('app_role_auth'));
$authuserspm = UserPeer::doSelect($oa);
//if other authorizers are available
if ($authuserspm) {
foreach ($authuserspm as $authuserpm) {
$toauth = $authuserpm->getEmail();
$mail = myUtility::sendmail($sendermail, $sendername, $sendermail, $sendername, $sendermail, $toauth, $subject, $body);
$user->setAuthcode(sfConfig::get('app_authcode_otherauth'));
$user->save();
}
} else {
// no authorizers were available, send to master list of authorizers
$ma = new Criteria();
$ma->addJoin(UserPeer::ID, UserrolePeer::USER_ID);
$ma->add(UserrolePeer::ROLE_ID, sfConfig::get('app_role_masterauth'));
$mauths = UserPeer::doSelect($ma);
if ($mauths) {
foreach ($mauths as $mauth) {
$toauth = $mauth->getEmail();
$mail = myUtility::sendmail($sendermail, $sendername, $sendermail, $sendername, $sendermail, $toauth, $subject, $body);
$user->setAuthcode(sfConfig::get('app_authcode_masterauth'));
$user->save();
}
} else {
$user->setAuthcode(sfConfig::get('app_authcode_none'));
$user->save();
}
}
}
$sendermail = sfConfig::get('app_from_mail');
$sendername = sfConfig::get('app_from_name');
$to = $email;
$subject = "Registration request for ITBHU Global Org";
$body = '
Dear ' . $user->getFullname() . ',
Thank you for your connect request. We\'ll get back to you shortly.
Admin,
ITBHU Global
';
$mail = myUtility::sendmail($sendermail, $sendername, $sendermail, $sendername, $sendermail, $to, $subject, $body);
}
}
// saving the checkbox data in db
$c = new Criteria();
$c->add(PersonalPeer::USER_ID, $user->getId());
$this->personal = PersonalPeer::doSelectOne($c);
$c = new Criteria();
$worktypes = WorktypePeer::doSelect($c);
foreach ($worktypes as $worktype) {
if ($this->getRequestParameter($worktype->getId())) {
$personalWorktype = new PersonalWorktype();
$personalWorktype->setPersonalId($this->personal->getId());
$personalWorktype->setWorktypeId($worktype->getId());
$personalWorktype->save();
}
}
}
