<?php

$db = mysqli_connect("localhost", "root", "root", "fullerton");


$records = $db->query("SELECT GROUP_CONCAT(id) as ids,MAX(id) as last_id,lan,COUNT(lan) as count FROM records_bk GROUP BY lan HAVING COUNT(lan) > 1");

$lan = array();
$recordProcess = 0;
$recordDelete = 0;

if ($records->num_rows > 0) {
	while($record = $records->fetch_assoc()){
		// print_r($record);
		if(in_array($record['lan'], $lan)){

			$updateCC = $db->query("UPDATE crmcalls SET crm_id = ".$record['last_id']." WHERE lan = ".$record['lan']." AND crm_id IN (".$record['ids'].") AND crm_id NOT IN (".$record['last_id'].")");
			
			$updateCCA = $db->query("UPDATE crmcalls_archive SET crm_id = ".$record['last_id']." WHERE lan = ".$record['lan']." AND crm_id IN (".$record['ids'].") AND crm_id NOT IN (".$record['last_id'].")");

			$deleteR = $db->query("DELETE FROM records_bk WHERE lan = ".$record['lan']." AND id IN (".$record['ids'].") AND id NOT IN (".$record['last_id'].")");

			$recordDelete++;
		}else{
			array_push($lan, $record['lan']);
		}
		$recordProcess++;
	}
}

echo "Total $recordProcess records process and $recordDelete Deuplicate records clean";

exit();