基于用户登录在阵列中执行添加的逻辑

Question

I have array like this:

// array of moderator code
Array
(
    [0] => M1
    [1] => M2
    [2] => M3
    [3] => M1
)

// array of commission amount and status based on the above array
Array
(
    [10] => Paid
    [20] => Due
    [30] => Cancelled
    [40] => Paid
)

If any of the moderator logs in, he should see only his commission details and not of others. For example, if M1 logs in, he should see like this in his my account:

OrderCode    PaidAmount    CancelledAmount    DueAmount    Action
    1      50.00 (40 + 10)     0.00             0.00        View

And similarly for other moderators also.

How do I achieve this ?

P.S.: The above arrays are just an example I am trying to understand in order to build my application. In reality, the order will contain any x number of moderators and it's corresponding commission amount and status and are going to be retrieved from the database.

Answer 1

Table Moderators id name Table Commission moderator_id commision_amt commision_status_id

Table Commission_status status_id name

when you retrieving the commission for moderator

 select * from Moderators m join Commision c on m.id = c.moderator_id join Commission_status s on c.commistion_status_id = s.status_id where moderator_id = 1(moderator id)

this will give the all commision amounts related to moderator id If any confusion free to comment

Second part summation of all amounts of one staus sum of all amounts which have specific status like paid and moderator id which logged in

select sum(commision_amt ) from Moderators m join Commision c on m.id = c.moderator_id join Commission_status s on c.commistion_status_id = s.status_id where moderator_id = 1(moderator id) and status_id =(status_id)