function get_users_count_in_package($package) { $count = 0; $tariff_plans_ids = Mysql::getInstance()->from('package_in_plan')->where(array('optional' => 0, 'package_id' => $package['id']))->get()->all('plan_id'); $tariff_plans = Mysql::getInstance()->from('tariff_plan')->in('id', $tariff_plans_ids)->get()->all(); foreach ($tariff_plans as $tariff) { $count += get_users_count_in_tariff($tariff); } $count += Mysql::getInstance()->from('user_package_subscription')->where(array('package_id' => $package['id']))->count()->get()->counter(); return $count; }
<td><?php echo _('Title'); ?> </td> <td><?php echo _('Total users'); ?> </td> <td> </td> </tr> <?php foreach ($tariff_plans as $plan) { echo '<tr ' . ($plan['user_default'] == 1 ? 'style="background-color: #ecffec;"' : '') . '>'; echo '<td>' . $plan['external_id'] . '</td>'; echo '<td>' . $plan['name'] . '</td>'; echo '<td style="color: #555">' . get_users_count_in_tariff($plan) . '</td>'; echo '<td>'; echo '<a href="?edit=1&id=' . $plan['id'] . '">edit</a> '; echo '<a href="?del=1&id=' . $plan['id'] . '" onclick="if(confirm(\'' . _('Do you really want to delete this record?') . '\')){return true}else{return false}">del</a>'; echo '</td>'; echo '</tr>'; } ?> </table> </td> </tr> <tr> <td align="center"> <br> <br> <form method="POST">