Sh3ll
OdayForums


Server : Apache
System : Linux profile 3.10.0-1160.88.1.el7.x86_64 #1 SMP Tue Mar 7 15:41:52 UTC 2023 x86_64
User : apache ( 48)
PHP Version : 8.0.28
Disable Function : NONE
Directory :  /var/www/html/mmishra/erp-10-07-2018/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : //var/www/html/mmishra/erp-10-07-2018/z
/*		
	//*******************************erp app functions
	function saveApp() {
		$this->tableID = 'erp_apps';
		$this->tupleID = $this->appID;
		if (mysql_num_rows(mysql_query("select * from $this->tableID where appID=$this->tupleID"))) {
			$this->sqlCommand = "update $this->tableID set wingID=$this->wingID,appName='$this->appName',description='$this->description',
			appURL='$this->appURL',appIcon='$this->appIcon',iconColor='$this->iconColor',
			appDept='$this->appDept',appAdmin='$this->appAdmin',adminEmail='$this->adminEmail',universal=$this->universal
			where appID=$this->tupleID";
			mysql_query($this->sqlCommand);
		} else {
			$this->sqlCommand = "insert into $this->tableID(wingID,appName,description,appURL,appIcon,iconColor,
			appDept,appAdmin,adminEmail,universal)
			values($this->wingID,'$this->appName','$this->description','$this->appURL','$this->appIcon','$this->iconColor',
			'$this->appDept','$this->appAdmin','$this->adminEmail',$this->universal)";
			mysql_query($this->sqlCommand);
			$this->appID = mysql_insert_id();
			$this->tupleID = $this->appID;
		}
	}
	
	function enableApp() {
		$this->tableID = 'erp_apps';
		$this->tupleID = $this->appID;
		$this->sqlCommand = "update $this->tableID set status='Enabled' where appID=$this->tupleID";
		mysql_query($this->sqlCommand);
	}

	function disableApp() {
		$this->tableID = 'erp_apps';
		$this->tupleID = $this->appID;
		$this->sqlCommand = "update $this->tableID set status='Disabled' where appID=$this->tupleID";
		mysql_query($this->sqlCommand);
	}

	function appUp() {
		$this->tableID = 'erp_apps';
		$this->tupleID = $this->appID;
		$rs = mysql_query("select appID from $this->tableID where wingID=$this->wingID and appID<$this->appID order by appID desc limit 0,1");
		if (mysql_num_rows($rs)) {
			$o = mysql_fetch_object($rs);
			$mid = $o->appID;		
			//shift one step up by swapping appID with previous one
			$this->sqlCommand = "update $this->tableID set appID=0 where wingID=$this->wingID and appID=$mid";
			mysql_query($this->sqlCommand);
			$this->sqlCommand = "update $this->tableID set appID=$mid where wingID=$this->wingID and appID=$this->appID";
			mysql_query($this->sqlCommand);
			$this->sqlCommand = "update $this->tableID set appID=$this->appID where wingID=$this->wingID and appID=0";
			mysql_query($this->sqlCommand);
			$this->appID = $mid;
			$this->tupleID = $this->appID;
		}
	}

	function appDown() {
		$this->tableID = 'erp_apps';
		$this->tupleID = $this->appID;
		$rs = mysql_query("select appID from $this->tableID where wingID=$this->wingID and appID>$this->appID order by appID limit 0,1");
		if (mysql_num_rows($rs)) {
			$o = mysql_fetch_object($rs);
			$mid = $o->appID;		
			//shift one step down by swapping appID with next one
			$this->sqlCommand = "update $this->tableID set appID=0 where wingID=$this->wingID and appID=$mid";
			mysql_query($this->sqlCommand);
			$this->sqlCommand = "update $this->tableID set appID=$mid where wingID=$this->wingID and appID=$this->appID";
			mysql_query($this->sqlCommand);
			$this->sqlCommand = "update $this->tableID set appID=$this->appID where wingID=$this->wingID and appID=0";
			mysql_query($this->sqlCommand);
			$this->appID = $mid;
			$this->tupleID = $this->appID;
		}
	}

	function deleteApp() {
		$this->tableID = 'erp_apps';
		$this->tupleID = $this->appID;
		$this->sqlCommand = "delete from $this->tableID where appID=$this->tupleID";
		mysql_query($this->sqlCommand);
	}
	
	function getApp() {
		$this->tableID = 'erp_apps';
		$this->tupleID = $this->appID;
		$rs = mysql_query("select * from erp_apps where appID=$this->tupleID");
		while ($o = mysql_fetch_object($rs)) {
			$this->appName = $o->appName;
			$this->description = $o->description;
			$this->appURL = $o->appURL;
			$this->appIcon = $o->appIcon;
			$this->iconColor = $o->iconColor;
			$this->appDept = $o->appDept;
			$this->appAdmin = $o->appAdmin;
			$this->adminEmail = $o->adminEmail;
			$this->universal = $o->universal;
			$this->status = $o->status;
		}
	}

	function selectApp() {
		$str = "<select name='appID'><option value='0'></option>";		
		$rs = mysql_query("select * from erp_apps where wingID=$this->wingID order by appName");
		while ($o = mysql_fetch_object($rs)) {
			$str .= "<option value='$o->appID'" .($o->appID == $this->appID ? ' selected' : ''). ">$o->appName</option>";
		}
		$str .= '</select>';

		return $str;
	}
*/
	/*
	function listApps() {
		$str = '<ul>';
		$rs = mysql_query("select a.*,w.wingName from erp_apps as a, erp_wings as w where a.wingID=w.wingID and w.wingID=$this->wingID order by appID");
		while ($o = mysql_fetch_object($rs)) {
			$str .= '<li>';
			if ($o->appID == $this->appID) {
				$str .= "<b>$o->wingName > $o->appName</b>";
			} else {
				$str .= "<a href='' onclick=\"refreshContent('menuID=$this->menuID&appID=$o->appID&tableID=erp_apps&tupleID=$o->appID'); return false;\">$o->wingName > $o->appName</a>";
			}
			$str .= '</li>';
		}
		$str .= '</ul>';
		
		return $str;
	}
	
	
	//*******************************app menu functions
	function saveMenu() {
		$this->tableID = 'erp_menus';
		$this->tupleID = $this->menuID;
		if (mysql_num_rows(mysql_query("select * from $this->tableID where menuID=$this->tupleID"))) {
			$this->sqlCommand = "update $this->tableID set appID=$this->appID,interface='$this->interface',
			menuName='$this->menuName',description='$this->description',menuURL='$this->menuURL',
			menuIcon='$this->menuIcon',protection=$this->protection
			where menuID=$this->tupleID";
			mysql_query($this->sqlCommand);
		} else {
			$this->sqlCommand = "insert into $this->tableID(appID,interface,menuName,description,menuURL,menuIcon,protection)
			values($this->appID,'$this->interface','$this->menuName','$this->description',
			'$this->menuURL','$this->menuIcon',$this->protection)";
			mysql_query($this->sqlCommand);
			$this->menuID = mysql_insert_id();
			$this->tupleID = $this->menuID;
		}
	}
	
	function enableMenu() {
		$this->tableID = 'erp_menus';
		$this->tupleID = $this->menuID;
		$this->sqlCommand = "update $this->tableID set status='Enabled' where menuID=$this->tupleID";
		mysql_query($this->sqlCommand);
	}

	function disableMenu() {
		$this->tableID = 'erp_menus';
		$this->tupleID = $this->menuID;
		$this->sqlCommand = "update $this->tableID set status='Disabled' where menuID=$this->tupleID";
		mysql_query($this->sqlCommand);
	}

	function menuUp() {
		$this->tableID = 'erp_menus';
		$this->tupleID = $this->menuID;
		$rs = mysql_query("select menuID from $this->tableID where appID=$this->appID and interface='$this->interface' and menuID<$this->menuID order by menuID desc limit 0,1");
		if (mysql_num_rows($rs)) {
			$o = mysql_fetch_object($rs);
			$mid = $o->menuID;		
			//shift one step up by swapping menuID with previous one
			$this->sqlCommand = "update $this->tableID set menuID=0 where appID=$this->appID and interface='$this->interface' and menuID=$mid";
			mysql_query($this->sqlCommand);
			$this->sqlCommand = "update $this->tableID set menuID=$mid where appID=$this->appID and interface='$this->interface' and menuID=$this->menuID";
			mysql_query($this->sqlCommand);
			$this->sqlCommand = "update $this->tableID set menuID=$this->menuID where appID=$this->appID and interface='$this->interface' and menuID=0";
			mysql_query($this->sqlCommand);
			$this->menuID = $mid;
			$this->tupleID = $this->menuID;
		}
	}

	function menuDown() {
		$this->tableID = 'erp_menus';
		$this->tupleID = $this->menuID;
		$rs = mysql_query("select menuID from $this->tableID where appID=$this->appID and interface='$this->interface' and menuID>$this->menuID order by menuID limit 0,1");
		if (mysql_num_rows($rs)) {
			$o = mysql_fetch_object($rs);
			$mid = $o->menuID;		
			//shift one step down by swapping menuID with next one
			$this->sqlCommand = "update $this->tableID set menuID=0 where appID=$this->appID and interface='$this->interface' and menuID=$mid";
			mysql_query($this->sqlCommand);
			$this->sqlCommand = "update $this->tableID set menuID=$mid where appID=$this->appID and interface='$this->interface' and menuID=$this->menuID";
			mysql_query($this->sqlCommand);
			$this->sqlCommand = "update $this->tableID set menuID=$this->menuID where appID=$this->appID and interface='$this->interface' and menuID=0";
			mysql_query($this->sqlCommand);
			$this->menuID = $mid;
			$this->tupleID = $this->menuID;
		}
	}
	
	function deleteMenu() {
		$this->tableID = 'erp_menus';
		$this->tupleID = $this->menuID;
		$this->sqlCommand = "delete from $this->tableID where menuID=$this->tupleID";
		mysql_query($this->sqlCommand);
	}
	
	function getMenu() {
		$this->tableID = 'erp_menus';
		$this->tupleID = $this->menuID;
		$rs = mysql_query("select * from erp_menus where menuID=$this->tupleID");
		while ($o = mysql_fetch_object($rs)) {
			$this->appID = $o->appID;
			$this->interface = $o->interface;
			$this->menuName = $o->menuName;
			$this->description = $o->description;
			$this->menuURL = $o->menuURL;
			$this->menuIcon = $o->menuIcon;
			$this->protection = $o->protection;
			$this->status = $o->status;
		}
	}

	function selectMenu() {
		$str = "<select name='menuID'><option value='0'></option>";		
		$rs = mysql_query("select * from erp_menus order by appID,menuID");
		while ($o = mysql_fetch_object($rs)) {
			$str .= "<option value='$o->menuID'" .($o->menuID == $this->menuID ? ' selected' : ''). ">$o->menuName</option>";
		}
		$str .= '</select>';
		
		return $str;
	}
*/
/*
	function listMenus() {
		$str = '<ul>';
		$rs = mysql_query("select m.*,a.appName,w.wingName from erp_menus as m,erp_apps as a, erp_wings as w where m.appID=a.appID and a.wingID=w.wingID and w.wingID=$this->wingID order by wingName,appName,interface,menuID");
		while ($o = mysql_fetch_object($rs)) {
			$str .= '<li>';
			if ($o->menuID == $this->menuID) {
				$str .= "<b>$o->wingName > $o->appName > $o->menuName</b>";
			} else {
				$str .= "<a href='' onclick=\"refreshContent('menuID=$this->menuID&&menuID=$o->menuID&tableID=erp_menus&tupleID=$o->menuID'); return false;\">$o->wingName > $o->appName > $o->menuName</a>";
			}
			$str .= '</li>';
		}
		$str .= '</ul>';
		
		return $str;
	}
	

	//*******************************erp group functions
	function saveGroup() {
		$this->tableID = 'erp_groups';
		$this->tupleID = $this->groupID;
		if (mysql_num_rows(mysql_query("select * from $this->tableID where groupID=$this->tupleID"))) {
			$this->sqlCommand = "update $this->tableID set groupName='$this->groupName',
			aclInsert=$this->aclInsert,aclUpdate=$this->aclUpdate,aclDelete=$this->aclDelete
			where groupID=$this->tupleID";
			mysql_query($this->sqlCommand);
		} else {
			$this->sqlCommand = "insert into $this->tableID(groupName,aclInsert,aclUpdate,aclDelete) 
			values('$this->groupName',$this->aclInsert,$this->aclUpdate,$this->aclDelete)";
			mysql_query($this->sqlCommand);
			$this->rowID = mysql_insert_id();
			$this->tupleID = $this->groupID;
		}
	}
	
	function enableGroup() {
		$this->tableID = 'erp_groups';
		$this->tupleID = $this->groupID;
		$this->sqlCommand = "update $this->tableID set status='Enabled' where groupID=$this->tupleID";
		mysql_query($this->sqlCommand);
	}

	function disableGroup() {
		$this->tableID = 'erp_groups';
		$this->tupleID = $this->groupID;
		$this->sqlCommand = "update $this->tableID set status='Disabled' where groupID=$this->tupleID";
		mysql_query($this->sqlCommand);
	}

	function deleteGroup() {
		$this->tableID = 'erp_groups';
		$this->tupleID = $this->groupID;
		$this->sqlCommand = "delete from $this->tableID where groupID=$this->tupleID";
		mysql_query($this->sqlCommand);
	}
	
	function getGroup() {
		$this->tableID = 'erp_groups';
		$this->tupleID = $this->groupID;
		$rs = mysql_query("select * from erp_groups where groupID=$this->tupleID");
		while ($o = mysql_fetch_object($rs)) {
			$this->groupName = $o->groupName;
			$this->aclInsert = $o->aclInsert;
			$this->aclUpdate = $o->aclUpdate;
			$this->aclDelete = $o->aclDelete;
			$this->status = $o->status;
		}
	}

	function selectGroup() {
		$str = "<select name='groupID'><option value='0'></option>";		
		$rs = mysql_query("select * from erp_groups order by groupName");
		while ($o = mysql_fetch_object($rs)) {
			$str .= "<option value='$o->groupID'" .($o->groupID == $this->groupID ? ' selected' : ''). ">$o->groupName</option>";
		}
		$str .= '</select>';
		
		return $str;
	}

	function listGroups() {
		$str = '<ul>'; 
		$rs = mysql_query("select * from erp_groups order by groupName");
		while ($o = mysql_fetch_object($rs)) {
			$str .= '<li>';
			if ($o->groupID == $this->groupID) {
				$str .= "<b>$o->groupName</b>";
			} else {
				$str .= "<a href='' onclick=\"refreshContent('menuID=$this->menuID&groupID=$o->groupID&tableID=erp_groups&tupleID=$o->groupID'); return false;\">$o->groupName</a>";
			}
			$str .= '</li>';
		}
		$str .= '</ul>';
		
		return $str;
	}
	
	//*******************************erp user functions
	function saveUser() {
		$this->tableID = 'erp_users';
		$this->tupleID = $this->userID;
		if (mysql_num_rows(mysql_query("select * from $this->tableID where userID=$this->tupleID"))) {
			$this->sqlCommand = "update $this->tableID set groupID=$this->groupID,loginID='$this->loginID',
			aclInsert=$this->aclInsert,aclUpdate=$this->aclUpdate,aclDelete=$this->aclDelete
			where userID=$this->tupleID";
			mysql_query($this->sqlCommand);
		} else {
			$this->sqlCommand = "insert into $this->tableID(groupID,loginID,aclInsert,aclUpdate,aclDelete)
			values($this->groupID,'$this->loginID',$this->aclInsert,$this->aclUpdate,$this->aclDelete)";
			mysql_query($this->sqlCommand);
			$this->userID = mysql_insert_id();
			$this->tupleID = $this->userID;
		}
	}
	
	function enableUser() {
		$this->tableID = 'erp_users';
		$this->tupleID = $this->userID;
		$this->sqlCommand = "update $this->tableID set status='Enabled' where userID=$this->tupleID";
		mysql_query($this->sqlCommand);
	}

	function disableUser() {
		$this->tableID = 'erp_users';
		$this->tupleID = $this->userID;
		$this->sqlCommand = "update $this->tableID set status='Disabled' where userID=$this->tupleID";
		mysql_query($this->sqlCommand);
	}

	function deleteUser() {
		$this->tableID = 'erp_users';
		$this->tupleID = $this->userID;
		$this->sqlCommand = "delete from $this->tableID where userID=$this->tupleID";
		mysql_query($this->sqlCommand);
	}
	
	function getUser() {
		$this->tableID = 'erp_users';
		$this->tupleID = $this->userID;
		$rs = mysql_query("select * from erp_users where userID=$this->tupleID");
		while ($o = mysql_fetch_object($rs)) {
			$this->loginID = $o->loginID;
			$this->groupID = $o->groupID;
			$this->aclInsert = $o->aclInsert;
			$this->aclUpdate = $o->aclUpdate;
			$this->aclDelete = $o->aclDelete;
			$this->status = $o->status;
		}
	}

	function selectUser() {
		$str = "<select name='userID'><option value='0'></option>";		
		$rs = mysql_query("select * from erp_users order by loginID");
		while ($o = mysql_fetch_object($rs)) {
			$str .= "<option value='$o->userID'" .($o->userID == $this->userID ? ' selected' : ''). ">$o->loginID</option>";
		}
		$str .= '</select>';
		
		return $str;
	}

	function listUsers() {
		$str = '<ul>'; 
		$rs = mysql_query("select u.*,g.groupName from erp_users as u,erp_groups as g where u.groupID=g.groupID order by groupName,loginID");
		while ($o = mysql_fetch_object($rs)) {
			$str .= '<li>';
			if ($o->userID == $this->userID) {
				$str .= "<b>$o->groupName > $o->loginID</b>";
			} else {
				$str .= "<a href='' onclick=\"refreshContent('menuID=$this->menuID&userID=$o->userID&tableID=erp_users&tupleID=$o->userID'); return false;\">$o->groupName > $o->loginID</a>";
			}
			$str .= '</li>';
		}
		$str .= '</ul>';
		
		return $str;
	}
	
	//*******************************user ACL functions
	function saveAcl() {
		$this->tableID = 'erp_acls';
		$this->tupleID = $this->aclID;
		if (mysql_num_rows(mysql_query("select * from $this->tableID where aclID=$this->tupleID"))) {
			$this->sqlCommand = "update $this->tableID set menuID=$this->menuID,userID=$this->userID,
			aclInsert=$this->aclInsert,aclUpdate=$this->aclUpdate,aclDelete=$this->aclDelete
			where aclID=$this->tupleID";
			mysql_query($this->sqlCommand);
		} else {
			$this->sqlCommand = "insert into $this->tableID(menuID,userID,aclInsert,aclUpdate,aclDelete)
			values($this->menuID,$this->userID,$this->aclInsert,$this->aclUpdate,$this->aclDelete)";
			mysql_query($this->sqlCommand);
			$this->aclID = mysql_insert_id();
			$this->tupleID = $this->aclID;
		}
	}
	
	function enableAcl() {
		$this->tableID = 'erp_acls';
		$this->tupleID = $this->aclID;
		$this->sqlCommand = "update $this->tableID set status='Enabled' where aclID=$this->tupleID";
		mysql_query($this->sqlCommand);
	}

	function disableAcl() {
		$this->tableID = 'erp_acls';
		$this->tupleID = $this->aclID;
		$this->sqlCommand = "update $this->tableID set status='Disabled' where aclID=$this->tupleID";
		mysql_query($this->sqlCommand);
	}

	function deleteAcl() {
		$this->tableID = 'erp_acls';
		$this->tupleID = $this->aclID;
		$this->sqlCommand = "delete from $this->tableID where aclID=$this->tupleID";
		mysql_query($this->sqlCommand);
	}
	
	function getAcl() {
		$this->tableID = 'erp_acls';
		$this->tupleID = $this->aclID;
		$rs = mysql_query("select * from erp_acls where aclID=$this->tupleID");
		while ($o = mysql_fetch_object($rs)) {
			$this->menuID = $o->menuID;
			$this->userID = $o->userID;
			$this->aclInsert = $o->aclInsert;
			$this->aclUpdate = $o->aclUpdate;
			$this->aclDelete = $o->aclDelete;
			$this->status = $o->status;
		}
	}

	function listAcls() {
		$str = '<ul>'; 
		$rs = mysql_query("select a.*,m.menuName,u.loginID from erp_acls as a, erp_menus as m, erp_users as u where a.menuID=m.menuID and a.userID=u.userID order by a.userID,aclID");
		while ($o = mysql_fetch_object($rs)) {
			$str .= '<li>';
			if ($o->aclID == $this->aclID) {
				$str .= "<b>$o->loginID > $o->menuName</b>";
			} else {
				$str .= "<a href='' onclick=\"refreshContent('menuID=$this->menuID&aclID=$o->aclID&tableID=erp_acls&tupleID=$o->aclID'); return false;\">$o->loginID > $o->menuName</a>";
			}
			$str .= '</li>';
		}
		$str .= '</ul>';
		
		return $str;
	}
*/
	/*	
	function erpInterface() {
		$rs = mysql_query("select * from erp_menus where menuID=$this->menuID");
		if (mysql_num_rows($rs)) {
			$o = mysql_fetch_object($rs);
			return $o->menuURL;
		} else {
			$this->error = "<i class='fas fa-ban'></i> The requested page is missing. Contact erp.support@iiita.ac.in. Thanks <i class='far fa-smile'></i>";
			return 'erp_dashboard';	
		}
	}
	*/

	    function selectWing() {
 
        $str = "<table width='200px'>";
        $rs = mysql_query("select * from erp_wings where status='Enabled' order by wingID");
        while ($o = mysql_fetch_object($rs)) {
            if ($this->wingID0 == $o->wingID) { 
                $str .= "<tr><td align='center'><i class='$o->wingIcon' style='font-size:20px'></i></td><td><b>$o->wingName <i class='fas fa-check'></i></b></td></tr>";
            } else {
                $str .= "<tr><td align='center'><a href='' onclick=\"refreshMenu('wingID0=$o->wingID'); return false;\" title='$o->description'><i class='$o->wingIcon' style='font-size:20px'></i></a></td><td> $o->wingName</td></tr>";
            }
    }
        $str .= "</table>";

        return $str;
    }

    
    function selectApp() {
        $str = "<select name='appID'><option value='0'></option>";		
        $rs = mysql_query("select * from erp_apps where wingID=$this->wingID0 order by appName");
        while ($o = mysql_fetch_object($rs)) {
            $str .= "<option value='$o->appID'" .($o->appID == $this->appID ? ' selected' : ''). ">$o->appName</option>";
        }
        $str .= '</select>';

        return $str;
    }

    function listApps() {
        $str = '<ul>';
        $rs = mysql_query("select a.*,w.wingName from erp_apps as a, erp_wings as w where a.wingID=w.wingID and w.wingID=$this->wingID0 order by appID");
        while ($o = mysql_fetch_object($rs)) {
            $str .= '<li>';
            if ($o->appID == $this->appID) {
                $str .= "<b>$o->wingName > $o->appName</b>";
            } else {
                $str .= "<a href='' onclick=\"refreshContent('pageID0=$this->pageID0&appID=$o->appID&tableID=erp_apps&tupleID=$o->appID'); return false;\">$o->wingName > $o->appName</a>";
            }
            $str .= '</li>';
        }
        $str .= '</ul>';

        return $str;
    }


    function selectMenu() {
        $str = "<select name='menuID'><option value='0'></option>";		
        $rs = mysql_query("select * from erp_menus order by appID,menuID");
        while ($o = mysql_fetch_object($rs)) {
            $str .= "<option value='$o->menuID'" .($o->menuID == $this->menuID ? ' selected' : ''). ">$o->menuName</option>";
        }
        $str .= '</select>';

        return $str;
    }

    function listMenus() {
        $str = '<ul>';
        $rs = mysql_query("select m.*,a.appName,w.wingName from erp_menus as m,erp_apps as a, erp_wings as w where m.appID=a.appID and a.wingID=w.wingID and w.wingID=$this->wingID0 order by wingName,appName,interface,menuID");
        while ($o = mysql_fetch_object($rs)) {
            $str .= '<li>';
            if ($o->menuID == $this->menuID) {
                $str .= "<b>$o->wingName > $o->appName > $o->menuName</b>";
            } else {
                $str .= "<a href='' onclick=\"refreshContent('pageID0=$this->pageID0&&menuID=$o->menuID&tableID=erp_menus&tupleID=$o->menuID'); return false;\">$o->wingName > $o->appName > $o->menuName</a>";
            }
            $str .= '</li>';
        }
        $str .= '</ul>';

        return $str;
    }
*/

/*
    function selectGroup() {
        $str = "<select name='groupID'><option value='0'></option>";		
        $rs = mysql_query("select * from erp_groups order by groupName");
        while ($o = mysql_fetch_object($rs)) {
            $str .= "<option value='$o->groupID'" .($o->groupID == $this->groupID ? ' selected' : ''). ">$o->groupName</option>";
        }
        $str .= '</select>';

        return $str;
    }

    function listGroups() {
        $str = '<ul>'; 
        $rs = mysql_query("select * from erp_groups order by groupName");
        while ($o = mysql_fetch_object($rs)) {
            $str .= '<li>';
            if ($o->groupID == $this->groupID) {
                    $str .= "<b>$o->groupName</b>";
            } else {
                    $str .= "<a href='' onclick=\"refreshContent('pageID0=$this->pageID0&groupID=$o->groupID&tableID=erp_groups&tupleID=$o->groupID'); return false;\">$o->groupName</a>";
            }
            $str .= '</li>';
        }
        $str .= '</ul>';

        return $str;
    }
*/
/*
     function selectUser() {
 
        $str = "<select name='userID'><option value='0'></option>";		
        $rs = mysql_query("select * from erp_users order by loginID");
        while ($o = mysql_fetch_object($rs)) {
            $str .= "<option value='$o->userID'" .($o->userID == $this->userID ? ' selected' : ''). ">$o->loginID</option>";
        }
        $str .= '</select>';

        return $str;
    }

    function listUsers() {
        $str = '<ul>'; 
        $rs = mysql_query("select u.*,g.groupName from erp_users as u,erp_groups as g where u.groupID=g.groupID order by groupName,loginID");
        while ($o = mysql_fetch_object($rs)) {
            $str .= '<li>';
            if ($o->userID == $this->userID) {
                $str .= "<b>$o->groupName > $o->loginID</b>";
            } else {
                $str .= "<a href='' onclick=\"refreshContent('pageID0=$this->pageID0&userID=$o->userID&tableID=erp_users&tupleID=$o->userID'); return false;\">$o->groupName > $o->loginID</a>";
            }
            $str .= '</li>';
        }
        $str .= '</ul>';

        return $str;
    }
*/
/*
    function listAcls() {
        $str = '<ul>'; 
        $rs = mysql_query("select a.*,m.menuName,u.loginID from erp_acls as a, erp_menus as m, erp_users as u where a.menuID=m.menuID and a.userID=u.userID order by a.userID,aclID");
        while ($o = mysql_fetch_object($rs)) {
            $str .= '<li>';
            if ($o->aclID == $this->aclID) {
                $str .= "<b>$o->loginID > $o->menuName</b>";
            } else {
                $str .= "<a href='' onclick=\"refreshContent('pageID0=$this->pageID0&aclID=$o->aclID&tableID=erp_acls&tupleID=$o->aclID'); return false;\">$o->loginID > $o->menuName</a>";
            }
            $str .= '</li>';
        }
        $str .= '</ul>';

        return $str;
    }
*/


ZeroDay Forums Mini