35 lines
1.4 KiB
PHP
35 lines
1.4 KiB
PHP
<?php
|
|
require_once('.hta_config/crm_config.php');
|
|
require_once('.htac_header.php');
|
|
require_once('.htac_nav.php');
|
|
?>
|
|
<div class="flex flex-row place-content-between py-2" style="border-bottom: 2px solid #A0A2AB; border-style: dashed;">
|
|
<p class="text-[25px] font-bold">Followup</p>
|
|
</div>
|
|
<?php
|
|
$conn = new PDO("mysql:host=$mariaServer;dbname=$mariaDb", $mariaUser, $mariaPass);
|
|
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
|
$stmt = $conn->prepare("SELECT date, user, id, name FROM cleads WHERE date IS NOT NULL AND date >= CURRENT_DATE AND user = :user");
|
|
$stmt->bindParam(':user', $_SESSION['email']);
|
|
$stmt->execute();
|
|
$users_rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|
$row_count = count($users_rows);
|
|
if($row_count > 0){
|
|
foreach($users_rows as $users_data){
|
|
?>
|
|
<div class="flex flex-col space-y-2 gap-2 mb-2 ">
|
|
<a href="<?php echo '/edit-lead/?id='.$users_data['id']?>" class="flex flex-col w-full p-2 rounded-md shadow" style="border: 3px solid #F5F4FFE8;">
|
|
<p>🕑 New Followup for <?php echo $users_data['name']; ?></p>
|
|
<p><?php echo $users_data['date']; ?></p>
|
|
</a>
|
|
</div>
|
|
<?php
|
|
|
|
// echo '<p>'.$users_data['id'] . $users_data['user'] . $users_data['date'].'<br> </p>';
|
|
|
|
}
|
|
} else{
|
|
echo '<p>No Followup Found</p>';
|
|
}
|
|
?>
|