File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/misc/get_dms_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.email) as email, SUM(t1.address) as address, SUM(t1.gender) as gender, SUM(t1.date_of_birth) as date_of_birth FROM (SELECT sc.dms_id, IF(cc.email_1 = '',1,0) AS email, IF(cc.address_1 = '',1,0) AS address, IF(c.gender_id = 0 AND c.type = 1,1,0 ) AS gender, IF(c.date_of_birth = '',1,0) AS date_of_birth 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)); $inc_email = 0; $inc_address = 0; $inc_gender = 0; $inc_date_of_birth = 0; foreach($query_overall_results as $result){ $inc_email = $result['email'] == null ? 0 : $result['email']; $inc_address = $result['address'] == null ? 0 : $result['address']; $inc_gender= $result['gender'] == null ? 0 : $result['gender']; $inc_date_of_birth = $result['date_of_birth'] == null ? 0 : $result['date_of_birth']; } $return_arr["email"] = $inc_email; $return_arr["address"] = $inc_address; $return_arr["gender"] =$inc_gender; $return_arr["date_of_birth"] = $inc_date_of_birth; echo json_encode($return_arr); exit; // $query_individual = "SELECT // (SELECT COUNT(id) FROM customer WHERE date_of_birth = '' AND type = 1 GROUP BY id) as date_of_birth , // (SELECT COUNT(id) FROM customer WHERE gender_id = '0' AND type = 1 GROUP BY id) as gender, // (SELECT COUNT(id) FROM customer_contact WHERE mobile_phone_1 = '' GROUP BY id) as mobile, // (SELECT COUNT(id) FROM customer_contact WHERE email_1 = '' GROUP BY id) as email, // (SELECT COUNT(id) FROM customer_contact WHERE address_1 = '' GROUP BY id) as address // FROM `customer` // 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 scd.company_id IN (".$granted_company_ids.") // LIMIT 1"; // echo $query_individual;exit; $return_arr['mobile'] = 0; $return_arr['email'] = $db->select("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_contact.email_1 = '' AND scd.company_id IN (".$company_filter.") $date_filter GROUP BY customer.id) as t1"); $return_arr['address'] = $db->select("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_contact.address_1 = '' AND scd.company_id IN (".$company_filter.") $date_filter GROUP BY customer.id) as t1 "); $return_arr['gender'] = $db->select("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.gender_id = 0 AND customer.type = 1 AND scd.company_id IN (".$company_filter.") $date_filter GROUP BY customer.id) as t1"); $return_arr['date_of_birth'] =$db->select("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 scd.company_id IN (".$company_filter.") $date_filter GROUP BY customer.id) as t1"); // $incomplete_data_individual = $db -> return_result($query_individual); // foreach($incomplete_data_individual as $data){ // $return_arr['mobile'] = $return_arr['mobile'] + $data['mobile']; // $return_arr['email'] = $return_arr['email'] + $data['email']; // $return_arr['address'] = $return_arr['address'] + $data['address']; // $return_arr['gender'] = $return_arr['gender'] + $data['gender']; // $return_arr['date_of_birth'] = $return_arr['date_of_birth'] + $data['date_of_birth']; // } // $incomplete_data_corporation = $db -> return_result($query_corporation); // foreach($incomplete_data_corporation as $data){ // $return_arr['mobile'] = $return_arr['mobile'] + $data['mobile']; // $return_arr['email'] = $return_arr['email'] + $data['email']; // $return_arr['address'] = $return_arr['address'] + $data['address']; // } echo json_encode($return_arr); ?>

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