}
}
//Get the departmentidlist
//here case-insensitive search for deptmail is done using strcasecmp
//if in future we need case-sensitive search use the function strcmp
$arr_deptid = array();
$cnt = count($arr_tolist);
foreach ($var_toaddress as $var_deptmail => $var_name) {
for ($i = 0; $i < $cnt; $i++) {
if (strcasecmp($arr_tolist[$i][1], $var_deptmail) == 0) {
$arr_deptid[] = $arr_tolist[$i][0];
}
}
}
//Get the leaf level departments
$var_deptlist = getLeafDepts();
//echo("<br>var_deptlist:<br>" . $var_deptlist[0]);
if ($var_deptlist != "") {
$arr_leafdept = explode(",", $var_deptlist);
} else {
$arr_leafdept = array();
}
/*
//testing2 start
$arr_leafdept = array();
$arr_leafdept[0]= 7;
//$arr_leafdept[1]= 6;
//$arr_leafdept[2]= 7;
//end testing2
*/
//main array that contains valid leaf departments
?>
</h3></div>
<table width="100%" cellpadding="0" cellspacing="0" border="0" >
<tr>
<?php
//select department
?>
<td width="20%" align="left"><?php
echo TEXT_DEPT;
?>
<span class="required">*</span></td>
<td width="80%" align="left" valign="top">
<?php
$leafdeptarr = getLeafDepts();
if ($leafdeptarr != "") {
$leaflvldeptids = implode(",", $leafdeptarr);
} else {
$leaflvldeptids = 0;
}
$sql = "select nDeptId,vDeptDesc,vDeptCode from sptbl_depts where nDeptId in({$leaflvldeptids}) and nCompId='" . $var_compid . "' ORDER BY vDeptDesc DESC";
$rs = executeSelect($sql, $conn);
?>
<select name="cmbDept" size="1" class="comm_input input_width1a" id="cmbDept" >
<?php
while ($row = mysql_fetch_array($rs)) {
$options = "<option value='" . $row['nDeptId'] . "'";
if ($var_deptid == $row['nDeptId']) {
$options .= " selected=\"selected\"";
}
