File manager - Edit - /home/custbahd/cornerstoneassetmanagers.com/admin/counter/get-notes/index.php
Back
<?php session_start(); include_once "../db/config.php"; include_once('../db/count_db.php'); // Generating a random number date_default_timezone_set('Africa/Kampala'); $today = date("His-dmY",time()); $today_day = date("D",time()); $today_date = date("d",time()); $tomorrow_date = date("d",time())+1; $this_week = date("W",time()); $next_week = date("W",time())+1; $last_week = date("W",time())-1; $today_month = date("M",time()); $next_month = date("M", strtotime($today_month . "+1 months")); $next_month_date = date("m",time())+1; $this_month = date("m",time()); $last_month = date("m",time())-1; $last_month_one = date("M", strtotime($today_month . "-1 month")); $today_year = date("Y",time()); $last_year = date("Y",time())-1; $sql = "SELECT * FROM clients WHERE dob!='0000-00-00' ORDER BY MONTH(dob) ASC"; $result = $conn->query($sql); while($row = mysqli_fetch_array($result)) { } $sql = "SELECT * FROM clients WHERE dob!='0000-00-00' AND MONTH(dob) >= '$this_month' ORDER BY MONTH(dob) ASC"; $result = $conn->query($sql); while($row = mysqli_fetch_array($result)) { date_default_timezone_set('Africa/Kampala'); $dob = date("Y-m-d", strtotime($row['dob'])); $dob_day = date("d", strtotime($row['dob'])); $dob_week = date("W", strtotime($row['dob'])); $dob_month = date("m", strtotime($row['dob'])); $today = date("Y-m-d",time()); $dob_count = $dob_month-$this_month; $dob_day_count = $dob_day-$today_date; $dob_week_count = $dob_week-$this_week; if ($dob_count<=0) { $dob_count_one = 'Passed'; $dob_style = 'text-warning'; } elseif ($dob_count==1) { $dob_count_one = 'Next month'; $dob_style = 'text-success'; } elseif ($dob_count==0) { if ($dob_day==$tomorrow_date) { $dob_count_one = 'Tomorrow'; $dob_style = 'text-success'; }elseif ($dob_day==$today_date) { $dob_count_one = 'Today'; $dob_style = 'text-success'; } elseif ($dob_day>$today_date & $dob_week>$this_week) { $dob_count_one = 'This month'; $dob_style = 'text-success'; } elseif ($dob_day>$today_date & $dob_week==$this_week & $dob_day_count>5) { $dob_count_one = 'This week'; $dob_style = 'text-success'; } elseif ($dob_day>$today_date & $dob_week==$this_week & $dob_day_count<5) { $dob_count_one = ''.$dob_day_count.' days'; $dob_style = 'text-success'; } } elseif ($dob_count==0 & $dob_day<$today_date) { $dob_count_one = 'Passed'; $dob_style = 'text-warning'; } elseif ($dob_count>1) { $dob_count_one = 'In '.$dob_count.' months'; $dob_style = 'text-success'; } echo '<li>'; echo '<div class="d-flex bd-highlight">'; echo '<div class="user_info">'; echo '<span class="fs-12">'.$row["fname"].' '.$row["lname"].'</span>'; echo '<p class="fs-11">'.date("jS M", strtotime($row['dob'])).' <i class="fs-10 '.$dob_style.'">('.$dob_count_one.')</i></p>'; echo '</div>'; echo '<div class="ml-auto">'; echo '<a href="clients/birthdays/client/?id='.$row["id"].'" class="btn btn-primary btn-xs sharp mr-1"><i class="fa fa-angle-right"></i></a>'; echo '</div>'; echo '</div>'; echo '</li>'; } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Generation time: 2.3 |
proxy
|
phpinfo
|
Settings