public function postHeaderEvent()
{
?>
<script src='js/jquery.picklists.js' type='text/javascript'></script>
<div id="roleDialog" class="modal">
<form id="rolesForm" name="rolesForm" method="post">
<input type="hidden" id="memberid" name="memberid" />
<input type="hidden" id="rolecmd" name="rolecmd" value="X" />
<select class="listpicker" name="roles[]" multiple="true" id="roles" >
<?php
createComboOptions("roleid", "roleid", "{$_SESSION['DB_PREFIX']}roles", "", false);
?>
</select>
</form>
</div>
<?php
}
public function postHeaderEvent()
{
?>
<script src='js/jquery.picklists.js' type='text/javascript'></script>
<div id="contentDialog" class="modal">
<label>NOTES</label><br>
<textarea id="editemailnotes" name="editemailnotes" class="tinyMCE" cols="180" rows=17 style="height: 400px"></textarea>
</div>
<div id="roleDialog" class="modal">
<form id="rolesForm" name="rolesForm" method="post">
<input type="hidden" id="pageid" name="pageid" />
<input type="hidden" id="rolecmd" name="rolecmd" value="X" />
<select class="listpicker" name="roles[]" multiple="true" id="roles" >
<?php
createComboOptions("roleid", "roleid", "{$_SESSION['DB_PREFIX']}roles", "", false);
?>
</select>
</form>
</div>
<?php
}
<?php
//Include database connection details
require_once 'system-db.php';
start_db();
$clientid = $_POST['clientid'];
createComboOptions("id", "name", "{$_SESSION['DB_PREFIX']}customerclientsite", "WHERE clientid = {$clientid}", false);
function createCombo($id, $value, $name, $table, $where = " ", $required = true, $isarray = false, $attributeArray = array(), $blank = true)
{
if (!$required) {
echo "<select id='" . $id . "' ";
} else {
echo "<select required='true' id='" . $id . "' ";
}
foreach ($attributeArray as $i => $val) {
echo "{$i}='{$val}' ";
}
if (!$isarray) {
echo "name='" . $id . "'>";
} else {
echo "name='" . $id . "[]'>";
}
createComboOptions($value, $name, $table, $where, $blank);
?>
</select>
<?php
}
<?php
//Include database connection details
require_once 'system-db.php';
start_db();
$scheduleid = $_POST['scheduleid'];
$sql = "SELECT C.member_id \n\t\t\tFROM {$_SESSION['DB_PREFIX']}scheduleitem A\n\t\t\tINNER JOIN {$_SESSION['DB_PREFIX']}rotaitem B\n\t\t\tON 1 = 1\n\t\t\tINNER JOIN {$_SESSION['DB_PREFIX']}members C\n\t\t\tON C.member_id = B.userid\n\t\t\tWHERE A.id = {$scheduleid}\n\t\t\tAND B.startdate <= A.startdate\n\t\t\tAND B.enddate >= A.enddate\n\t\t\tAND B.userid != A.userid";
$result = mysql_query($sql);
$users = array();
if ($result) {
while ($member = mysql_fetch_assoc($result)) {
array_push($users, $member['member_id']);
}
} else {
logError($sql . " - " . mysql_error());
}
$in = ArrayToInClause($users);
createComboOptions("member_id", "fullname", "{$_SESSION['DB_PREFIX']}members", "WHERE member_id IN({$in})", false);
