Employee Dealer Mapping

query($sql); ?> Employee Dealer Mapping

Send Report to Employees Send Report to Dealers

$mobile, 'recipient_type' => 'individual', 'type' => 'template', 'template' => [ 'language' => [ 'policy' => 'deterministic', 'code' => 'en' ], 'name' => 'concord_gmp_account_statement', 'components' => [ [ 'type' => 'body', 'parameters' => [ [ 'type' => 'text', 'text' => $name ], [ 'type' => 'text', 'text' => 'Google My Business (GMB) Report' ] ] ], [ 'type' => 'button', 'sub_type' => 'url', 'index' => 0, 'parameters' => [ [ 'type' => 'text', 'text' => 'https://rpt.kajariaceramics.com/dealer_dashboard.php?source2=OTcxNzc5NTA0OA%3D%3D' ] ] ] ] ] ]; $curl = curl_init(); curl_setopt_array($curl, [ CURLOPT_URL => 'https://wa-crm.concordtechnosoft.com/api/meta/v19.0/282894604900917/messages', CURLOPT_RETURNTRANSFER => true, CURLOPT_TIMEOUT => 30, CURLOPT_POST => true, CURLOPT_POSTFIELDS => json_encode($payload), CURLOPT_HTTPHEADER => [ 'Content-Type: application/json', 'Authorization: Bearer s513y3UNQnJVcXJvAZCCpfAuewkgQId3wJqH1d2uuNlRmqEHmICOHapxVU5ERVJTQ09SRQzdvKKm7ivfs2kMI5XiO6pD2JSCnKy0C6J015WGMgxiQfQqGSqv1REFTSAy7yoGq5qxNwvVUHLOTp1NVijNn2D9TBuVBoKsPxHmjE8No6yeTfHfWRqk2FpZNrq4KQbHw6jEFDX3p2pWZoxNfOR2ZnVU5ERVJTQ09SRQVU5ERVJTQ09SRQNu42Ax' ] ]); $response = curl_exec($curl); $error = curl_error($curl); curl_close($curl); echo '

'; if ($error) { echo 'Error:
'; echo htmlspecialchars($error); } else { echo 'Response:
'; echo '

';
        echo htmlspecialchars($response);
        echo '

'; echo '

'; echo ''; echo 'Open Report URL'; echo ''; } echo '

'; } /* ------------------------------------------------- SEND TO EMPLOYEES ------------------------------------------------- */ if ($action == 'send_employees') { set_time_limit(0); $logDir = __DIR__ . '/sendlog'; if (!is_dir($logDir)) { mkdir($logDir, 0777, true); } $timestamp = date('Ymd_His'); $csvFilename = "employee_send_{$timestamp}.csv"; $logFilename = "employee_send_{$timestamp}.log"; $csvPath = $logDir . '/' . $csvFilename; $logPath = $logDir . '/' . $logFilename; $csv = fopen($csvPath, 'w'); fputcsv($csv, [ 'Emp Code', 'Name', 'Mobile', 'URL', 'Status', 'Response' ]); file_put_contents( $logPath, "Started : " . date('Y-m-d H:i:s') . PHP_EOL ); $countSql = " SELECT COUNT(*) total FROM dealer_connected_employees "; $total = (int)$conn ->query($countSql) ->fetch_assoc()['total']; $sql = " SELECT emp_code, name, mobile1 FROM dealer_connected_employees ORDER BY name "; $res = $conn->query($sql); echo '

'; echo 'Processing...
'; echo 'Total Employees : ' . $total; echo '

'; flush(); $processed = 0; while ($row = $res->fetch_assoc()) { $processed++; $empCode = trim($row['emp_code']); $name = trim($row['name']); $mobile = preg_replace( '/\D/', '', $row['mobile1'] ); $encodedEmpCode = enc($empCode); $reportUrl = 'https://rpt.kajariaceramics.com/dealer_dashboard.php?source1=' . $encodedEmpCode; $status = 'Pending'; $response = ''; if (strlen($mobile) != 10) { $status = 'Invalid Mobile'; } else { $mobile = '91' . $mobile; // $mobile = '919582439353'; $payload = [ 'to' => $mobile, 'recipient_type' => 'individual', 'type' => 'template', 'template' => [ 'language' => [ 'policy' => 'deterministic', 'code' => 'en' ], 'name' => 'concord_gmp_account_statement', 'components' => [ [ 'type' => 'body', 'parameters' => [ [ 'type' => 'text', 'text' => $name ], [ 'type' => 'text', 'text' => 'Google My Business (GMB) Report' ] ] ], [ 'type' => 'button', 'sub_type' => 'url', 'index' => 0, 'parameters' => [ [ 'type' => 'text', 'text' => $reportUrl ] ] ] ] ] ]; $curl = curl_init(); curl_setopt_array( $curl, [ CURLOPT_URL => 'https://wa-crm.concordtechnosoft.com/api/meta/v19.0/282894604900917/messages', CURLOPT_RETURNTRANSFER => true, CURLOPT_TIMEOUT => 30, CURLOPT_POST => true, CURLOPT_POSTFIELDS => json_encode($payload), CURLOPT_HTTPHEADER => [ 'Content-Type: application/json', 'Authorization: Bearer s513y3UNQnJVcXJvAZCCpfAuewkgQId3wJqH1d2uuNlRmqEHmICOHapxVU5ERVJTQ09SRQzdvKKm7ivfs2kMI5XiO6pD2JSCnKy0C6J015WGMgxiQfQqGSqv1REFTSAy7yoGq5qxNwvVUHLOTp1NVijNn2D9TBuVBoKsPxHmjE8No6yeTfHfWRqk2FpZNrq4KQbHw6jEFDX3p2pWZoxNfOR2ZnVU5ERVJTQ09SRQVU5ERVJTQ09SRQNu42Ax' ] ] ); $response = curl_exec($curl); $error = curl_error($curl); curl_close($curl); if ($error) { $status = 'Failed'; $response = $error; } else { $status = 'Sent'; } //sleep(1); } fputcsv($csv, [ $empCode, $name, $mobile, $reportUrl, $status, $response ]); file_put_contents( $logPath, date('Y-m-d H:i:s') . " | " . $empCode . " | " . $name . " | " . $status . PHP_EOL, FILE_APPEND ); if ($processed % 10 == 0) { $percent = round( ($processed / $total) * 100 ); echo "

"; echo $processed . " / " . $total . " processed (" . $percent . "%)"; echo "

"; flush(); } } fclose($csv); file_put_contents( $logPath, PHP_EOL . "Completed : " . date('Y-m-d H:i:s'), FILE_APPEND ); echo '

'; echo '

Completed

'; echo 'Download CSV'; echo 'Download Log'; echo '

'; } /* ------------------------------------------------- SEND TO DEALERS ------------------------------------------------- */ if ($action == 'send_dealers') { echo '

Dealer sending section will be added later.

'; } ?>

Employee Dealer Mapping

Employee hierarchy and connected dealer website IDs

All Records num_rows > 0) { while ($row = $res->fetch_assoc()) { ?>

Emp Code	Name	Mobile	Level	Role	Reporting Code	Reporting Name	Reporting Mobile	Sales Office	Total Dealers	Connected Website IDs