// $getuserLevelPrivilages = $system->prepareSelectQuery("SELECT
// in_usrlvlpriv.usrLvl,
// in_usrlvlpriv.usrPrivilage
// FROM
// in_usrlvlpriv WHERE in_usrlvlpriv.usrLvl = '{$_POST['selUserLevel']}'");
// if ($getuserLevelPrivilages) {
// foreach ($getuserLevelPrivilages AS $aa) {
// $insertAddprivi = mysql_query("INSERT INTO `in_usrlvlpriv` (`usrLvl`, `usrPrivilage`) VALUES ('{$aa['usrLvl']}', '{$aa['usrPrivilage']}');");
// }
$time = date("h:i:s a");
$encriptedPass = sha1('MDCC' . $_POST['password'] . 'badboyes');
$system->prepareCommandQueryForAlertify("INSERT INTO `in_usr` (`usrName`, `usrFName`, `usrLName`, `usrLevel`, `usrPwd`, `usrRegDate`, `usrStatus`, `usrAddress`, `usrEmail`, `lstLgDate`, `lstLgTime`, `usrEmpNo`, `usrNIC`, `usrMobileNo`, `usrWorkTelNo`, `usrHomeTelNo`, `userBranchID`) VALUES ('{$_POST['username']}', '{$_POST['fName']}', '{$_POST['lName']}', '{$_POST['selUserLevel']}', '{$encriptedPass}', '{$_POST['date']}', '{$_POST['userStatus']}', '{$_POST['address']}', '{$_POST['eMail']}', '{$_POST['date']}', '{$time}', '{$_POST['empNo']}', '{$_POST['nic']}', '{$_POST['mobile']}', '{$_POST['work']}', '{$_POST['home']}', '{$_POST['branchID']}');", "Successfully Saved", "Sorry ..! Counld Not Be Save");
// }
} else {
if ($_POST['action'] == 'checkUname') {
$count = $system->prepareRowQuntQuary("SELECT\nin_usr.usrName\nFROM\nin_usr WHERE in_usr.usrName = '{$_POST['typeUname']}'");
echo $count;
} else {
if ($_POST['action'] == 'adminUserTbl') {
$system->prepareSelectQueryForJSON("SELECT\nin_usr.usrName,\nin_usr.usrFName,\nin_usr.usrLName,\nin_usr.usrID,\nin_usrlevel.lvName,\nin_usrlevel.usrLvlPrvSeq\nFROM\nin_usr\nINNER JOIN in_usrlevel ON in_usr.usrLevel = in_usrlevel.lvID\nWHERE in_usrlevel.usrLvlPrvSeq != '20'\nORDER BY in_usr.usrID DESC");
} else {
if ($_POST['action'] == 'getUserData') {
$system->prepareSelectQueryForJSON("SELECT\nin_usr.usrName,\nin_usr.usrFName,\nin_usr.usrLName,\nin_usr.usrID,\nin_usr.usrLevel,\nin_usr.usrPwd,\nin_usr.usrRegDate,\nin_usr.usrStatus,\nin_usr.usrAddress,\nin_usr.usrEmail,\nin_usr.lstLgDate,\nin_usr.lstLgTime,\nin_usr.usrEmpNo,\nin_usr.usrNIC,\nin_usr.usrMobileNo,\nin_usr.usrWorkTelNo,\nin_usr.usrHomeTelNo\nFROM\nin_usr WHERE in_usr.usrID = '{$_POST['userId']}'");
} else {
if ($_POST['action'] == 'updateSystemUserData') {
$system->prepareCommandQueryForAlertify("UPDATE `in_usr` SET `usrFName`='{$_POST['fName']}', `usrLName`='{$_POST['lName']}', `usrLevel`='{$_POST['selUserLevel']}', `usrRegDate`='{$_POST['date']}', `usrStatus`='{$_POST['userStatus']}', `usrAddress`='{$_POST['address']}', `usrEmail`='{$_POST['eMail']}', `lstLgDate`='', `lstLgTime`='', `usrEmpNo`='{$_POST['empNo']}', `usrNIC`='{$_POST['nic']}', `usrMobileNo`='{$_POST['mobile']}', `usrWorkTelNo`='{$_POST['work']}', `usrHomeTelNo`='{$_POST['home']}' WHERE (`usrID`='{$_POST['hiddenUserId']}');", "Successfully Updated", "Sorry ..! Counld Not Be Update");
} else {
if ($_POST['action'] == 'deleteUser') {
$system->prepareCommandQueryForAlertify("DELETE FROM `in_usr` WHERE (`usrID`='{$_POST['userId']}')", "Successfully Deleted", "Sorry ..! Counld Not Be Delete");
} else {
if ($_POST['action'] == 'loadUsernameCombo') {
