374 lines
25 KiB
PHP
Executable File
374 lines
25 KiB
PHP
Executable File
<?php
|
|
require_once('fixed/config/go_con.php');
|
|
access(167);
|
|
|
|
$today = date("Y-m");
|
|
if (!empty($_GET['date'])) {
|
|
$today = $_GET['date'];
|
|
if (DateTime::createFromFormat('Y-m', $today) == false) {
|
|
$today = date("Y-m");
|
|
}
|
|
}
|
|
|
|
$Next = date('Y-m', strtotime('+1 month', strtotime($today)));
|
|
$Previous = date('Y-m', strtotime('-1 month', strtotime($today)));
|
|
|
|
$branch_id = $_GET['b'];
|
|
if (!empty($_GET['b'])) {
|
|
$branch_id = $_GET['b'];
|
|
if (!is_numeric($branch_id)) {
|
|
$branch_id = 1;
|
|
}
|
|
} else {
|
|
$branch_id = 1;
|
|
}
|
|
$branch_sql = '='.$branch_id;
|
|
if ($branch_id == 1) {
|
|
$branch_sql = '<>'.$branch_id;
|
|
}
|
|
?>
|
|
<!DOCTYPE html>
|
|
<html lang="en" dir="rtl">
|
|
<?php require_once('fixed/head/go.php'); ?>
|
|
<body class="rtl">
|
|
<link rel="stylesheet" href="//cdn.jsdelivr.net/npm/@mdi/font@6.5.95/css/materialdesignicons.min.css">
|
|
<style>
|
|
a.active {
|
|
background-color: #e6edef;
|
|
}
|
|
h1 {
|
|
background: #24695c;
|
|
padding-right: 10px;
|
|
color: white;
|
|
margin-left: 10px;
|
|
font-weight: bold;
|
|
}
|
|
</style>
|
|
<?php require_once('fixed/loader/go.php'); ?>
|
|
<!-- page-wrapper Start-->
|
|
<div class="page-wrapper" id="pageWrapper">
|
|
<?php require_once('fixed/header/go.php'); ?>
|
|
<!-- Page Body Start-->
|
|
<div class="page-body-wrapper">
|
|
<?php require_once('fixed/sidebar/go.php'); ?>
|
|
<div class="page-body">
|
|
<!-- Container-fluid starts-->
|
|
<div class="container-fluid">
|
|
<div class="email-wrap bookmark-wrap">
|
|
<div class="row">
|
|
<div class="col-12 col-sm-12 col-md-12 col-lg-2 col-xl-2">
|
|
<div class="card">
|
|
<div class="card-body new-user order-list profile-nav">
|
|
<div class="nav flex-column nav-pills" id="profile-tab" aria-orientation="vertical">
|
|
<?php
|
|
$commercial_register_sql = mysqli_query($db, "SELECT `branch`.`branch_name`, `branch`.`id`
|
|
FROM `commercial_register`
|
|
LEFT JOIN `branch` ON `commercial_register`.`id` = `branch`.`commercial_register_id`"
|
|
);
|
|
while ($commercial_register = mysqli_fetch_assoc($commercial_register_sql)) {
|
|
?>
|
|
<a class="nav-link mb-0 <?php if($branch_id == $commercial_register['id']){echo 'active';}?> ?>" data-toggle="pill" href="#branch-<?=$commercial_register['id']?>" aria-selected="false" onclick="window.location='w_user_bonds?b=<?=$commercial_register['id']?>'"><?=$commercial_register['branch_name']?></a>
|
|
<?php
|
|
}
|
|
?>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="col-12 col-sm-12 col-md-12 col-lg-10 col-xl-10">
|
|
<div class="card">
|
|
<div class="tab-content" id="profile-tabContent">
|
|
<div class="tab-pane fade show active" id="all">
|
|
<div class="card-body new-user order-list text-center">
|
|
<div class="row">
|
|
<div class="col-12 col-sm-12 col-md-3 col-lg-4 col-xl-4">
|
|
</div>
|
|
<div class="page-title mb-3 col-12 col-sm-12 col-md-6 col-lg-4 col-xl-4">
|
|
<i class="mdi mdi-monitor mr-2">
|
|
</i>
|
|
<h4>
|
|
باقات شهر
|
|
<br/>
|
|
<?=$today?>
|
|
</h4>
|
|
</div>
|
|
<div class="col-12 col-sm-12 col-md-3 col-lg-4 col-xl-4">
|
|
</div>
|
|
</div>
|
|
<div class="row">
|
|
<div class="col-12 col-sm-12 col-md-2 col-lg-3 col-xl-3">
|
|
</div>
|
|
<div class="col-2 col-sm-2 col-md-1 col-lg-1 col-xl-1">
|
|
<a class="btn btn-danger btn-round waves-effect waves-light col-12" href="w_user_bonds?date=<?= $Previous ?>&b=<?= $branch_id ?>" style="padding: 0.375rem 0.75rem;">-</a>
|
|
</div>
|
|
<div class="col-8 col-sm-8 col-md-6 col-lg-4 col-xl-4">
|
|
<input id="Select-date" class="form-control" type="date" value="" style="text-align: center !important;">
|
|
</div>
|
|
<div class="col-2 col-sm-2 col-md-1 col-lg-1 col-xl-1">
|
|
<a class="btn btn-primary btn-round waves-effect waves-light col-12" href="w_user_bonds?date=<?= $Next ?>&b=<?= $branch_id ?>" style="padding: 0.375rem 0.75rem;">+</a>
|
|
</div>
|
|
<div class="col-12 col-sm-12 col-md-2 col-lg-3 col-xl-3">
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="tab-content">
|
|
<div class="tab-pane p-3 active" id="tab<?=$tabs?>" role="tabpanel">
|
|
<div class="card-body new-user order-list">
|
|
<div class="table-responsive">
|
|
<table id="employee_data" class="table table-bordered text-center" style="vertical-align: middle;">
|
|
<thead class="table-primary" style="vertical-align: middle;">
|
|
<tr>
|
|
<th scope="col">اسم الموظف</th>
|
|
<th scope="col">اجمالي الباقات</th>
|
|
<th scope="col">باقة 460</th>
|
|
<th scope="col">باقة 575</th>
|
|
<th scope="col">الباقة الفضية</th>
|
|
<th scope="col">الباقة الذهبية</th>
|
|
<th scope="col">الباقة الالماسية</th>
|
|
<th scope="col">المبلغ</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
$get_bonds_sql = mysqli_query($db,
|
|
"SELECT
|
|
COUNT(`p_bonds`.`id`) AS ccc,
|
|
`user`.`name` AS `username`,
|
|
(
|
|
SELECT
|
|
COUNT(`bonds`.`id`) AS `total`
|
|
FROM `bonds`
|
|
INNER JOIN `bonds_details` AS `pack1` ON `pack1`.`bonds_id` = `bonds`.`id`
|
|
INNER JOIN `bonds_details_has_packages` ON `bonds_details_has_packages`.`bonds_details_id` = (SELECT MIN(`bonds_details`.`id`) FROM `bonds_details` WHERE `bonds_details`.`bonds_id` = `bonds`.`id`)
|
|
WHERE `bonds_details_has_packages`.`packages_id` = 3
|
|
AND `pack1`.`id` IN (SELECT MIN(`bonds_details`.`id`) FROM `bonds_details` WHERE `bonds_details`.`bonds_id` = `bonds`.`id`)
|
|
AND `bonds`.`user_id` = `user`.`id`
|
|
AND `bonds`.`date_time` LIKE '$today%'
|
|
) AS `pack460`,
|
|
|
|
(
|
|
SELECT
|
|
COUNT(`bonds`.`id`) AS `total`
|
|
FROM `bonds`
|
|
INNER JOIN `bonds_details` AS `pack1` ON `pack1`.`bonds_id` = `bonds`.`id`
|
|
INNER JOIN `bonds_details_has_packages` ON `bonds_details_has_packages`.`bonds_details_id` = (SELECT MIN(`bonds_details`.`id`) FROM `bonds_details` WHERE `bonds_details`.`bonds_id` = `bonds`.`id`)
|
|
WHERE `bonds_details_has_packages`.`packages_id` = 4
|
|
AND `pack1`.`id` IN (SELECT MIN(`bonds_details`.`id`) FROM `bonds_details` WHERE `bonds_details`.`bonds_id` = `bonds`.`id`)
|
|
AND `bonds`.`user_id` = `user`.`id`
|
|
AND `bonds`.`date_time` LIKE '$today%'
|
|
) AS `pack575`,
|
|
|
|
(
|
|
SELECT
|
|
COUNT(`bonds`.`id`) AS `total`
|
|
FROM `bonds`
|
|
INNER JOIN `bonds_details` AS `pack1` ON `pack1`.`bonds_id` = `bonds`.`id`
|
|
INNER JOIN `bonds_details_has_packages` ON `bonds_details_has_packages`.`bonds_details_id` = (SELECT MIN(`bonds_details`.`id`) FROM `bonds_details` WHERE `bonds_details`.`bonds_id` = `bonds`.`id`)
|
|
WHERE `bonds_details_has_packages`.`packages_id` = 10
|
|
AND `pack1`.`id` IN (SELECT MIN(`bonds_details`.`id`) FROM `bonds_details` WHERE `bonds_details`.`bonds_id` = `bonds`.`id`)
|
|
AND `bonds`.`user_id` = `user`.`id`
|
|
AND `bonds`.`date_time` LIKE '$today%'
|
|
) AS `packsilver`,
|
|
|
|
(
|
|
SELECT
|
|
COUNT(`bonds`.`id`) AS `total`
|
|
FROM `bonds`
|
|
INNER JOIN `bonds_details` AS `pack1` ON `pack1`.`bonds_id` = `bonds`.`id`
|
|
INNER JOIN `bonds_details_has_packages` ON `bonds_details_has_packages`.`bonds_details_id` = (SELECT MIN(`bonds_details`.`id`) FROM `bonds_details` WHERE `bonds_details`.`bonds_id` = `bonds`.`id`)
|
|
WHERE `bonds_details_has_packages`.`packages_id` = 11
|
|
AND `pack1`.`id` IN (SELECT MIN(`bonds_details`.`id`) FROM `bonds_details` WHERE `bonds_details`.`bonds_id` = `bonds`.`id`)
|
|
AND `bonds`.`user_id` = `user`.`id`
|
|
AND `bonds`.`date_time` LIKE '$today%'
|
|
) AS `packgold`,
|
|
|
|
(
|
|
SELECT
|
|
COUNT(`bonds`.`id`) AS `total`
|
|
FROM `bonds`
|
|
INNER JOIN `bonds_details` AS `pack1` ON `pack1`.`bonds_id` = `bonds`.`id`
|
|
INNER JOIN `bonds_details_has_packages` ON `bonds_details_has_packages`.`bonds_details_id` = (SELECT MIN(`bonds_details`.`id`) FROM `bonds_details` WHERE `bonds_details`.`bonds_id` = `bonds`.`id`)
|
|
WHERE `bonds_details_has_packages`.`packages_id` = 12
|
|
AND `pack1`.`id` IN (SELECT MIN(`bonds_details`.`id`) FROM `bonds_details` WHERE `bonds_details`.`bonds_id` = `bonds`.`id`)
|
|
AND `bonds`.`user_id` = `user`.`id`
|
|
AND `bonds`.`date_time` LIKE '$today%'
|
|
) AS `packdimond`
|
|
|
|
|
|
FROM `bonds` AS `p_bonds`
|
|
LEFT JOIN `bonds_details` AS `dd` ON `dd`.`bonds_id` = `p_bonds`.`id`
|
|
LEFT JOIN `bonds_details_has_packages` ON `bonds_details_has_packages`.`bonds_details_id` = `dd`.`id`
|
|
LEFT JOIN `packages` ON `bonds_details_has_packages`.`packages_id` = `packages`.`id`
|
|
LEFT JOIN `user` ON `p_bonds`.`user_id` = `user`.`id`
|
|
LEFT JOIN `branch` ON `dd`.`branch_id` = `branch`.`id`
|
|
|
|
WHERE `dd`.`branch_id` $branch_sql
|
|
AND `dd`.`id` IN (SELECT MAX(`id`) FROM `bonds_details` WHERE `bonds_id` = `dd`.`bonds_id`)
|
|
AND `p_bonds`.`bonds_type_type_id` = 3
|
|
AND `branch`.`commercial_register_id` = 3
|
|
AND `p_bonds`.`date_time` LIKE '$today%'
|
|
GROUP BY `user`.`id`
|
|
");
|
|
$ccc = 0;
|
|
$pack460 = 0;
|
|
$pack575 = 0;
|
|
$packsilver = 0;
|
|
$packgold = 0;
|
|
$packdimond = 0;
|
|
$total_ppuu = 0;
|
|
while ($get_invoices = mysqli_fetch_assoc($get_bonds_sql)) {
|
|
?>
|
|
<tr>
|
|
<td><?=$get_invoices['username']?></td>
|
|
<td><?=$get_invoices['ccc']?></td>
|
|
<td><?=$get_invoices['pack460']?></td>
|
|
<td><?=$get_invoices['pack575']?></td>
|
|
<td><?=$get_invoices['packsilver']?></td>
|
|
<td><?=$get_invoices['packgold']?></td>
|
|
<td><?=$get_invoices['packdimond']?></td>
|
|
<td>
|
|
<?php
|
|
$total_pp = 0;
|
|
if ($get_invoices['pack460'] > 0) {
|
|
if ($get_invoices['pack460'] > 0 && $get_invoices['pack460'] < 10) {
|
|
$total_pp += $get_invoices['pack460'] * 5;
|
|
} else if ($get_invoices['pack460'] >= 10 && $get_invoices['pack460'] < 20) {
|
|
$total_pp += $get_invoices['pack460'] * 7.5;
|
|
} else if ($get_invoices['pack460'] >= 20 && $get_invoices['pack460'] < 30) {
|
|
$total_pp += $get_invoices['pack460'] * 10;
|
|
} else if ($get_invoices['pack460'] >= 30 && $get_invoices['pack460'] < 40) {
|
|
$total_pp += $get_invoices['pack460'] * 12.5;
|
|
} else if ($get_invoices['pack460'] >= 40 && $get_invoices['pack460'] < 50) {
|
|
$total_pp += $get_invoices['pack460'] * 15;
|
|
} else if ($get_invoices['pack460'] >= 50) {
|
|
$total_pp += $get_invoices['pack460'] * 17.5;
|
|
}
|
|
}
|
|
if ($get_invoices['pack575'] > 0) {
|
|
if ($get_invoices['pack575'] > 0 && $get_invoices['pack575'] < 10) {
|
|
$total_pp += $get_invoices['pack575'] * 5;
|
|
} else if ($get_invoices['pack575'] >= 10 && $get_invoices['pack575'] < 20) {
|
|
$total_pp += $get_invoices['pack575'] * 7.5;
|
|
} else if ($get_invoices['pack575'] >= 20 && $get_invoices['pack575'] < 30) {
|
|
$total_pp += $get_invoices['pack575'] * 10;
|
|
} else if ($get_invoices['pack575'] >= 30 && $get_invoices['pack575'] < 40) {
|
|
$total_pp += $get_invoices['pack575'] * 12.5;
|
|
} else if ($get_invoices['pack575'] >= 40 && $get_invoices['pack575'] < 50) {
|
|
$total_pp += $get_invoices['pack575'] * 15;
|
|
} else if ($get_invoices['pack575'] >= 50) {
|
|
$total_pp += $get_invoices['pack575'] * 17.5;
|
|
}
|
|
}
|
|
if ($get_invoices['packsilver'] > 0) {
|
|
if ($get_invoices['packsilver'] > 0 && $get_invoices['packsilver'] < 10) {
|
|
$total_pp += $get_invoices['packsilver'] * 5;
|
|
} else if ($get_invoices['packsilver'] >= 10 && $get_invoices['packsilver'] < 20) {
|
|
$total_pp += $get_invoices['packsilver'] * 10;
|
|
} else if ($get_invoices['packsilver'] >= 20 && $get_invoices['packsilver'] < 30) {
|
|
$total_pp += $get_invoices['packsilver'] * 15;
|
|
} else if ($get_invoices['packsilver'] >= 30 && $get_invoices['packsilver'] < 40) {
|
|
$total_pp += $get_invoices['packsilver'] * 20;
|
|
} else if ($get_invoices['packsilver'] >= 40 && $get_invoices['packsilver'] < 50) {
|
|
$total_pp += $get_invoices['packsilver'] * 25;
|
|
} else if ($get_invoices['packsilver'] >= 50) {
|
|
$total_pp += $get_invoices['packsilver'] * 30;
|
|
}
|
|
}
|
|
if ($get_invoices['packgold'] > 0) {
|
|
if ($get_invoices['packgold'] > 0 && $get_invoices['packgold'] < 10) {
|
|
$total_pp += $get_invoices['packgold'] * 6;
|
|
} else if ($get_invoices['packgold'] >= 10 && $get_invoices['packgold'] < 20) {
|
|
$total_pp += $get_invoices['packgold'] * 13;
|
|
} else if ($get_invoices['packgold'] >= 20 && $get_invoices['packgold'] < 30) {
|
|
$total_pp += $get_invoices['packgold'] * 20;
|
|
} else if ($get_invoices['packgold'] >= 30 && $get_invoices['packgold'] < 40) {
|
|
$total_pp += $get_invoices['packgold'] * 27;
|
|
} else if ($get_invoices['packgold'] >= 40 && $get_invoices['packgold'] < 50) {
|
|
$total_pp += $get_invoices['packgold'] * 30;
|
|
} else if ($get_invoices['packgold'] >= 50) {
|
|
$total_pp += $get_invoices['packgold'] * 40;
|
|
}
|
|
}
|
|
if ($get_invoices['packdimond'] > 0) {
|
|
if ($get_invoices['packdimond'] > 0 && $get_invoices['packdimond'] < 10) {
|
|
$total_pp += $get_invoices['packdimond'] * 10;
|
|
} else if ($get_invoices['packdimond'] >= 10 && $get_invoices['packdimond'] < 20) {
|
|
$total_pp += $get_invoices['packdimond'] * 20;
|
|
} else if ($get_invoices['packdimond'] >= 20 && $get_invoices['packdimond'] < 30) {
|
|
$total_pp += $get_invoices['packdimond'] * 30;
|
|
} else if ($get_invoices['packdimond'] >= 30 && $get_invoices['packdimond'] < 40) {
|
|
$total_pp += $get_invoices['packdimond'] * 40;
|
|
} else if ($get_invoices['packdimond'] >= 40 && $get_invoices['packdimond'] < 50) {
|
|
$total_pp += $get_invoices['packdimond'] * 50;
|
|
} else if ($get_invoices['packdimond'] >= 50) {
|
|
$total_pp += $get_invoices['packdimond'] * 60;
|
|
}
|
|
}
|
|
echo $total_pp;
|
|
?>
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
$ccc += $get_invoices['ccc'];
|
|
$pack460 += $get_invoices['pack460'];
|
|
$pack575 += $get_invoices['pack575'];
|
|
$packsilver += $get_invoices['packsilver'];
|
|
$packgold += $get_invoices['packgold'];
|
|
$packdimond += $get_invoices['packdimond'];
|
|
$total_ppuu += $total_pp;
|
|
}
|
|
?>
|
|
<tr>
|
|
<td>المجموع</td>
|
|
<td><?=$ccc?></td>
|
|
<td><?=$pack460?></td>
|
|
<td><?=$pack575?></td>
|
|
<td><?=$packsilver?></td>
|
|
<td><?=$packgold?></td>
|
|
<td><?=$packdimond?></td>
|
|
<td><?=$total_ppuu?></td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
<button type="button" id="export_button" class="btn btn-success btn-sm">ملف excel</button>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<!-- Container-fluid Ends-->
|
|
</div>
|
|
<?php require_once('fixed/footer/go.php'); ?>
|
|
</div>
|
|
</div>
|
|
<div id="get_data"></div>
|
|
<?php require_once('fixed/js/go.php'); ?>
|
|
<script type="text/javascript" src="https://unpkg.com/xlsx@0.15.1/dist/xlsx.full.min.js"></script>
|
|
<script>
|
|
$("#Select-date").change(function() {
|
|
var SelectedDate = $(this).val();
|
|
window.location = 'w_user_bonds?b=<?=$branch_id?>&date=' + SelectedDate
|
|
});
|
|
function html_table_to_excel(type)
|
|
{
|
|
var data = document.getElementById('employee_data');
|
|
var file = XLSX.utils.table_to_book(data, {sheet: "sheet1"});
|
|
XLSX.write(file, { bookType: type, bookSST: true, type: 'base64' });
|
|
XLSX.writeFile(file, 'ايراد الفرع.' + type);
|
|
}
|
|
const export_button = document.getElementById('export_button');
|
|
export_button.addEventListener('click', () => {
|
|
html_table_to_excel('xlsx');
|
|
});
|
|
</script>
|
|
|
|
<?php require_once('fixed/waiting_ajax/go.php'); ?>
|
|
</body>
|
|
</html>
|