File manager - Edit - /home/autoph/public_html/connectv1/app/finance/dashboard/company_count.php
Back
<?php header('Content-Type: application/json'); include_once("../../../cfg/db.php"); include_once("../../../api/controllers/utility.php"); $utility = new Utility(); $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ; $company = ""; $dealer = ""; if(isset($_POST['company']) && $_POST['company'] != 0){ $company = $db->escape($_POST['company']); $company = " AND f.company_id = $company "; } else { $company = " AND f.company_id IN(" . $granted_company_ids . ") "; } if(isset($_POST['dealer']) && $_POST['dealer'] != 0){ $dealer = $db->escape($_POST['dealer']); $dealer = " AND f.dealer_id = $dealer "; } // $start_date = isset($_REQUEST['startDate']) ? $db->escape($_REQUEST['startDate']) : '' ; // $end_date = isset($_REQUEST['endDate']) ? $db->escape($_REQUEST['endDate']) : '' ; // $company = isset($_REQUEST['company']) ? $db->escape($_REQUEST['company']) : '0' ; // $company_filter = (intval($company) === 0) ? $granted_company_ids : $company ; // $date_filter = ($start_date !== '' && $end_date !== '') ? " AND ci.date_uploaded BETWEEN DATE_FORMAT('$start_date', '%Y-%m-%d 00:00:00') AND DATE_FORMAT('$end_date', '%Y-%m-%d 23:59:00') " : '' ; $dms_count_query = "SELECT id, code, ( (SELECT COUNT(1) FROM ( SELECT f.company_id FROM finance f INNER JOIN source_company sc ON f.company_id = sc.id WHERE f.status = 1 ".$company.$dealer." /* GROUP BY f.plate_cs_number1, f.plate_cs_number2 */ ) AS t2 WHERE t2.company_id = source_company.id ) ) AS total FROM `source_company` WHERE status = 1 AND (SELECT COUNT(1) FROM ( SELECT f.company_id FROM finance f INNER JOIN source_company sc ON f.company_id = sc.id WHERE f.status = 1 ".$company.$dealer." GROUP BY f.plate_cs_number1, f.plate_cs_number2 ) AS t2 WHERE t2.company_id = source_company.id ) > 0 AND id IN (" . $granted_company_ids . ")"; $dms_count = $db->return_result($dms_count_query); $data = array(); foreach($dms_count AS $row){ $data[] = $row; } echo json_encode($data); ?>
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0 |
proxy
|
phpinfo
|
Settings