File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/report/bg_fetch_data.php
Back
<?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'])); } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0.05 |
proxy
|
phpinfo
|
Settings