Amasty Extension - Sales Reps and Dealers - Custom Attributes

Question

Hey guys I'm using this extension: https://amasty.com/sales-reps-and-dealers.html

It works beautifully but I want to make some adjustments. Essentially it creates sales reps/dealers that can have their own customers under them. Here is a visual diagram:

                               Our Awesome Company
                              /        |         \
                           Dealer1     |        Dealer2
                             /         |           \
                        Customers1    Customers2    Customers3

Our company can see all customers from groups 1,2,3.

Dealer1 can only see Customers1 and Dealer2 can only see Customers3

From what I know about SQL the customers must be linked in some way to their dealers, how would I go about checking who their dealers are? I'm hoping I can find their relation in a SQL search and eventually figure out a way to call getData('something') to see a customer's dealer.

Let me know if I can clarify my question in anyway! I tried to explain everything in a way where people without this extension could help out too.

Answer 1

Take a look at table am_perm

perm_id | uid | cid

Where:

'uid' = magento admin id 
'cid' = customer id.

To look up dealer by order id

Mage::getModel('amperm/perm')->getUserByOrder($orderId);

Mage::helper('amperm')->getCurrentSalesPersonId()

To lookup a dealer by customer Id

$perm = Mage::getModel('amperm/perm')->load($customerId, 'cid');

if($perm->getId()){
   $adminUser = Mage::getModel('admin/user')->load($perm->getUid());
   echo $adminUser->getFirstname();
}