function makeChildList($currid, $count)
{
static $childlist = "";
if (!isNotNull($deptid)) {
$deptid = 0;
}
if (!isset($current_parentcat_id)) {
$current_parentcat_id = 0;
}
$count = $count + 1;
$sql = "select nDeptId as id,vDeptDesc as name from sptbl_depts where nDeptParent={$currid} ";
$get_options = mysql_query($sql);
$num_options = mysql_num_rows($get_options);
if ($num_options > 0) {
while (list($child_id, $child_name) = mysql_fetch_row($get_options)) {
$childlist .= "" . $child_id . ",";
makeChildList($child_id, $count);
}
}
return $childlist;
}
$var_parentid = trim($_POST["cmbParentDepartment"]);
$var_deptname = trim($_POST["txtDepartmentName"]);
$var_email = trim($_POST["txtEmail"]);
$var_deptcode = trim($_POST["txtDeptCode"]);
$var_responsetime = trim($_POST["txtResponseTime"]);
$dup_flag = 0;
//check duplicate name department name
//$sql="SELECT nDeptId FROM sptbl_depts WHERE nCompId=$var_companyid and nDeptParent=$var_parentid and vDeptDesc='".mysql_real_escape_string($var_deptname) . "'";
//$sql .=" and nDeptId !=$var_id";
$sql = "SELECT nDeptId FROM sptbl_depts WHERE ((nCompId={$var_companyid} and nDeptParent={$var_parentid} and vDeptDesc='" . mysql_real_escape_string($var_deptname) . "')";
$sql .= " or (nCompId={$var_companyid} and vDeptCode='" . mysql_real_escape_string($var_deptcode) . "')) and nDeptId !={$var_id}";
$rs = executeSelect($sql, $conn);
if (mysql_num_rows($rs) > 0) {
$dup_flag = 1;
}
$childlist = makeChildList($var_id, 0);
$childlist = substr($childlist, 0, -1);
if ($childlist != "") {
$charr = explode(",", $childlist);
array_push($charr, $var_id);
$charr = array_unique($charr);
array_push($charr, $var_parentid);
$cnt_arr1 = count($charr);
$charr = array_unique($charr);
$cnt_arr2 = count($charr);
}
if ($cnt_arr1 != $cnt_arr2) {
$dup_flag = 1;
} else {
if ($var_id == $var_parentid) {
$dup_flag = 1;
