Announcements
public class XDSSalesTableRegular extends common
{
XDSSalesTableTmp xDSSalesTableTmp;
private void insertUserInfoIntoTmp(UserGroupId _userId,str _field,str _value)
{
xDSSalesTableTmp.clear();
xDSSalesTableTmp.UserId = _userId;
xDSSalesTableTmp.Field = _field;
xDSSalesTableTmp.Value = _value;
xDSSalesTableTmp.insert();
}
public XDSSalesTableTmp populateUserRangesForSalesTable()
{
DYNADDVTable dYNADDVTable;
while select dYNADDVTable
where dYNADDVTable.TableOption == DYNADDVTableOption::SalesTable
{
if(dYNADDVTable.UserType == DYNADDVUserType::UserGroup)
{
DYNADDVUserGroupTable dYNADDVUserGroupTable;
while select dYNADDVUserGroupTable
where dYNADDVUserGroupTable.GroupId == dYNADDVTable.UserGroupId
{
this.insertUserInfoIntoTmp(dYNADDVUserGroupTable.SysUserId,dYNADDVTable.Field,dYNADDVTable.Value);
}
continue;
}
this.insertUserInfoIntoTmp(dYNADDVTable.UserGroupId,dYNADDVTable.Field,dYNADDVTable.Value);
}
return xDSSalesTableTmp;
}
}
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156