public static function prefsView($calID, $uid)
{
global $FANNIE_OP_DB;
if (!CalendarPluginPermissions::is_owner($uid, $calID)) {
return "<h2>Either something goofed up or you aren't allowed to change\n settings for this calendar</h2>";
}
$db = CalendarPluginDB::get();
$calendar = new CalendarsModel($db);
$calendar->calendarID($calID);
$calendar->load();
$name = $calendar->name();
$ret = "<body>";
$ret .= "<p>Name: <input type=text size=15 id=prefName value=\"{$name}\" />";
if ($calendar->calendarSubscriptionID()) {
$sub = new CalendarSubscriptionsModel($db);
$sub->calendarSubscriptionID($calendar->calendarSubscriptionID());
$sub->load();
$ret .= '</p><p>URL: <input type="text" size="50" id="sub-url" value="' . $sub->url() . '" />';
}
$ret .= "</p><hr />";
$userP = $db->prepare_statement("SELECT uid,real_name,name FROM " . $FANNIE_OP_DB . $db->sep() . "Users \n WHERE uid<>? order by name,real_name");
$userR = $db->exec_statement($userP, array($uid));
$userOpts = array();
while ($userW = $db->fetch_row($userR)) {
$name = $userW['real_name'];
if ($name == '') {
$name = $userW['name'];
} else {
if ($name == 'Array') {
$name = $userW['name'];
}
}
$userOpts[$userW['uid']] = "<option value=\"{$userW['uid']}\">{$name}</option>";
}
$ret .= "<p>Users who can view this calendar (<i>left</i>):";
$ret .= "<table><tr>";
$viewP = $db->prepare_statement("SELECT p.uid,u.real_name,u.name FROM permissions as p\n LEFT JOIN " . $FANNIE_OP_DB . $db->sep() . "Users as u on p.uid=u.uid\n WHERE p.calendarID=?\n AND p.classID = 1");
$viewR = $db->exec_statement($viewP, array($calID));
$ret .= "<td><select id=prefViewers multiple size=10 style=\"min-width:50px\">";
while ($viewW = $db->fetch_row($viewR)) {
$name = $userW['real_name'];
if ($viewW[0] == -1) {
$name = "Everyone";
} elseif ($name == '') {
$name = $userW['name'];
} else {
if ($name == 'Array') {
$name = $userW['name'];
}
}
$ret .= "<option value={$viewW['0']}>{$name}</option>";
}
$ret .= "</select></td>";
$ret .= "<td><input type=submit value=\"<<\" onclick=\"select_add('prefViewers2','prefViewers');\" /><p />";
$ret .= "<input type=submit value=\">>\" onclick=\"select_remove('prefViewers');\" /></td>";
$ret .= "<td><select id=prefViewers2 multiple size=10>";
$ret .= "<option value=-1>Everyone</option>";
foreach ($userOpts as $k => $v) {
$ret .= $v;
}
$ret .= "</select></td>";
$ret .= "</tr></table>";
$ret .= "</p><hr />";
$ret .= "<p>Users who can write on this calendar (<i>left</i>):";
$ret .= "<table><tr>";
$viewP = $db->prepare_statement("SELECT p.uid,u.real_name,u.name FROM permissions as p\n LEFT JOIN " . $FANNIE_OP_DB . $db->sep() . "Users as u on p.uid=u.uid\n WHERE p.calendarID=?\n AND p.classID = 2");
$viewR = $db->exec_statement($viewP, array($calID));
$ret .= "<td><select id=prefWriters multiple size=10 style=\"min-width:50px\">";
while ($viewW = $db->fetch_row($viewR)) {
$name = $userW['real_name'];
if ($viewW[0] == -1) {
$name = "Everyone";
} elseif ($name == '') {
$name = $userW['name'];
} else {
if ($name == 'Array') {
$name = $userW['name'];
}
}
$ret .= "<option value={$viewW['0']}>{$name}</option>";
}
$ret .= "</select></td>";
$ret .= "<td><input type=submit value=\"<<\" onclick=\"select_add('prefWriters2','prefWriters');\" /><p />";
$ret .= "<input type=submit value=\">>\" onclick=\"select_remove('prefWriters');\" /></td>";
$ret .= "<td><select id=prefWriters2 multiple size=10>";
$ret .= "<option value=-1>Everyone</option>";
foreach ($userOpts as $k => $v) {
$ret .= $v;
}
$ret .= "</select></td>";
$ret .= "</tr></table>";
$ret .= "</p><hr />";
$ret .= "<input type=submit value=\"Save Settings\" onclick=\"savePrefs({$calID});return false;\" /> ";
$ret .= "<input type=submit value=\"Back to Calendar\" onclick=\"top.location='?view=month&calID={$calID}';\" /> ";
return $ret;
}
