<?php
    ini_set('max_execution_time', '0'); 
    set_time_limit(0);
    //same code above
    ini_set('memory_limit','-1');
    date_default_timezone_set('Asia/Manila');
    include('cfg/db.php');
    include_once("api/controllers/utility.php");

    if(!isset($_SESSION['user']['id'])){
        header('location: home.php');
        return;
    }

    $utility = new Utility();
    $year = "";

    if(isset($_REQUEST['year'])){
        $year = $db->escape($_REQUEST['year']);
    }

    $query = "SELECT concat(tbbr.first_name, ' ', tbbr.last_name) AS name, tbbr.mobile_number, sc.code AS company, tbbr.company_id AS company_id, sd.name AS dealer, DATE_FORMAT(tbbr.date, '%M %d, %Y') AS date, tbbr.status 
        FROM text_blast_birthday_record tbbr
        INNER JOIN customer_dms cdms 
        ON tbbr.customer_id = cdms.customer_record_id 
        INNER JOIN source_company_dealer scd 
        ON cdms.company_dealer_id = scd.id 
        INNER JOIN source_company sc 
        ON scd.company_id = sc.id 
        INNER JOIN source_dealer sd 
        ON scd.dealer_id = sd.id 
        WHERE DATE_FORMAT(tbbr.date, '%Y') = '$year'";

    $fetch_query = $db->sql_query($query);
    $company_fetched = array();

    foreach($fetch_query AS $row){
        $get_company = $row['company_id'];
        if(!in_array($get_company, $company_fetched)){
            $company_fetched = array_merge($company_fetched, array($row['company_id']));
        }
    }
?>