<th data-colname='machine#computer_name' class="col-md-4">Profile Name</th> <th data-colname='profile#payload_name' class="col-md-8">Payloads</th> <!--<th data-colname='profile#profile_UUID'>UUID</th> <th data-colname='profile#profile_name'>Profile Name</th> <th data-colname='profile#payload_name'>Payload Name</th> <th data-colname='profile#payload_display'>Display Name</th> <th data-colname='profile#payload_data'>Data</th> <th data-colname='profile#profile_removal_allowed'>Removable?</th> <th data-sort="desc" data-colname='profile#timestamp'>Detected</th>--> </tr> </thead> <tbody> <?php $profile_item_obj = new Profile_model(); $items = $profile_item_obj->select('profile_name, (select COUNT(DISTINCT serial_number) from profile p2 where profile.profile_name = p2.profile_name) AS num_profiles, payload_name, serial_number, GROUP_CONCAT(payload_data) as payload_data', '1 GROUP BY profile_name, payload_name, serial_number'); $profile = array(); $profilecount = array(); $payloaddata = array(); foreach ($items as $item) { $name = $item['profile_name']; $version = $item['payload_name']; $serialnumber = $item['serial_number']; $profiles = $item['num_profiles']; $profile[$name][$version] = $profiles; $payloaddata[$name][$version] = $profile_item_obj->json_to_html($item['payload_data']); $profilecount[$name] = $profiles; } ?> <?php
<p> <table class="profile table table-striped table-bordered"> <thead> <tr> <th data-i18n="name">Name</th> <th data-i18n="payload">Payload</th> </tr> </thead> <tbody> <?php $profile_item_obj = new Profile_model(); $items = $profile_item_obj->select('profile_name, payload_name, serial_number, GROUP_CONCAT(payload_data) as payload_data', 'serial_number=? GROUP BY profile_name, payload_name, serial_number', array($serial_number)); $payloaddata = array(); $profile = array(); foreach ($items as $item) { $name = $item['profile_name']; $version = $item['payload_name']; $serialnumber = $item['serial_number']; $profile[$name][$version] = $profile; $payloaddata[$name][$version] = $profile_item_obj->json_to_html($item['payload_data']); } ?> <?php foreach ($profile as $name => $value) { ?> <?php $name_url = url('module/profile/items/' . rawurlencode($name)); ?> <tr>