// $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') {