public function show()
{
PHPWS_Core::initCoreClass('DBPager.php');
$tags = array();
$tags['TITLE'] = "View Final RLC Assignments " . Term::toString(Term::getSelectedTerm());
$pager = new DBPager('hms_learning_community_assignment', 'HMS_RLC_Assignment');
//$pager->db->addWhere('hms_learning_community_applications.hms_assignment_id','hms_learning_community_assignment.id','=');
$pager->db->addJoin('LEFT OUTER', 'hms_learning_community_assignment', 'hms_learning_community_applications', 'application_id', 'id');
$pager->db->addWhere('hms_learning_community_applications.term', Term::getSelectedTerm());
$pager->db->addWhere('hms_learning_community_assignment.state', 'confirmed');
$pager->joinResult('application_id', 'hms_learning_community_applications', 'id', 'username', 'username');
$pager->joinResult('application_id', 'hms_learning_community_applications', 'id', 'term', 'term');
$pager->setModule('hms');
$pager->setTemplate('admin/display_final_rlc_assignments.tpl');
$pager->setLink('index.php?module=hms&type=rlc&op=assign_applicants_to_rlcs');
$pager->setEmptyMessage('No RLC assignments have been made.');
$pager->addPageTags($tags);
$pager->addRowTags('getAdminPagerTags');
$pager->setReportRow('getAdminCsvRow');
Layout::addPageTitle("RLC Assignments");
return $pager->get();
}
public static function getAdminPager()
{
$pager = new \DBPager('intern_admin', '\\Intern\\Admin');
$pager->setModule('intern');
$pager->setTemplate('admin_pager.tpl');
$pager->setEmptyMessage('No admins found.');
$pager->addRowTags('rowTags');
$pager->joinResult('department_id', 'intern_department', 'id', 'name', 'department_name');
//$pager->db->setTestMode();
// Set a default order
if (!isset($_REQUEST['orderby'])) {
$pager->setOrder('department_name');
}
/***** Row Background Color Toggles ******/
$pager->addToggle('tablerow-bg-color1');
$pager->addToggle('tablerow-bg-color2');
// Search
$pager->setSearch('username');
return $pager->get();
}
protected function propertiesList($contact_id = null)
{
\PHPWS_Core::initModClass('properties', 'Property.php');
$this->title = 'Property listing';
$pager = new \DBPager('properties', 'Properties\\Property');
if ($contact_id) {
$pager->addWhere('contact_id', $contact_id);
$data['is_contact'] = 1;
$page_tags['new'] = \PHPWS_Text::moduleLink('<i class="fa fa-plus"></i> Add new property', 'properties', array('cop' => 'edit_property', 'k' => $this->contact->getKey()), null, null, 'btn btn-success');
} else {
$page_tags['new'] = \PHPWS_Text::secureLink('<i class="fa fa-plus"></i> Add new property', 'properties', array('aop' => 'edit_property'), null, null, 'btn btn-success');
}
// photo was previously uploaded
if (!empty($_GET['pid'])) {
$data['pid'] = $_GET['pid'];
} else {
$data['pid'] = 0;
}
javascriptMod('properties', 'photo_upload', $data);
$pager->setSearch('name', 'company_name');
$pager->addSortHeader('name', 'Name of property');
$pager->addSortHeader('company_name', 'Management company');
$pager->addSortHeader('timeout', 'Time until purge');
$pager->setModule('properties');
$pager->setTemplate('properties_list.tpl');
$pager->addRowTags('row_tags', (bool) $contact_id);
$pager->joinResult('contact_id', 'prop_contacts', 'id', 'company_name', null, true);
$pager->addPageTags($page_tags);
$pager->cacheQueries();
$this->content = $pager->get();
}
private function viewReported()
{
javascriptMod('properties', 'report');
javascript('confirm');
\PHPWS_Core::initModClass('properties', 'Report.php');
$this->title = 'Reported messages';
$pager = new \DBPager('prop_report', 'Properties\\Report');
if (!isset($_SESSION['prop_show_blocked'])) {
$vars['aop'] = 'show_blocked';
$tags['BLOCKED'] = \PHPWS_Text::secureLink('Show blocked', 'properties', $vars, null, null, 'btn btn-default');
$pager->db->addWhere('prop_report.block', 0);
} else {
$vars['aop'] = 'hide_blocked';
$tags['BLOCKED'] = \PHPWS_Text::secureLink('Hide blocked', 'properties', $vars, null, null, 'btn btn-default');
}
$pager->addPageTags($tags);
$pager->addSortHeader('date_sent', 'Date reported');
$pager->joinResult('message_id', 'prop_messages', 'id', 'body', 'message');
$pager->db->addJoin('left', 'prop_report', 'prop_messages', 'message_id', 'id');
$pager->setModule('properties');
$pager->setTemplate('reported_list.tpl');
$pager->addRowTags('row');
$this->content = $pager->get();
}
public function propertyListing()
{
\PHPWS_Core::initModClass('properties', 'Base.php');
\PHPWS_Core::initModClass('properties', 'Property.php');
\Layout::addStyle('properties');
$new_class = 'other';
$all_class = 'current';
$sub_class = 'other';
if (\Current_User::isLogged()) {
$page['ROOMMATE'] = \PHPWS_Text::moduleLink('Roommate/Sublease search', 'properties', array('rop' => 'view'), null, 'Roommate or Sublease search', 'btn btn-primary');
} else {
$page['ROOMMATE'] = '<div class="alert alert-info">Looking for a roommate? Need to sublease? <a class="alert-link" href="' . \propertiesLoginLink() . '">Login to the site!</a></div>';
}
$pager = new \DBPager('properties', 'properties\\Property');
$pager->setModule('properties');
$pager->setTemplate('listing.tpl');
$pager->addRowTags('listRows');
$pager->setDefaultOrder('updated', 'desc');
$pager->setLink('index.php?module=properties&uop=list');
$pager->joinResult('id', 'prop_photo', 'pid', 'path', 'thumbnail');
$pager->db->addWhere('dbp1.main_pic', 1);
$pager->db->addWhere('dbp1.main_pic', null, null, 'or');
$pager->db->addWhere('active', 1, '=', 'and', 'search');
$pager->setEmptyMessage('No properties found. You may want to reduce your search criteria.');
$all_class = 'active';
if (!empty($_SESSION['property_search'])) {
foreach ($_SESSION['property_search'] as $key => $value) {
switch ($key) {
case 'a':
if ($value) {
$pager->db->addWhere('student_type', $value, '=', 'and', 'search');
}
break;
case 'sub':
$new_class = null;
$all_class = null;
$sub_class = 'active';
$pager->db->addWhere('sublease', '1', '=', 'and', 'search');
break;
case 'nosub':
$new_class = 'active';
$all_class = null;
$sub_class = null;
$pager->db->addWhere('sublease', '0', '=', 'and', 'search');
break;
case 'distance':
$pager->db->addWhere('campus_distance', $value, '=', 'and', 'search');
break;
case 'beds':
$value = (int) $value;
$pager->db->addWhere('bedroom_no', (int) $value, '>=', 'and', 'search');
break;
case 'eff':
$pager->db->addWhere('efficiency', '1', '=', 'and', 'search');
break;
case 'bath':
$value = (int) $value;
$pager->db->addWhere('bathroom_no', $value, '>=', 'and', 'search');
break;
case 'manager':
$value = preg_replace('/[^\\w\\s]|\\s{2,}/', ' ', $value);
$vlist = explode(' ', $value);
$db2 = new \PHPWS_DB('prop_contacts');
foreach ($vlist as $v) {
$db2->addWhere('company_name', "%{$value}%", 'like', 'or');
}
$db2->addColumn('id');
$managers = $db2->select('col');
if (!empty($managers)) {
$pager->db->addWhere('contact_id', $managers, 'in', 'and', 'properties');
} else {
$pager->db->addWhere('id', 0, '=', 'and', 'cancel');
}
break;
case 'price':
$pager->db->addWhere('monthly_rent', $value['min'] * 100, '>=', 'and', 'search');
$pager->db->addWhere('monthly_rent', $value['max'] * 100, '<=', 'and', 'search');
break;
case 'amenities':
foreach ($value as $amen_name => $foo) {
switch ($amen_name) {
case 'ac':
$pager->db->addWhere('appalcart', 1, '=', 'and', 'search');
break;
case 'ch':
$pager->db->addWhere('clubhouse', 1, '=', 'and', 'search');
break;
case 'dish':
$pager->db->addWhere('dishwasher', 1, '=', 'and', 'search');
break;
case 'furn':
$pager->db->addWhere('furnished', 1, '=', 'and', 'search');
break;
case 'pet':
$pager->db->addWhere('pets_allowed', 1, '=', 'and', 'search');
break;
case 'tr':
$pager->db->addWhere('trash_type', 1, '=', 'and', 'search');
break;
case 'wo':
$pager->db->addWhere('workout_room', 1, '=', 'and', 'search');
break;
case 'wash':
$pager->db->addWhere('laundry_type', 1, '=', 'and', 'search');
break;
}
}
break;
case 'property':
$value = preg_replace('/[^\\w\\s]|\\s{2,}/', ' ', $value);
$vlist = explode(' ', $value);
foreach ($vlist as $v) {
$pager->db->addWhere('name', "%{$v}%", 'like', 'or', 'property');
}
break;
}
}
}
$link = 'index.php?module=properties&uop=search';
$page['ALL'] = sprintf('<li class="%s"><a href="%s">All properties</a></li>', $all_class, 'index.php?module=properties&uop=remove&s=allsub');
$page['NEW'] = sprintf('<li class="%s"><a href="%s%s">New leases only</a></li>', $new_class, $link, '&nosub=1');
$page['SUB'] = sprintf('<li class="%s"><a href="%s%s">Subleases only</a></li>', $sub_class, $link, '&sub=1');
$pager->addPageTags($page);
$content = $pager->get();
\Layout::add($content);
}
public function staff()
{
PHPWS_Core::initCoreClass('DBPager.php');
PHPWS_Core::initModClass('checkin', 'Staff.php');
$page_tags['ADD_STAFF'] = $this->addStaffLink();
//$page_tags['STAFF_NOTE'] = dgettext('checkin', 'Note: Staff members with no filters will not have visitors automatically assigned to them.');
$page_tags['FILTER_LABEL'] = dgettext('checkin', 'Filter');
$pager = new DBPager('checkin_staff', 'Checkin_Staff');
$pager->setTemplate('staff.tpl');
$pager->setModule('checkin');
$pager->addRowTags('row_tags');
$pager->setEmptyMessage(dgettext('checkin', 'No staff found.'));
$pager->addPageTags($page_tags);
$pager->joinResult('user_id', 'users', 'id', 'display_name');
$pager->addSortHeader('lname_filter', dgettext('checkin', 'Filter'));
$pager->addSortHeader('display_name', dgettext('checkin', 'Staff name'));
$pager->addSortHeader('view_order', dgettext('checkin', 'Order'));
$this->title = dgettext('checkin', 'Staff');
$this->content = $pager->get();
}
