/**
* Handler for delete dept
*/
public function actionDeleteDept()
{
if (isset($_REQUEST['id'])) {
Dept::delete($_REQUEST['id']);
}
$this->showResponse(array('status' => true));
}
function doDelete()
{
@($id = $_POST['selector']);
$key = count($id);
//multi delete using checkbox as a selector
for ($i = 0; $i < $key; $i++) {
$dept = new Dept();
$dept->delete($id[$i]);
}
message("Department name(s) already Deleted!", "info");
redirect('index.php');
}
}elseif($_POST['delete']){
//Deny all deletes if one of the selections has members in it.
$sql='SELECT count(staff_id) FROM '.STAFF_TABLE.' WHERE dept_id IN ('.$ids.')';
list($members)=db_fetch_row(db_query($sql));
$sql='SELECT count(topic_id) FROM '.TOPIC_TABLE.' WHERE dept_id IN ('.$ids.')';
list($topics)=db_fetch_row(db_query($sql));
if($members){
$errors['err']='Can not delete Dept. with members. Move staff first.';
}elseif($topic){
$errors['err']='Can not delete Dept. associated with a help topics. Remove association first.';
}else{
//We have to deal with individual selection because of associated tickets and users.
$i=0;
foreach($_POST['ids'] as $k=>$v) {
if($v==$cfg->getDefaultDeptId()) continue; //Don't delete default dept. Triple checking!!!!!
if(Dept::delete($v)) $i++;
}
if($i>0){
$warn="$i of $count selected departments deleted";
}else{
$errors['err']='Unable to delete selected departments.';
}
}
}
}
break;
default:
$errors['err']='Unknown Dept action';
}
break;
default:
list($members) = db_fetch_row(db_query($sql));
$sql = 'SELECT count(topic_id) FROM ' . TOPIC_TABLE . ' WHERE dept_id IN (' . $ids . ')';
list($topics) = db_fetch_row(db_query($sql));
if ($members) {
$errors['err'] = 'Can not delete Dept. with members. Move staff first.';
} elseif ($topic) {
$errors['err'] = 'Can not delete Dept. associated with a help topics. Remove association first.';
} else {
//We have to deal with individual selection because of associated tickets and users.
$i = 0;
foreach ($_POST['ids'] as $k => $v) {
if ($v == $cfg->getDefaultDeptId()) {
continue;
}
//Don't delete default dept. Triple checking!!!!!
if (Dept::delete($v)) {
$i++;
}
}
if ($i > 0) {
$warn = "{$i} of {$count} selected departments deleted";
} else {
$errors['err'] = 'Unable to delete selected departments.';
}
}
}
}
break;
default:
$errors['err'] = 'Unknown Dept action';
}
