- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
$query_list_builder = array(
'1000' => " and account = $account_id and creator = $creator_id",
'0100' => " and account = $account_id and salepoint = $salepoint_id and creator <> $creator_id ",
'0010' => " and account = $account_id and creator <> $creator_id and salepoint <> $salepoint_id ",
'0001' => " and account IN ($watchlist) and creator <> $creator_id and salepoint <> $salepoint_id and account <> $account_id ",
'1100' => " and salepoint = $salepoint_id or creator = $creator_id and account = $account_id ",
'1010' => " and account = $account_id and salepoint <> $salepoint_id or creator = $creator_id ",
'1001' => " and account IN ($watchlist) and account <> $account_id or creator = $creator_id ",
'1110' => " and account = $account_id or creator = $creator_id and salepoint = $salepoint_id ",
'1101' => " and account IN ($watchlist) and account <> $account_id or creator = $creator_id or salepoint = $salepoint_id ",
'1111' => " and account IN ($watchlist) or account = $account_id or creator = $creator_id or salepoint = $salepoint_id ",
'0000' => " and creator <> $creator_id and salepoint <> $salepoint_id and account NOT IN ($watchlist) ",
'0011' => " and account IN ($watchlist) and salepoint <> $salepoint_id and creator <> $creator_id ",
'0111' => " and account IN ($watchlist) and creator <> $creator_id ",
'0110' => " and account = $account_id and creator <> $creator_id ",
'0101' => " and account IN ($watchlist) and account <> $account_id or salepoint = $salepoint_id and creator <> $creator_id ",
'1011' => " and account IN ($watchlist) and salepoint <> $salepoint_id or creator = $creator_id ",
);