function doInsert()
{
if (isset($_POST['save'])) {
if ($_POST['deptname'] == "" or $_POST['deptdesc'] == "") {
message("All field is required!", "error");
redirect('index.php?view=add');
} else {
$dept = new Dept();
$deptid = $_POST['deptid'];
$deptname = $_POST['deptname'];
$dept_desc = $_POST['deptdesc'];
$res = $dept->find_all_dept($deptname);
if ($res >= 1) {
message("Department name already exist!", "error");
redirect('index.php?view=add');
} else {
$dept->DEPARTMENT_NAME = $deptname;
$dept->DEPARTMENT_DESC = $dept_desc;
$istrue = $dept->create();
if ($istrue == 1) {
message("New [" . $deptname . "] Department created successfully!", "success");
redirect('index.php');
}
}
}
}
}
include_once(INCLUDE_DIR.'class.dept.php');
$do=strtolower($_POST['do']);
switch($do){
case 'update':
$dept = new Dept($_POST['dept_id']);
if($dept && $dept->getId()) {
if($dept->update($_POST,$errors))
$msg='Dept updated successfully';
elseif(!$errors['err'])
$errors['err']='Error updating the department';
}else{
$errors['err']='Internal error';
}
break;
case 'create':
if(($deptID=Dept::create($_POST,$errors)))
$msg=Format::htmlchars($_POST['dept_name']).' added successfully';
elseif(!$errors['err'])
$errors['err']='Unable to add department. Internal error';
break;
case 'mass_process':
if(!$_POST['ids'] || !is_array($_POST['ids'])) {
$errors['err']='You must select at least one department';
}elseif(!$_POST['public'] && in_array($cfg->getDefaultDeptId(),$_POST['ids'])) {
$errors['err']='You can not disable/delete a default department. Remove default Dept and try again.';
}else{
$count=count($_POST['ids']);
$ids=implode(',',$_POST['ids']);
if($_POST['public']){
$sql='UPDATE '.DEPT_TABLE.' SET ispublic=1 WHERE dept_id IN ('.$ids.')';
if(db_query($sql) && ($num=db_affected_rows()))
if ($_REQUEST['id'] && !($dept = Dept::lookup($_REQUEST['id']))) {
$errors['err'] = sprintf(__('%s: Unknown or invalid ID.'), __('department'));
}
if ($_POST) {
switch (strtolower($_POST['do'])) {
case 'update':
if (!$dept) {
$errors['err'] = sprintf(__('%s: Unknown or invalid'), __('department'));
} elseif ($dept->update($_POST, $errors)) {
$msg = sprintf(__('Successfully updated %s'), __('this department'));
} elseif (!$errors['err']) {
$errors['err'] = sprintf(__('Error updating %s. Try again!'), __('this department'));
}
break;
case 'create':
if ($id = Dept::create($_POST, $errors)) {
$msg = sprintf(__('Successfully added "%s"'), Format::htmlchars($_POST['name']));
$_REQUEST['a'] = null;
} elseif (!$errors['err']) {
$errors['err'] = sprintf(__('Unable to add %s. Correct error(s) below and try again.'), __('this department'));
}
break;
case 'mass_process':
if (!$_POST['ids'] || !is_array($_POST['ids']) || !count($_POST['ids'])) {
$errors['err'] = sprintf(__('You must select at least %s'), __('one department'));
} elseif (in_array($cfg->getDefaultDeptId(), $_POST['ids'])) {
$errors['err'] = __('You cannot disable/delete a default department. Select a new default department and try again.');
} else {
$count = count($_POST['ids']);
switch (strtolower($_POST['a'])) {
case 'make_public':
