function listall()
{
include_once "../../data-access/mysql-db.php";
$obj = new DataAccessLayer();
$this->assign("cont", $obj->select("tblclientuser"));
$this->assign("type", $obj->select("tblusertype"));
}
function create($tablename, $param)
{
include_once "../data-access/mysql-db.php";
$obj = new DataAccessLayer();
$obj->insert($tablename, $param);
echo '<script type="text/javascript">window.location="forum_record.php?page=page&action=display"</script>';
}
public function add($tablename, $param)
{
include_once "../../data-access/mysql-db.php";
$obj = new DataAccessLayer();
$obj->insert($tablename, $param);
echo '<script type="text/javascript">window.location="forum_record.php?control=post&func=display&postid=' . $_GET["postid"] . '"</script>';
}
function listall()
{
include_once "../../data-access/mysql-db.php";
$obj = new DataAccessLayer();
$this->assign("cont", $obj->select("tblcompanyuser join tblusertype on userTypeID=typeID"));
$this->assign("type", $obj->select("tblusertype"));
}
function display()
{
include_once "../data-access/mysql-db.php";
$obj = new DataAccessLayer();
$this->assign("forumcategory", $obj->select("tblforumcategory"));
$this->assign("topic", $obj->select("tbltopic"));
$this->assign("latest", $obj->select("tbltopic limit 8"));
}
public static function query_all_restaurants()
{
$sql = 'select * from restaurants';
$query_tool = new DataAccessLayer();
$results = $query_tool->query($sql);
if ($results->num_rows > 0) {
return $results;
} else {
throw new Exception("No registered restaurant found or database error!");
}
}
function getImage($val, $level)
{
include_once "../../../data-access/mysql-db.php";
$obj = new DataAccessLayer();
if ($level == 1) {
$result = $obj->selectColumnImage("userImage", "tblcompanyuser", "userID", $val);
} else {
$result = $obj->selectColumnImage("userImage", "tblclientuser", "userID", $val);
}
return $result;
}
function RankDropdownList($criterion, $scholarship_id)
{
global $user_id;
$dal = new DataAccessLayer();
$rank = $dal->GetPhase2RankingOfUser($user_id, $scholarship_id, $criterion);
$ret = sprintf('<select id="%s" name="%s">', $criterion, $criterion);
for ($i = 4; $i >= 0; $i--) {
$ret .= sprintf('<option value="%d"%s>%d</option>', $i, $i == $rank ? ' selected="selected"' : '', $i);
}
$ret .= '</select>';
return $ret;
}
function listall()
{
include_once "../data-access/mysql-db.php";
$obj = new DataAccessLayer();
$this->assign("activities", $obj->select("tblactivity where activityStatus=1 order by datePosted desc "));
}
function subquery($name, $catid)
{
include_once "../../data-access/mysql-db.php";
$obj = new DataAccessLayer();
$this->assign("topic", $obj->selectColumnWhere("tbltopic", "forumCatID", 1));
}
<?php
require_once 'init.php';
if (isset($_POST['username']) && isset($_POST['password'])) {
$user = new DataAccessLayer();
$res = $user->GetUser($_POST['username']);
if (md5($_POST['password']) == $res['password']) {
session_start();
$_SESSION['user_id'] = $res['id'];
print $res['id'];
header('location: ' . $BASEURL . 'review/grid');
print 'login';
exit;
} else {
$error = "Invalid credentials.";
}
}
include "{$BASEDIR}/templates/header_review.php";
?>
<form method="post" action="<?php
echo $BASEURL;
?>
user/login" >
<h1>Log in</h1>
<?php
if (isset($error)) {
print "<p>" . $error . "</p>\n";
}
?>
<fieldset>
<p>Username: <input type="text" id="username" name="username" /></p>
session_start();
if (!isset($_SESSION['user_id'])) {
header('location: ' . $BASEURL . 'user/login');
exit;
}
$user_id = $_SESSION['user_id'];
if ($_GET['id']) {
$id = $_GET['id'];
} else {
if ($_POST['id']) {
$id = $_POST['id'];
} else {
$id = 'new';
}
}
$dal = new DataAccessLayer();
$username = $dal->GetUsername($_SESSION['user_id']);
if (isset($_POST['save'])) {
$fieldnames = array("username", "password", "email", "reviewer", "isvalid", "isadmin");
foreach ($fieldnames as $i) {
$answers[$i] = mysql_real_escape_string($_POST[$i]);
}
if ($_POST['formstate'] == 'new') {
$answers['password'] = md5($_POST['password']);
$id = $dal->NewUserCreate($answers);
} else {
$dal->UpdateUserInfo($answers, $_POST['id']);
}
}
if ($id != "new") {
$user = $dal->GetUserInfo($id);
public function updateinfo($clientarr, $column, $id)
{
include_once "../../data-access/mysql-db.php";
$obj = new DataAccessLayer();
$obj->updateWhere("tblpost", $clientarr, $column, $id);
}
public function create($activityarr)
{
include_once "../../data-access/mysql-db.php";
$obj = new DataAccessLayer();
$obj->insert("tblactivity", $activityarr);
}
public function __CONSTRUCT()
{
parent::__CONSTRUCT();
$this->jq = new jqGridHelper();
$this->rh = new ResponseHelper();
}
function listall()
{
include_once "../data-access/mysql-db.php";
$obj = new DataAccessLayer();
$this->assign("cont", $obj->select("tblnews order by datePosted desc"));
}
<?php
require_once 'init.php';
session_start();
if (!isset($_SESSION['user_id'])) {
header('location: ' . $BASEURL . 'user/login');
exit;
}
$partial = $_GET['partial'] ? $_GET['partial'] : 0;
$dal = new DataAccessLayer();
$schols = $dal->GetFinalScoring($partial);
$rowstyleeven = 0;
$ctr = 1;
include "{$BASEDIR}/templates/header_review.php";
?>
<form method="post" action="<?php
echo $BASEURL;
?>
grid">
<h1>Applications</h1>
<?php
include "{$BASEDIR}/templates/admin_nav.php";
?>
<table style="width: 100%">
<tr>
<th>counter</th>
<th>id</th>
<th>name</th>
<th>email</th>
<th>residence</th>
<th>sex</th>
<?php
require_once 'init.php';
session_start();
if (!isset($_SESSION['user_id'])) {
header('location: ' . $BASEURL . 'user/login');
exit;
}
$order = isset($_GET['order']) ? $_GET['order'] : '';
$dal = new DataAccessLayer();
$users = $dal->GetListofCountries($order);
$rowstyleeven = 0;
include "{$BASEDIR}/templates/header_review.php";
?>
<form method="post" action="grid.php">
<h1>Applications</h1>
<?php
include "{$BASEDIR}/templates/admin_nav.php";
?>
<table id="country-grid" style="width: 100%">
<tr>
<th>id</th>
<th>country name</th>
<th>rank</th>
<th>scholarship count</th>
</tr>
<?php
foreach ($users as $row) {
?>
<tr class="<?php
echo $rowstyleeven == 1 ? "evenrow" : "oddrow";
<?php
require_once 'init.php';
session_start();
if (!isset($_SESSION['user_id'])) {
header('location: ' . $BASEURL . 'user/login');
exit;
}
$dal = new DataAccessLayer();
$schols = $dal->GetFinalScoring(0);
foreach ($schols as $row) {
print implode("\t", $row) . "\n";
}
function listall()
{
include_once "../data-access/mysql-db.php";
$obj = new DataAccessLayer();
$this->assign("activities", $obj->select("tblactivity "));
}
session_start();
if (!isset($_SESSION['user_id'])) {
header('location: ' . $BASEURL . '/user/login');
exit;
}
$user_id = $_SESSION['user_id'];
if ($_GET['id']) {
$id = $_GET['id'];
} else {
if ($_POST['id']) {
$id = $_POST['id'];
} else {
die("No ID supplied!");
}
}
$dal = new DataAccessLayer();
$username = $dal->GetUsername($_SESSION['user_id']);
if (isset($_POST['up'])) {
$dal->InsertOrUpdateRanking($user_id, $_POST['last_id'], 'valid', 1);
} else {
if (isset($_POST['down'])) {
$dal->InsertOrUpdateRanking($user_id, $_POST['last_id'], 'valid', -1);
} else {
if (isset($_POST['skip'])) {
$dal->InsertOrUpdateRanking($user_id, $_POST['last_id'], 'valid', 0);
} else {
if (isset($_POST['save'])) {
$dal->UpdateField('notes', $_POST['last_id'], $_POST['notes']);
$dal->UpdateField('residence', $_POST['last_id'], $_POST['residence']);
$dal->UpdateField('nationality', $_POST['last_id'], $_POST['nationality']);
$dal->UpdateField('exclude', $_POST['last_id'], $_POST['exclude']);
// The id of one of your Posterous sites ...
define('IMPORT_SITE_EMAIL', '*****@*****.**');
// The email address assigned to your Posterous account ...
define('IMPORT_SITE_PASSWORD', 'PASSWORD');
// The password assigned to your Posterous account ...
define('DB_NAME', 'Database Name');
define('DB_URL', 'Database URL or IP Address');
define('DB_USER', 'Database username');
define('DB_PASSWORD', 'Database password');
$batchSize = 100;
$totalRecsProcessed = 0;
$currentRecord = 0;
// SHOW ITEM BY DEFAULT on Posterous Website
$private_item = 1;
echo "Welcome. This process will attempt to move your items from SweetCron to Posterous<br/><br/>";
$db = new DataAccessLayer(DB_URL, DB_USER, DB_PASSWORD, DB_NAME);
$db->debug = false;
$totalRows = $db->nonQuery("select * FROM items where item_status = 'publish' limit 0,10");
while ($totalRows > 0) {
$currentRecord = 0;
if ($totalRecsProcessed > 100) {
break;
}
echo "<h1>Processing " . $totalRecordsProcessed . " through " . $totalRecordsProcessed + $batchSize . "</h1>";
$sql = "SELECT f.feed_title, f.feed_url, f.feed_domain, f.feed_icon, f.feed_data, i.* FROM items i " . " inner join feeds f on f.feed_id = i.item_feed_id " . " where i.item_status = 'publish' " . " limit 0," . $batchSize;
$items = $db->query($sql);
while ($obj = $items->fetch_object()) {
$dmp = unserialize($obj->item_data);
// load up the serialized item_data
echo "<h3>Importing " . $obj->ID . " - " . $obj->item_title . "</h3>";
echo "Original Date: " . $obj->item_date . "<br/>";
public function create($clientarr)
{
include_once "../../data-access/mysql-db.php";
$obj = new DataAccessLayer();
$obj->insert("tblcompanyuser", $clientarr);
}
public function create($typearr)
{
include_once "../../data-access/mysql-db.php";
$obj = new DataAccessLayer();
$obj->insert("tblusertype", $typearr);
}
<?php
require_once 'init.php';
session_start();
if (!isset($_SESSION['user_id'])) {
header('location: ' . $BASEURL . 'user/login');
exit;
}
$state = isset($_GET['state']) ? $_GET['state'] : 'all';
$dal = new DataAccessLayer();
$users = $dal->GetListofUsers($state);
$rowstyleeven = 0;
include "{$BASEDIR}/templates/header_review.php";
?>
<form method="post" action="<?php
echo $BASEURL;
?>
review/grid">
<h1>Applications</h1>
<?php
include "{$BASEDIR}/templates/admin_nav.php";
?>
<table style="width: 100%">
<tr>
<th>id</th>
<th>username</th>
<th>email</th>
<?php
if ($state == "reviewer") {
?>
<th>remaining</th><?php
function __destruct()
{
parent::__destruct();
}
/**
* [newest_restaurants description]
* @param [type] $number [description]
*/
function newest_restaurants($number = null)
{
if ($number) {
$query_tool = new DataAccessLayer();
$sql = 'select restaurant_id, name, cuisine_type, rating from restaurants where approved = 1 order by restaurant_id DESC limit 0, ' . $number;
$newest_three_restaurant = $query_tool->query($sql);
if ($newest_three_restaurant->num_rows > 0) {
while ($row = $newest_three_restaurant->fetch_row()) {
render_newest_restaurant($row);
}
echo '<div class="clearfix"></div>';
}
}
}
function listall()
{
include_once "../../data-access/mysql-db.php";
$obj = new DataAccessLayer();
$this->assign("forumcategory", $obj->select("tblforumcategory"));
}
public static function find_by_restaurant_id($restaurant_id)
{
if ($restaurant_id) {
$sql = 'select * from reservations where restaurant_id = ' . $restaurant_id;
$query_tool = new DataAccessLayer();
$results = $query_tool->query($sql);
if ($results->num_rows > 0) {
return $results;
} else {
return null;
}
}
}
}
echo json_encode($return_result);
} else {
if ($_POST['operation'] == 'make_reservation') {
// var_dump($_POST);
$time_to_slots_hash = array('05:00PM - 06:00PM' => 'slot_5_6', '06:00PM - 07:00PM' => 'slot_6_7', '07:00PM - 08:00PM' => 'slot_7_8', '08:00PM - 09:00PM' => 'slot_8_9', '09:00PM - 10:00PM' => 'slot_9_10');
$time_to_24_hours = array('05:00PM - 06:00PM' => 17, '06:00PM - 07:00PM' => 18, '07:00PM - 08:00PM' => 19, '08:00PM - 09:00PM' => 20, '09:00PM - 10:00PM' => 21);
$user_email = $_POST['user_email'];
$user_phone = $_POST['user_phone'];
if (isset($_POST['guest_reservation']) && $_POST['guest_reservation'] == 'true') {
$fields = array('restaurant_id' => $_POST['restaurant_id'], 'people_size' => $_POST['people_size'], 'date_of_reservation' => $_POST['date'], 'time_of_reservation' => $time_to_24_hours[$_POST['time']], 'effective' => 1, 'guest_info' => $_POST['guest_info']);
} else {
$fields = array('user_id' => $_POST['user_id'], 'restaurant_id' => $_POST['restaurant_id'], 'people_size' => $_POST['people_size'], 'date_of_reservation' => $_POST['date'], 'time_of_reservation' => $time_to_24_hours[$_POST['time']], 'effective' => 1);
}
try {
$query_tool = new DataAccessLayer();
$sql = 'select ' . $time_to_slots_hash[$_POST['time']] . ', date, restaurant_id from time_slots_capacity where date = "' . $fields['date_of_reservation'] . '" and restaurant_id = "' . $fields['restaurant_id'] . '"';
$results = $query_tool->query($sql);
if ($results->num_rows > 0) {
$row = $results->fetch_row();
$previous_capacity = $row[0];
if ($previous_capacity >= $fields['people_size']) {
$new_reservation = new Reservation();
$new_reservation->create($fields);
$next_capacity = $previous_capacity - $fields['people_size'];
$sql = 'update time_slots_capacity set ' . $time_to_slots_hash[$_POST['time']] . ' = ' . $next_capacity . ' where date = "' . $fields['date_of_reservation'] . '" and restaurant_id = "' . $fields['restaurant_id'] . '"';
if ($query_tool->query($sql)) {
// send email to user to confirm reservation
$restaurant = new Restaurant();
$restaurant->find($fields['restaurant_id']);
$mail = Mail::getInstance();
