<hr>
<p class='cif'><i class='glyphicon glyphicon-plus-sign'></i> Change Ticket Department </p>
<div class='expande'>
<div class='row form-group'>
<div class='col-md-2'>Change Departement</div>
<div class='col-md-3'><select class='form-control' id='departments'><?php
echo $b;
?>
</select></div>
<div class='col-md-1'><input type='submit' class='btn btn-success' id='updtdpop' onclick='javascript:return false;' value='Update'/></div>
</div>
</div>
<?php
}
if ($_SESSION['status'] == 2) {
$b = retrive_depa_names($Hostname, $Username, $Password, $DatabaseName, $SupportDepaTable, $departmentid);
$c = json_decode(retrive_depa_operators($Hostname, $Username, $Password, $DatabaseName, $SupportUserTable, $SupportUserPerDepaTable, $departmentid, $opid));
?>
<hr>
<p class='cif'><i class='glyphicon glyphicon-plus-sign'></i> Change Ticket Department and Operator</p>
<div class='expande'>
<div class='row form-group'>
<div class='col-md-2'>Change Departement</div>
<div class='col-md-3'><select class='form-control' id='departments'><?php
if ($b != false) {
echo $b;
}
?>
</select></div>
</div>
<div class='row form-group'>
if ($_POST[$_SESSION['token']['act']] == 'select_depa_usr') {
$_POST['id'] = is_numeric($_POST['id']) ? (int) $_POST['id'] + 54 : exit;
try {
$DBH = new PDO("mysql:host={$Hostname};dbname={$DatabaseName}", $Username, $Password);
$DBH->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$query = "SELECT `department_id` FROM " . $SupportUserPerDepaTable . " WHERE `user_id`=? ORDER BY `department_name` ASC";
$STH = $DBH->prepare($query);
$STH->bindParam(1, $_POST['id'], PDO::PARAM_INT);
$STH->execute();
$STH->setFetchMode(PDO::FETCH_ASSOC);
$ret = array('res' => 'ok', 'depa' => array(0 => '<div class="user_depa_container">'));
$camaros = array();
while ($a = $STH->fetch()) {
$camaros[$a['department_id']] = $a['department_id'];
}
$b = json_decode(retrive_depa_names($Hostname, $Username, $Password, $DatabaseName, $SupportDepaTable));
if ($b != false) {
foreach ($b as $k => $n) {
if (array_key_exists($k, $camaros)) {
$ret['depa'][] = '<label class="checkbox inline"><input type="checkbox" name="ass_usr_depa" value="' . $k . '" checked />' . $n . '</label>';
} else {
$ret['depa'][] = '<label class="checkbox inline"><input type="checkbox" name="ass_usr_depa" value="' . $k . '" />' . $n . '</label>';
}
}
}
$ret['depa'][] = '</div>';
header('Content-Type: application/json; charset=utf-8');
echo json_encode($ret);
} catch (PDOException $e) {
file_put_contents('PDOErrors', "File: " . $e->getFile() . ' on line ' . $e->getLine() . "\nError: " . $e->getMessage() . "\n", FILE_APPEND);
header('Content-Type: application/json; charset=utf-8');
