/** * 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'; }