File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/misc/get_dms_complete_incomplete.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' ; $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 c.date_uploaded BETWEEN DATE_FORMAT('$start_date', '%Y-%m-%d 00:00:00') AND DATE_FORMAT('$end_date', '%Y-%m-%d 23:59:00') " : '' ; $company_filter_format = " AND sc.id IN (".$company_filter.") "; $return_arr = array(); $query_overall = "SELECT SUM(t1.complete) as complete, SUM(t1.incomplete) as incomplete FROM (SELECT sc.dms_id, IF((((c.date_of_birth <> '' and c.gender_id <> 0 and cc.address_1 <> '' and cc.email_1 <> '' and cc.mobile_phone_1 <> '') AND c.type = 1) OR ((cc.address_1 <> '' and cc.email_1 <> '') AND c.type = 2)), 1, 0) AS complete, IF((((c.date_of_birth = '' or c.gender_id = 0 or cc.address_1 = '' or cc.email_1 = '') AND c.type = 1) OR ((cc.address_1 = '' OR cc.email_1 = '') AND c.type = 2)) , 1, 0) AS incomplete FROM `customer` c INNER JOIN customer_contact cc ON c.id = cc.customer_id INNER JOIN customer_dms cd ON c.id = cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id = scd.id INNER JOIN source_company sc ON scd.company_id = sc.id WHERE 1 AND c.status = 1 %s %s GROUP BY c.id) as t1"; $query_overall_results = $db -> sql_query(sprintf($query_overall,$company_filter_format,$date_filter)); $complete = 0; $incomplete = 0; foreach($query_overall_results as $result){ $incomplete = $result['incomplete'] == null ? 0 : $result['incomplete'] ; $complete = $result['complete'] == null ? 0 : $result['complete']; } $return_arr["incomplete"] = $incomplete; $return_arr["complete"] = $complete; echo json_encode($return_arr); exit; $dms_individual_incomplete_data_query = "SELECT COUNT(1) FROM (SELECT 1 as count FROM customer INNER JOIN customer_contact ON customer.id = customer_contact.customer_id INNER JOIN customer_dms cd ON customer.id = cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id = scd.id WHERE (((customer.date_of_birth = '' or customer.gender_id = 0 or customer_contact.address_1 = '' or customer_contact.email_1 = '') AND customer.type = 1) OR ((customer_contact.address_1 = '' OR customer_contact.email_1 = '') AND customer.type = 2)) AND scd.company_id IN (".$company_filter.") $date_filter GROUP BY customer.id) as t1 "; // echo $dms_individual_incomplete_data_query;exit; $dms_individual_incomplete_data = $db -> select($dms_individual_incomplete_data_query); $return_arr["incomplete"]= ($dms_individual_incomplete_data); $dms_individual_complete_data_query = "SELECT COUNT(1) FROM (SELECT 1 as count FROM customer INNER JOIN customer_contact ON customer.id = customer_contact.customer_id INNER JOIN customer_dms cd ON customer.id = cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id = scd.id WHERE (((customer.date_of_birth <> '' and customer.gender_id <> 0 and customer_contact.address_1 <> '' and customer_contact.email_1 <> '' and customer_contact.mobile_phone_1 <> '') AND customer.type = 1) OR ((customer_contact.address_1 <> '' and customer_contact.email_1 <> '') AND customer.type = 2)) AND scd.company_id IN (".$company_filter.") $date_filter GROUP BY customer.id) as t1 "; $dms_individual_complete_data = $db -> select($dms_individual_complete_data_query); $return_arr["complete"]= ($dms_individual_complete_data); echo json_encode($return_arr); ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings