ac7467f0b4
- Added comprehensive AI Assistant system (aiassist/ directory): * Vector search and embedding capabilities * Typebot proxy integration * Elastic search functionality * Message classification and chat history * MCP proxy for external integrations - Implemented Court Status API (GetCourtStatus.php): * Real-time court document status checking * Integration with external court systems * Comprehensive error handling and logging - Enhanced S3 integration: * Improved file backup system with metadata * Batch processing capabilities * Enhanced error logging and recovery * Copy operations with URL fixing - Added Telegram contact creation API - Improved error logging across all modules - Enhanced callback system for AI responses - Extensive backup file storage with timestamps - Updated documentation and README files - File storage improvements: * Thousands of backup files with proper metadata * Fix operations for broken file references * Project-specific backup and recovery systems * Comprehensive file integrity checking Total: 26,461+ files added/modified including AWS SDK, vendor dependencies, and extensive backup system.
164 lines
9.2 KiB
PHP
164 lines
9.2 KiB
PHP
<?php
|
|
/*********************************************************************************
|
|
** The contents of this file are subject to the vtiger CRM Public License Version 1.0
|
|
* ("License"); You may not use this file except in compliance with the License
|
|
* The Original Code is: vtiger CRM Open Source
|
|
* The Initial Developer of the Original Code is vtiger.
|
|
* Portions created by vtiger are Copyright (C) vtiger.
|
|
* All Rights Reserved.
|
|
********************************************************************************/
|
|
ini_set("include_path", "../");
|
|
|
|
require('send_mail.php');
|
|
require_once('config.php');
|
|
require_once('include/utils/utils.php');
|
|
|
|
// Email Setup
|
|
global $adb;
|
|
$emailresult = $adb->pquery("SELECT email1 from vtiger_users", array());
|
|
$emailid = $adb->fetch_array($emailresult);
|
|
$emailaddress = $emailid[0];
|
|
// SalesPlatform.ru begin
|
|
$mailserveresult = $adb->pquery("SELECT server,server_username,server_password,smtp_auth,server_port,server_tls,use_sendmail FROM vtiger_systems where server_type = ?", array('email'));
|
|
//$mailserveresult = $adb->pquery("SELECT server,server_username,server_password,smtp_auth FROM vtiger_systems where server_type = ?", array('email'));
|
|
// SalesPlatform.ru end
|
|
$mailrow = $adb->fetch_array($mailserveresult);
|
|
$mailserver = $mailrow[0];
|
|
$mailuname = $mailrow[1];
|
|
$mailpwd = Vtiger_Functions::fromProtectedText($mailrow[2]);
|
|
$smtp_auth = $mailrow[3];
|
|
// SalesPlatform.ru begin
|
|
$mailserver_port = $mailrow[4];
|
|
$mailserver_tls = $mailrow[5];
|
|
$use_sendmail = $mailrow[6];
|
|
// SalesPlatform.ru end
|
|
// End Email Setup
|
|
|
|
|
|
//query the vtiger_notificationscheduler vtiger_table and get data for those notifications which are active
|
|
$sql = "select active from vtiger_notificationscheduler where schedulednotificationid=1";
|
|
$result = $adb->pquery($sql, array());
|
|
|
|
$activevalue = $adb->fetch_array($result);
|
|
|
|
if($activevalue[0] == 1)
|
|
{
|
|
//Delayed Tasks Notification
|
|
|
|
//get all those activities where the status is not completed even after the passing of 24 hours
|
|
$today = date("Ymd");
|
|
$result = $adb->pquery("select vtiger_activity.status,vtiger_activity.activityid,subject,(vtiger_activity.date_start +1),vtiger_crmentity.smownerid from vtiger_activity inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_activity.activityid where vtiger_crmentity.deleted=0 and vtiger_activity.status <> 'Completed' and activitytype='Task' and ? > (vtiger_activity.date_start+1)", array($today));
|
|
|
|
while ($myrow = $adb->fetch_array($result))
|
|
{
|
|
$status=$myrow[0];
|
|
$subject = (strlen($myrow[2]) > 30)?substr($myrow[2],0,27).'...':$myrow[2];
|
|
$user_id = $myrow[4];
|
|
if($user_id != '')
|
|
{
|
|
$user_res = $adb->pquery('select user_name from vtiger_users where id=?',array($user_id));
|
|
$assigned_user = $adb->query_result($user_res,0,'user_name');
|
|
}
|
|
$mail_body = getTranslatedString('Dear_Admin_tasks_not_been_completed')." ".getTranslatedString('LBL_SUBJECT').": ".$subject."<br> ".getTranslatedString('LBL_ASSIGNED_TO').": ".$assigned_user."<br><br>".getTranslatedString('Task_sign');
|
|
// SalesPlatform.ru begin
|
|
sendmail($emailaddress,$emailaddress,getTranslatedString('Task_Not_completed').': '.$subject,$mail_body,$mailserver,$mailuname,$mailpwd,"",$smtp_auth,$mailserver_port,$mailserver_tls,$use_sendmail);
|
|
//sendmail($emailaddress,$emailaddress,getTranslatedString('Task_Not_completed').': '.$subject,$mail_body,$mailserver,$mailuname,$mailpwd,"",$smtp_auth);
|
|
// SalesPlatform.ru end
|
|
}
|
|
}
|
|
|
|
//Big Deal Alert
|
|
$sql = "select active from vtiger_notificationscheduler where schedulednotificationid=2";
|
|
$result = $adb->pquery($sql, array());
|
|
|
|
$activevalue = $adb->fetch_array($result);
|
|
if($activevalue[0] == 1)
|
|
{
|
|
$result = $adb->pquery("SELECT sales_stage,amount,potentialid,potentialname FROM vtiger_potential inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_potential.potentialid where vtiger_crmentity.deleted=0 and sales_stage='Closed Won' and amount > 10000",array());
|
|
while ($myrow = $adb->fetch_array($result))
|
|
{
|
|
$pot_id = $myrow['potentialid'];
|
|
$pot_name = $myrow['potentialname'];
|
|
$body_content = getTranslatedString('Dear_Team').getTranslatedString('Dear_Team_Time_to_Party')."<br><br>".getTranslatedString('Potential_Id')." ".$pot_id;
|
|
$body_content .= getTranslatedString('Potential_Name')." ".$pot_name."<br><br>";
|
|
// SalesPlatform.ru begin
|
|
sendmail($emailaddress,$emailaddress,getTranslatedString('Big_Deal_Closed_Successfully'),$body_content,$mailserver,$mailuname,$mailpwd,"",$smtp_auth,$mailserver_port,$mailserver_tls,$use_sendmail);
|
|
//sendmail($emailaddress,$emailaddress,getTranslatedString('Big_Deal_Closed_Successfully'),$body_content,$mailserver,$mailuname,$mailpwd,"",$smtp_auth);
|
|
// SalesPlatform.ru end
|
|
}
|
|
}
|
|
//Pending tickets
|
|
$sql = "select active from vtiger_notificationscheduler where schedulednotificationid=3";
|
|
$result = $adb->pquery($sql, array());
|
|
|
|
$activevalue = $adb->fetch_array($result);
|
|
if($activevalue[0] == 1)
|
|
{
|
|
$result = $adb->pquery("SELECT vtiger_troubletickets.status,ticketid FROM vtiger_troubletickets INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_troubletickets.ticketid WHERE vtiger_crmentity.deleted='0' AND vtiger_troubletickets.status <> 'Completed' AND vtiger_troubletickets.status <> 'Closed'", array());
|
|
|
|
while ($myrow = $adb->fetch_array($result))
|
|
{
|
|
$ticketid = $myrow['ticketid'];
|
|
// SalesPlatform.ru begin
|
|
sendmail($emailaddress,$emailaddress,getTranslatedString('Pending_Ticket_notification'),getTranslatedString('Kind_Attention').$ticketid .getTranslatedString('Thank_You_HelpDesk'),$mailserver,$mailuname,$mailpwd,"",$smtp_auth,$mailserver_port,$mailserver_tls);
|
|
//sendmail($emailaddress,$emailaddress,getTranslatedString('Pending_Ticket_notification'),getTranslatedString('Kind_Attention').$ticketid .getTranslatedString('Thank_You_HelpDesk'),$mailserver,$mailuname,$mailpwd,"",$smtp_auth);
|
|
// SalesPlatform.ru end
|
|
}
|
|
}
|
|
|
|
//Too many tickets related to a particular vtiger_account/company causing concern
|
|
$sql = "select active from vtiger_notificationscheduler where schedulednotificationid=4";
|
|
$result = $adb->pquery($sql, array());
|
|
|
|
$activevalue = $adb->fetch_array($result);
|
|
if($activevalue[0] == 1)
|
|
{
|
|
$result = $adb->pquery("SELECT count(*) as count FROM vtiger_troubletickets INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_troubletickets.ticketid WHERE vtiger_crmentity.deleted='0' AND vtiger_troubletickets.status <> 'Completed' AND vtiger_troubletickets.status <> 'Closed'", array());
|
|
$count = $adb->query_result($result,0,'count');
|
|
//changes made to get too many tickets notification only when tickets count is greater than or equal to 5
|
|
if($count >= 5)
|
|
{
|
|
// SalesPlatform.ru begin
|
|
sendmail($emailaddress,$emailaddress,getTranslatedString('Too_many_pending_tickets'),getTranslatedString('Dear_Admin_too_ many_tickets_pending'),$mailserver,$mailuname,$mailpwd,"",$smtp_auth,$mailserver_port,$mailserver_tls,$use_sendmail);
|
|
//sendmail($emailaddress,$emailaddress,getTranslatedString('Too_many_pending_tickets'),getTranslatedString('Dear_Admin_too_ many_tickets_pending'),$mailserver,$mailuname,$mailpwd,"",$smtp_auth);
|
|
// SalesPlatform.ru end
|
|
}
|
|
}
|
|
|
|
//Support Starting
|
|
$sql = "select active from vtiger_notificationscheduler where schedulednotificationid=5";
|
|
$result = $adb->pquery($sql, array());
|
|
|
|
$activevalue = $adb->fetch_array($result);
|
|
if($activevalue[0] == 1)
|
|
{
|
|
$result = $adb->pquery("SELECT vtiger_products.productname FROM vtiger_products inner join vtiger_crmentity on vtiger_products.productid = vtiger_crmentity.crmid where vtiger_crmentity.deleted=0 and start_date like ?", array(date('Y-m-d'). "%"));
|
|
while ($myrow = $adb->fetch_array($result))
|
|
{
|
|
$productname=$myrow[0];
|
|
// SalesPlatform.ru begin
|
|
sendmail($emailaddress,$emailaddress,getTranslatedString('Support_starting'),getTranslatedString('Hello_Support').$productname ."\n ".getTranslatedString('Congratulations'),$mailserver,$mailuname,$mailpwd,"",$smtp_auth,$mailserver_port,$mailserver_tls,$use_sendmail);
|
|
//sendmail($emailaddress,$emailaddress,getTranslatedString('Support_starting'),getTranslatedString('Hello_Support').$productname ."\n ".getTranslatedString('Congratulations'),$mailserver,$mailuname,$mailpwd,"",$smtp_auth);
|
|
// SalesPlatform.ru end
|
|
}
|
|
}
|
|
|
|
//Support ending
|
|
$sql = "select active from vtiger_notificationscheduler where schedulednotificationid=6";
|
|
$result = $adb->pquery($sql, array());
|
|
|
|
$activevalue = $adb->fetch_array($result);
|
|
if($activevalue[0] == 1)
|
|
{
|
|
$result = $adb->pquery("SELECT vtiger_products.productname from vtiger_products inner join vtiger_crmentity on vtiger_products.productid = vtiger_crmentity.crmid where vtiger_crmentity.deleted=0 and expiry_date like ?", array(date('Y-m-d') ."%"));
|
|
while ($myrow = $adb->fetch_array($result))
|
|
{
|
|
$productname=$myrow[0];
|
|
// SalesPlatform.ru begin
|
|
sendmail($emailaddress,$emailaddress,getTranslatedString('Support_Ending_Subject'),getTranslatedString('Support_Ending_Content').$productname.getTranslatedString('kindly_renew'),$mailserver,$mailuname,$mailpwd,"",$smtp_auth,$mailserver_port,$mailserver_tls,$use_sendmail);
|
|
//sendmail($emailaddress,$emailaddress,getTranslatedString('Support_Ending_Subject'),getTranslatedString('Support_Ending_Content').$productname.getTranslatedString('kindly_renew'),$mailserver,$mailuname,$mailpwd,"",$smtp_auth);
|
|
// SalesPlatform.ru end
|
|
}
|
|
}
|
|
|
|
?>
|