Conditions | 6 |
Paths | 7 |
Total Lines | 35 |
Code Lines | 23 |
Lines | 0 |
Ratio | 0 % |
Changes | 1 | ||
Bugs | 0 | Features | 0 |
1 | <?php |
||
23 | public function run($request) |
||
24 | { |
||
25 | |||
26 | $gp = ShopConfigExtension::current()->CustomerGroup(); |
||
27 | if (empty($gp)) { |
||
28 | return false; |
||
29 | } |
||
30 | |||
31 | $allCombos = DB::query( |
||
32 | 'SELECT "ID", "MemberID", "GroupID" FROM "Group_Members" WHERE "Group_Members"."GroupID" = ' |
||
33 | . $gp->ID . ';' |
||
34 | ); |
||
35 | //make an array of all combos |
||
36 | $alreadyAdded = array(); |
||
37 | $alreadyAdded[-1] = -1; |
||
38 | if ($allCombos) { |
||
|
|||
39 | foreach ($allCombos as $combo) { |
||
40 | $alreadyAdded[$combo['MemberID']] = $combo['MemberID']; |
||
41 | } |
||
42 | } |
||
43 | $unlistedMembers = DataObject::get( |
||
44 | Member::class, |
||
45 | $where = '"Member"."ID" NOT IN (' . implode(',', $alreadyAdded) . ')', |
||
46 | $sort = null, |
||
47 | $join = 'INNER JOIN "SilverShop_Order" ON "SilverShop_Order"."MemberID" = "Member"."ID"' |
||
48 | ); |
||
49 | //add combos |
||
50 | if ($unlistedMembers) { |
||
51 | $existingMembers = $gp->Members(); |
||
52 | foreach ($unlistedMembers as $member) { |
||
53 | $existingMembers->add($member); |
||
54 | echo '.'; |
||
55 | } |
||
56 | } else { |
||
57 | echo 'no new members added'; |
||
58 | } |
||
61 |