📁
ＳＫＹＳＨＥＬＬ ＭＡＮＡＧＥＲ-
🛒
PHP v7.4.33
Create Folder
Create File
Current Path:
home
/
oshofree
/
public_html
/
chbluxuries.com
/
chb_data
/
Name
Size
Permissions
Actions
📁
..
-
0755
🗑️
🔒
📄
config.php
7.06 KB
0444
🗑️
⬇️
✏️
🔒
📄
error_log
13325.85 KB
0644
🗑️
⬇️
✏️
🔒
Editing: stafftarget.php
<?php $sql = "SELECT username, SUM(price) AS total_sales FROM admin LEFT JOIN stock_orders ON admin.username = stock_orders.staff AND stock_orders.status='yes' WHERE admin.status='salesmanager' GROUP BY admin.username ORDER BY admin.s ASC"; $result = mysqli_query($con, $sql); while ($row = mysqli_fetch_assoc($result)) { $user = $row['username']; $final = $row['total_sales']; $target = 50000000; if (empty($final)) { $cot = 0; $final = 0; } else { $cot = ($final / $target) * 100; } echo ' <h4 class="small font-weight-bold">' . $user . '<span class="float-right">₦'.formatNumber($final).'/'.formatNumber($target).'</span></h4> <div class="progress mb-4"> <div class="progress-bar" role="progressbar" style="width: ' . $cot . '%" aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"></div> </div>'; } ?>
💾 Save Changes