function msg_grp_list()
{
$Grid_Table = array("tName" => 'Corp_Detail', "tClass" => 'TableStyle', "tAlign" => "Left", "tWidth" => '100%', "tHeight" => '', "tCellspacing" => 1, "tCellpadding" => 0, "t_tr_Height" => 5, "tBorder" => 0, "Visible" => true);
$Grid_Row_Format = array("r_cellHeight" => 8, "rAlign" => "Center", "rWidth" => 20, "rClass" => 'cellStyle', "rClass_Alt" => 'cellStyle_Alt');
$Grid_Header[0] = array("Group_Id" => array("hName" => '', "hClass" => 'cellHeadStyle', "hAlign" => "Center", "hWidth" => '50', "Visible" => true), "Group_Name" => array("hName" => 'User Name', "hClass" => 'cellHeadStyle', "hAlign" => "Center", "hWidth" => 'auto', "Visible" => true));
$Rows_Contents = array();
$sqlQry = "SELECT User_Id,User_Name FROM " . TABLE_USER_MASTER . " WHERE User_Type=" . $_SESSION['group_id'] . " AND User_Id <>" . $_SESSION['Login_User_Id'];
$rslt_sqlQry = mysql_query($sqlQry);
$noRow = mysql_num_rows($rslt_sqlQry);
if (!$rslt_sqlQry) {
$action_status = mysql_error();
} elseif ($noRow <= 0) {
} else {
$i = 0;
while ($row = mysql_fetch_array($rslt_sqlQry, MYSQL_NUM)) {
$Rows_Contents[$i] = array("Group_Id" => array("cName" => Check_Box(0, $row[0]), "cClass" => 'cellStyle', "cAlign" => "Left", "para_id" => true), "Group_Name" => array("cName" => $row[1], "cClass" => 'cellStyle', "cAlign" => "Left", "para_id" => false));
}
}
$AddTable = "<table width='100%' border='0'><tr><td>";
$AddTable .= data_grid($Grid_Table, $Grid_Header, $Grid_Row_Format, $Rows_Contents);
$AddTable .= "</td></tr></table>";
return $AddTable;
}
$t->assign('tPages',$_SESSION['tPages']);
$t->assign('cPage',$_SESSION['Grid_Page_No']);
$qry_Project.= " limit $offset,$limit";*/
$rslt_Project = mysql_query($qry_Project);
$noRow = mysql_num_rows($rslt_Project);
if (!$rslt_Project) {
$Data_Grid_Contents = mysql_error();
} elseif ($noRow <= 0) {
$Data_Grid_Contents = "No Data found";
} else {
$i = 0;
$Rows_Contents = array();
while ($row = mysql_fetch_array($rslt_Project, MYSQL_NUM)) {
$row[32] = '<img src="' . $row[32] . '" width="80" height="70" >';
$Rows_Contents[$i] = array("staff_id" => array("cName" => $row[0], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => true), "name" => array("cName" => $row[1], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "designation" => array("cName" => $row[2], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "department" => array("cName" => $row[3], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "birth_date" => array("cName" => $row[4], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "join_date" => array("cName" => $row[5], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "qulification" => array("cName" => $row[6], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "tech_exp_au" => array("cName" => $row[7], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "tech_exp_pg" => array("cName" => $row[8], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "tech_exp_research" => array("cName" => $row[9], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "res_pub_published" => array("cName" => $row[10], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "res_pub_present" => array("cName" => $row[11], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "res_pub_articales" => array("cName" => $row[12], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "res_pub_books" => array("cName" => $row[13], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "res_pub_working" => array("cName" => $row[14], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "res_pub_completed" => array("cName" => $row[15], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "partic_orientation" => array("cName" => $row[16], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "partic_refresher " => array("cName" => $row[17], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "partic_state" => array("cName" => $row[18], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "partic_national" => array("cName" => $row[19], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "partic_international" => array("cName" => $row[20], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "assos_univ_name_1" => array("cName" => $row[21], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "assos_univ_name_2" => array("cName" => $row[22], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "assos_univ_name_3" => array("cName" => $row[23], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "assos_body_1" => array("cName" => $row[24], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "assos_body_2" => array("cName" => $row[25], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "assos_body_3" => array("cName" => $row[26], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "assos_working_as_1" => array("cName" => $row[27], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "assos_working_as_2" => array("cName" => $row[28], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "assos_working_as_3" => array("cName" => $row[29], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "achievement" => array("cName" => $row[30], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "hobbies" => array("cName" => $row[31], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false), "image" => array("cName" => $row[32], "cClass" => 'cellStyle', "cAlign" => "left", "para_id" => false));
$i = $i + 1;
}
}
$AddTable = "<table width='100%' border='0'><tr><td>";
$AddTable .= data_grid($Grid_Table, $Grid_Header, $Grid_Row_Format, $Rows_Contents);
$AddTable .= "</td></tr></table>";
$Data_Grid_Contents = $AddTable;
$_SESSION['ExportData'] = $AddTable;
$t->assign('Data_Grid', $Data_Grid_Contents);
$t->assign('Add_Right', 'onclick="displayMessage(\'add_staff_member.php?action=New(0)\',649,700);"');
$t->assign('Form_Name', 'Staff Detail');
$t->display('middle/staff_details.tpl');
?>
