File: /home/barbeatleanalyti/public_html/baris.beatleanalytics.com/ajax/events.php
<?php
// Include common files.
//error_reporting(0);
include_once("../site/include/config_ajax.php");
include_once(INCLUDE_PATH."/dbClass.php");
$objDB = new MySQLCN();
include_once(INCLUDE_PATH."/functions.php");
include_once(INCLUDE_PATH."/storeconfig.php");
$storeconfig = new storeconfig();
include_once(TEMPLATE_PATH."/common_include.php");
// Create a new object for MySQLCN
define("_IMAGEPATH_",SERVERROOT_IMAGE."theme/".SITE_THEME."/images");
// Check if data is variable is exists or not into query string or post data.
if(isset($_REQUEST['data'])){
//echo "<pre>";
// Decode into base64.
$data = urldecode(base64_decode($_REQUEST['data']));
// Convert string to array of a data.
$DataExplode = explode("&",$data);
// print_r($DataExplode);
foreach($DataExplode as $key=>$val){
for($i=0; $i<count($DataExplode); $i++ ){
$DataExpSub = explode("=",$DataExplode[$i]);
if(preg_match('/acn=/',$DataExplode[$i])){
$acn = $DataExpSub[1];
}else if(preg_match('/pg=/',$DataExplode[$i])){
$pg = $DataExpSub[1];
}else if(preg_match('/val1/',$DataExplode[$i])){
$val1 = $DataExpSub[1];
}else if(preg_match('/ProductName=/',$DataExplode[$i])){
$ProductName = $DataExpSub[1];
}else if(preg_match('/EventID=/',$DataExplode[$i])){
$EventID = $DataExpSub[1];
}else if(preg_match('/IsParentID=/',$DataExplode[$i])){
$IsParentID = $DataExpSub[1];
}else if(preg_match('/ParentID_=/',$DataExplode[$i])){
$ParentID = $DataExpSub[1];
}else if(preg_match('/Snooze=/',$DataExplode[$i])){
$Snooze = $DataExpSub[1];
}
else if(preg_match('/v=/',$DataExplode[$i])){
$v = $DataExpSub[1];
}
}
}
define("ECAL_BACKGROUND_COLOR_APP","#f39c12");
define("ECAL_BORDER_COLOR_APP","#f39c12");
define("ECAL_BACKGROUND_COLOR_MEE","#00a65a");
define("ECAL_BORDER_COLOR_MEE","#00a65a");
define("ECAL_BACKGROUND_COLOR_MEE_CANCEL","#cccccc");
define("ECAL_BORDER_COLOR_MEE_CANCEL","#cccccc");
// echo $ProjectID;
// echo $acn.">>";
// echo "</pre>";
// die;
if($acn == "FetchAllEvnetsDetails")
{
$SQL = "SELECT GROUP_CONCAT(UserID) AS EmailIds FROM `email_config` WHERE EmployeeID = '".$_SESSION['UserInfo']['UserID']."' AND LOWER(EmployeeType) = '".strtolower(FetchEmployeeType())."' ";
$rsEmailIds = $objDB->sql_query($SQL);
//echo "<pre>";
$rsEmailArr = explode(",",$rsEmailIds[0]['EmailIds']);
$rsEmailIds = str_replace(",","','",$rsEmailIds[0]['EmailIds']);
//print_r($rsEmailArr);
//die;
//echo $SQL;
$rsEvents = $objDB->sql_query($SQL);
$objDB = $objDB->ConnectNewDatabase(DB_USERNAME_ADMIN, DB_PASS_ADMIN, DB_SERVER_ADMIN, DB_DATABASE_ADMIN);
//
$SQL = "SELECT * FROM `events` WHERE DomainName = '".SUBDOMAIN_NAME."' AND EmailID IN('".$rsEmailIds."')";
$rsEvents = $objDB->sql_query($SQL);
$returnArr = array();
$eventArr = array();
for($i=0; $i<count($rsEvents); $i++){
if($rsEvents[$i]['ParentID'] == 0 && in_array($rsEvents[$i]['EmailID'],$rsEmailArr) && !in_array($rsEvents[$i]['EventID'],$eventArr) ) {
$newArr['title'] = $rsEvents[$i]['Subject'];
$newArr['start'] = $rsEvents[$i]['StartDateTime'];
$newArr['end'] = $rsEvents[$i]['EndDateTime'];
if($rsEvents[$i]['EmailService'] == 'appointment'){
$newArr['backgroundColor'] = ECAL_BACKGROUND_COLOR_APP; //yellow
$newArr['borderColor'] = ECAL_BORDER_COLOR_APP;
$newArr['url'] = "EventID=".$rsEvents[$i]['EventID']."&IsParentID=Y&ParentID_=".$rsEvents[$i]['ParentID'];
//$newArr['eventid'] = $rsEvents[$i]['EventID'];
$eventArr[] = $rsEvents[$i]['EventID'];
}else{
if($rsEvents[$i]['CancledByAdmin'] == 'Y'){
$newArr['backgroundColor'] = ECAL_BACKGROUND_COLOR_MEE_CANCEL; //yellow
$newArr['borderColor'] = ECAL_BORDER_COLOR_MEE_CANCEL;
}else {
$newArr['backgroundColor'] = ECAL_BACKGROUND_COLOR_MEE; //yellow
$newArr['borderColor'] = ECAL_BORDER_COLOR_MEE;
}
$newArr['url'] = "EventID=".$rsEvents[$i]['EventID']."&IsParentID=Y&ParentID_=".$rsEvents[$i]['ParentID'];
//$newArr['eventid'] = $rsEvents[$i]['EventID'];
$eventArr[] = $rsEvents[$i]['EventID'];
}
$returnArr[] = $newArr;
}else if(in_array($rsEvents[$i]['EmailID'],$rsEmailArr) && !in_array($rsEvents[$i]['ParentID'],$eventArr) ){
$newArr['title'] = $rsEvents[$i]['Subject'];
$newArr['start'] = $rsEvents[$i]['StartDateTime'];
$newArr['end'] = $rsEvents[$i]['EndDateTime'];
if($rsEvents[$i]['EmailService'] == 'appointment'){
$newArr['backgroundColor'] = ECAL_BACKGROUND_COLOR_APP; //yellow
$newArr['borderColor'] = ECAL_BORDER_COLOR_APP;
$newArr['url'] = "EventID=".$rsEvents[$i]['EventID']."&IsParentID=N&ParentID_=".$rsEvents[$i]['ParentID'];
$eventArr[] = $rsEvents[$i]['ParentID'];
}else{
if($rsEvents[$i]['CancledByAdmin'] == 'Y'){
$newArr['backgroundColor'] = ECAL_BACKGROUND_COLOR_MEE_CANCEL; //yellow
$newArr['borderColor'] = ECAL_BORDER_COLOR_MEE_CANCEL;
}else {
$newArr['backgroundColor'] = ECAL_BACKGROUND_COLOR_MEE; //yellow
$newArr['borderColor'] = ECAL_BORDER_COLOR_MEE;
}
$newArr['url'] = "EventID=".$rsEvents[$i]['EventID']."&IsParentID=N&ParentID_=".$rsEvents[$i]['ParentID'];
$eventArr[] = $rsEvents[$i]['ParentID'];
}
$returnArr[] = $newArr;
}
}
echo json_encode($returnArr);
exit;
}
else if($acn == "FetchAllEvnetsFromIDs")
{
//echo "<pre>";
// Fetcho employee's email ids
$SQL = "SELECT GROUP_CONCAT(UserID) AS EmailIds FROM `email_config` WHERE EmployeeID = '".$_SESSION['UserInfo']['UserID']."' AND LOWER(EmployeeType) = '".strtolower(FetchEmployeeType())."' ";
$rsEmailIds = $objDB->sql_query($SQL);
$rsEmailArr = explode(",",$rsEmailIds[0]['EmailIds']);
//Close current database connection and connect with main admin database.
$objDB = $objDB->ConnectNewDatabase(DB_USERNAME_ADMIN, DB_PASS_ADMIN, DB_SERVER_ADMIN, DB_DATABASE_ADMIN);
$SQL = "SELECT * FROM `events` WHERE EventID = '".$EventID."'";
$rsEvents = $objDB->sql_query($SQL);
//echo $SQL;
//echo "<pre><br />";
//print_r($rsEvents);
$textColor = '';
if($rsEvents[0]['EndDateTime'] <= date("Y-m-d H:i:s")){
$textColor .= 'color:#999 !important';
}
//die;
$html = '<div class="modal-content box" style="'.$textColor.'" >
<div class="modal-header text-center bg-yellow">
<button onclick="javascript: $(\'#popupEventList\').fadeOut();" type="button" class="close" data-dismiss="modal" aria-label="Close">
<span onclick="javascript: $(\'#popupEventList\').fadeOut();" aria-hidden="true">×</span></button>
<h4 class="modal-title text-bold">Appointments / Meeting Details</h4>
</div>
<div class="modal-body">
<div class="row">
<div class="col-md-12 col-xs-12 form-group no-padding">
<div class="col-md-2 text-sm-left text-xl-right">
<label class="control-label form-group">Type :</label>
</div>
<div class="col-md-10 " id="EmailServiceDispaly">'.strtoupper($rsEvents[0]['EmailService']).'</div>
</div>
</div>
<div id="toVal" class="row" style="display:none;">
<div class="col-md-12 col-xs-12 form-group no-padding">
<div class="col-md-2 text-sm-left text-xl-right">
<label class="control-label form-group">To :</label>
</div>
<div class="col-md-10 ">
<div class="form-group">
<input class="form-control" onkeypress="javascript: return AddRecepiant(event,event,\'From\');" name="From" id="From" value="" placeholder="To :">
<input type="hidden" name="RecepiantFrom" id="RecepiantFrom" value=\'\' />
<span id="RecepiantFromVal" class="select2 select2-container select2-container--default select2-container--below select2-container--focus" dir="ltr" style="width: 100%; border:none !important; "><span class="selection"><span aria-expanded="false" aria-haspopup="true" id="select-From" role="combobox" class="select2-selection select2-selection--multiple" tabindex="-1">
<ul class="select2-selection__rendered"></ul>
</span></span><span aria-hidden="true" class="dropdown-wrapper"></span></span>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12 col-xs-12 form-group no-padding">
<div class="col-md-2 text-sm-left text-xl-right">
<label class="control-label form-group">Subject:</label>
</div>
<div class="col-md-10 ">'.$rsEvents[0]['Subject'].'
</div>
</div>
</div>
<div class="row">
<div class="col-md-12 col-xs-12 form-group no-padding">
<div class="col-md-2 text-sm-left text-xl-right">
<label class="control-label form-group">Location:</label>
</div>
<div class="col-md-10 ">'.$rsEvents[0]['Location'].'
</div>
</div>
</div>
<div class="row">
<div class="col-md-12 col-xs-12 form-group no-padding">
<div class="input-group col-md-12 text-sm-left text-xl-right">
<div class="col-md-2 text-sm-left text-xl-right">
<label class="control-label form-group">Time :</label>
</div>
<div class="col-md-8 text-left text-bold">'.date("d/m/Y H:i",strtotime($rsEvents[0]['StartDateTime']))." To ".date("d/m/Y H:i",strtotime($rsEvents[0]['EndDateTime'])).'</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12 form-group col-sm-12 col-xs-12 no-padding">
<label class="col-md-2 text-sm-left text-xl-right text-md-right">Description:</label>
<div class="col-md-10">'.$rsEvents[0]['Description'].'</div>
</div>
</div>';
if(strtoupper($rsEvents[0]['EmailService']) == 'MEETING') {
$html .= '<div class="row text-bold ">
<div class="col-md-12 form-group col-sm-12 col-xs-12 no-padding">
<label class="col-md-2 text-sm-left text-xl-right text-md-right">Attendee</label>
<div class="col-md-4 text-sm-left text-xl-left text-md-right">Email ID </a></div>
<div class="col-md-1 text-sm-left text-xl-right text-md-right">Status</div>
</div>
</div>';
if((int)$ParentID == 0){
$SQL_ = "SELECT * FROM `events` WHERE ParentID = '".$EventID."' ";
$rsAttendee = $objDB->sql_query($SQL_);
}
else if ((int)$ParentID != 0){
$SQL_ = "SELECT * FROM `events` WHERE ParentID = '".$ParentID."' ";
$rsAttendee = $objDB->sql_query($SQL_);
}
for($atn=0; $atn<count($rsAttendee); $atn++){
$txtBoldCls = '';
$btnStatus = '';
if($rsAttendee[$atn]['ParentID'] == 0)
$str_event = "EventID=".$EventID."&IsParentID=Y&ParentID_=".$rsAttendee[$atn]['ParentID'];
else
$str_event = "EventID=".$EventID."&IsParentID=N&ParentID_=".$rsAttendee[$atn]['ParentID'];
if(in_array($rsAttendee[$atn]['EmailID'],$rsEmailArr)){
$txtBoldCls = 'text-bold';
if($rsAttendee[$atn]['Status'] == 'PROCESS'){
$str = SERVER_ROOT."filter.html?data=".base64_encode("ssn=".session_id()."&acn=AppointmentResponse&v=edit&ids=".md5($eventID)."&email=".$rsAttendee[$atn]['EmailID']."&response=accept&".$str_event);
$btnStatus = '<a class="pad form-group" target="_blank" href="'.$str.'"><img alt=" Accept " src="'._IMAGEPATH_.'/meeting-accept.png" /></a>';
$str = SERVER_ROOT."filter.html?data=".base64_encode("ssn=".session_id()."&acn=AppointmentResponse&v=edit&ids=".md5($eventID)."&email=".$rsAttendee[$atn]['EmailID']."&response=maybe&".$str_event);
$btnStatus .= '<a class="pad form-group" target="_blank" href="'.$str.'"><img alt=" May Be " src="'._IMAGEPATH_.'/meeting-maybe.png" /></a>';
$str = SERVER_ROOT."filter.html?data=".base64_encode("ssn=".session_id()."&acn=AppointmentResponse&v=edit&ids=".md5($eventID)."&email=".$rsAttendee[$atn]['EmailID']."&response=decline&".$str_event);
$btnStatus .= '<a class="pad form-group" target="_blank" href="'.$str.'"><img alt=" Decline " src="'._IMAGEPATH_.'/meeting-decline.png" /></a>';
}
else if(strtoupper($rsAttendee[$atn]['Status']) == 'CONFIRMED'){
$btnStatus = '<img alt=" Accept " src="'._IMAGEPATH_.'/meeting-accept.png" />';
}
else if(strtoupper($rsAttendee[$atn]['Status']) == 'TENTATIVE'){
$btnStatus = '<img alt=" May Be " src="'._IMAGEPATH_.'/meeting-maybe.png" />';
}
else if(strtoupper($rsAttendee[$atn]['Status']) == 'CANCELLED'){
$btnStatus = '<img alt=" Decline " src="'._IMAGEPATH_.'/meeting-decline.png" />';
//$btnStatus = '';
}
}else{
if(strtoupper($rsAttendee[$atn]['Status']) == 'PROCESS'){
$btnStatus = 'PENDING';
}
else if(strtoupper($rsAttendee[$atn]['Status']) == 'CONFIRMED'){
$btnStatus = '<img alt=" Accept " src="'._IMAGEPATH_.'/meeting-accept.png" />';
}
else if(strtoupper($rsAttendee[$atn]['Status']) == 'TENTATIVE'){
$btnStatus = '<img alt=" May Be " src="'._IMAGEPATH_.'/meeting-maybe.png" />';
}
else if(strtoupper($rsAttendee[$atn]['Status']) == 'CANCELLED'){
$btnStatus = '<img alt=" Decline " src="'._IMAGEPATH_.'/meeting-decline.png" />';
}
}
$html .= '<div class="row '.$txtBoldCls.'">
<div class="col-md-12 form-group col-sm-12 col-xs-12 no-padding">
<label class="col-md-2 text-sm-left text-xl-left text-md-left"> </label>';
$html .= '<div class="col-md-4 text-sm-left text-xl-left text-md-left"><a style="cursor:pointer;" haref="mailto:'.$rsAttendee[$atn]['EmailID'].'">'.$rsAttendee[$atn]['EmailID'].'</a></div>
<div class="col-md-6 pull-left">'.$btnStatus.'</div>';
$html .= '</div> </div>';
}
//}
}
if((int)$ParentID != 0){
/*
//echo "<pre>";
$SQL_ = "SELECT * FROM `events` WHERE ParentID = '".$ParentID."' ";
//echo $SQL_;
$rsAttendee = $objDB->sql_query($SQL_);
//print_r($rsAttendee);
for($atn=0; $atn<count($rsAttendee); $atn++){
$txtBoldCls = '';
$btnStatus = '';
if(in_array($rsAttendee[$atn]['EmailID'],$rsEmailArr)){
$txtBoldCls = 'text-bold';
if($rsAttendee[$atn]['Status'] == 'PROCESS'){
$str = SERVER_ROOT."filter.html?data=".base64_encode("ssn=".session_id()."&acn=AppointmentResponse&v=edit&ids=".md5($eventID)."&email=".$rsAttendee[$atn]['EmailID']."&response=accept");
$btnStatus = '<a class="pad form-group" target="_blank" href="'.$str.'"><img alt=" Accept " src="'._IMAGEPATH_.'/meeting-accept.png" /></a>';
$str = SERVER_ROOT."filter.html?data=".base64_encode("ssn=".session_id()."&acn=AppointmentResponse&v=edit&ids=".md5($eventID)."&email=".$rsAttendee[$atn]['EmailID']."&response=maybe");
$btnStatus .= '<a class="pad form-group" target="_blank" href="'.$str.'"><img alt=" May Be " src="'._IMAGEPATH_.'/meeting-maybe.png" /></a>';
$str = SERVER_ROOT."filter.html?data=".base64_encode("ssn=".session_id()."&acn=AppointmentResponse&v=edit&ids=".md5($eventID)."&email=".$rsAttendee[$atn]['EmailID']."&response=decline");
$btnStatus .= '<a class="pad form-group" target="_blank" href="'.$str.'"><img alt=" Decline " src="'._IMAGEPATH_.'/meeting-decline.png" /></a>';
}
else if(strtoupper($rsAttendee[$atn]['Status']) == 'CONFIRMED'){
$btnStatus = '<img alt=" Accept " src="'._IMAGEPATH_.'/meeting-accept.png" />';
}
else if(strtoupper($rsAttendee[$atn]['Status']) == 'TENTATIVE'){
$btnStatus = '<img alt=" May Be " src="'._IMAGEPATH_.'/meeting-maybe.png" />';
}
else if(strtoupper($rsAttendee[$atn]['Status']) == 'CANCELLED'){
$btnStatus = '<img alt=" Decline " src="'._IMAGEPATH_.'/meeting-decline.png" />';
}
}
else{
//$html .= $rsAttendee[$atn]['Status']." ###";
if(strtoupper($rsAttendee[$atn]['Status']) == 'PROCESS'){
$btnStatus = 'PENDING';
}
else if(strtoupper($rsAttendee[$atn]['Status']) == 'CONFIRMED'){
$btnStatus = '<img alt=" Accept " src="'._IMAGEPATH_.'/meeting-accept.png" />';
}
else if(strtoupper($rsAttendee[$atn]['Status']) == 'TENTATIVE'){
$btnStatus = '<img alt=" May Be " src="'._IMAGEPATH_.'/meeting-maybe.png" />';
}
else if(strtoupper($rsAttendee[$atn]['Status']) == 'CANCELLED'){
$btnStatus = '<img alt=" Decline " src="'._IMAGEPATH_.'/meeting-decline.png" />';
}
}
$html .= '<div class="row '.$txtBoldCls.'">
<div class="col-md-12 form-group col-sm-12 col-xs-12 no-padding">
<label class="col-md-2 text-sm-left text-xl-right text-md-right">';
if($atn == 0) {
$html .= 'Attendee : ';
}
$html .= '</label>';
$html .= '<div class="col-md-4 text-sm-left text-xl-left text-md-right"><a style="cursor:pointer;" haref="mailto:'.$rsAttendee[$atn]['EmailID'].'">'.$rsAttendee[$atn]['EmailID'].'</a></div>
<div class="col-md-6">'.$btnStatus.'</div>';
$html .= '</div> </div>';
}
*/
}
$html .= '</div>
<div class="modal-footer">
<button onclick="javascript: $(\'#popupEventList\').fadeOut();" href="#close" title="Close" type="button" class="btn btn-default pull-left" data-dismiss="modal"> <i aria-hidden="true" class="fa fa-close"></i> Close</button>';
if(in_array($rsEvents[0]["EmailID"],$rsEmailArr) && $rsEvents[0]["ParentID"] == 0){
if($rsEvents[0]["CancledByAdmin"] == 'N' && $rsEvents[0]['EndDateTime'] >= date("Y-m-d H:i:s") ) {
$html .= '<button onclick="javascript: return CancelEvents(\''.$rsEvents[0]["EmailID"].'\',\''.$EventID.'\');" href="#close" title="Close" type="button" class="btn btn-danger pull-left" data-dismiss="modal"> <i aria-hidden="true" class="fa fa-times"></i> Cancel</button>';
}
$html .= '<button onclick="javascript: return DeleteEvents(\''.$rsEvents[0]["EmailID"].'\',\''.$EventID.'\');" href="#close" title="Close" type="button" class="btn btn-danger pull-left" data-dismiss="modal"> <i aria-hidden="true" class="fa fa-trash"></i> Delete</button>';
}
$html .= '</div>
</div>';
$returnArr[0] = $html;
echo json_encode($returnArr);
exit;
}
else if($acn == "FetchECalnotification"){
global $objDB;
$SQL = "SELECT GROUP_CONCAT(UserID) AS EmailIds FROM `email_config` WHERE EmployeeID = '".$_SESSION['UserInfo']['UserID']."' AND LOWER(EmployeeType) = '".strtolower(FetchEmployeeType())."' ";
$rsEmailIds = $objDB->sql_query($SQL);
//echo "<pre>";
$rsEmailArr = explode(",",$rsEmailIds[0]['EmailIds']);
$rsEmailIds = str_replace(",","','",$rsEmailIds[0]['EmailIds']);
$objDB = $objDB->ConnectNewDatabase(DB_USERNAME_ADMIN, DB_PASS_ADMIN, DB_SERVER_ADMIN, DB_DATABASE_ADMIN);
$nextSnooze = date("Y-m-d H:i:s");
$SQL = "SELECT EventID, Subject, StartDateTime, EndDateTime FROM `events` WHERE DomainName = '".SUBDOMAIN_NAME."' AND EmailID IN('".$rsEmailIds."') AND IsViewed = 'N' AND CancledByAdmin = 'N' AND Status != 'CANCELLED' AND PopupTime <= '".$nextSnooze."' AND IsReCall = 'Y' AND IsDismissed != 'Y' ";
$rsEvents = $objDB->sql_query($SQL);
//echo "<pre>";
//print_r($rsEvents);
//die;
/* $returnArr = array();
$eventArr = array();
for($i=0; $i<count($rsEvents); $i++){
if($rsEvents[$i]['ParentID'] == 0 && in_array($rsEvents[$i]['EmailID'],$rsEmailArr) && !in_array($rsEvents[$i]['EventID'],$eventArr) ) {
$newArr['title'] = $rsEvents[$i]['Subject'];
$newArr['start'] = $rsEvents[$i]['StartDateTime'];
$newArr['end'] = $rsEvents[$i]['EndDateTime'];
if($rsEvents[$i]['EmailService'] == 'appointment'){
$newArr['backgroundColor'] = ECAL_BACKGROUND_COLOR_APP; //yellow
$newArr['borderColor'] = ECAL_BORDER_COLOR_APP;
$newArr['url'] = "EventID=".$rsEvents[$i]['EventID']."&IsParentID=Y&ParentID_=".$rsEvents[$i]['ParentID'];
//$newArr['eventid'] = $rsEvents[$i]['EventID'];
$eventArr[] = $rsEvents[$i]['EventID'];
}else{
if($rsEvents[$i]['CancledByAdmin'] == 'Y'){
$newArr['backgroundColor'] = ECAL_BACKGROUND_COLOR_MEE_CANCEL; //yellow
$newArr['borderColor'] = ECAL_BORDER_COLOR_MEE_CANCEL;
}else {
$newArr['backgroundColor'] = ECAL_BACKGROUND_COLOR_MEE; //yellow
$newArr['borderColor'] = ECAL_BORDER_COLOR_MEE;
}
$newArr['url'] = "EventID=".$rsEvents[$i]['EventID']."&IsParentID=Y&ParentID_=".$rsEvents[$i]['ParentID'];
//$newArr['eventid'] = $rsEvents[$i]['EventID'];
$eventArr[] = $rsEvents[$i]['EventID'];
}
$returnArr[] = $newArr;
}else if(in_array($rsEvents[$i]['EmailID'],$rsEmailArr) && !in_array($rsEvents[$i]['ParentID'],$eventArr) ){
$newArr['title'] = $rsEvents[$i]['Subject'];
$newArr['start'] = $rsEvents[$i]['StartDateTime'];
$newArr['end'] = $rsEvents[$i]['EndDateTime'];
if($rsEvents[$i]['EmailService'] == 'appointment'){
$newArr['backgroundColor'] = ECAL_BACKGROUND_COLOR_APP; //yellow
$newArr['borderColor'] = ECAL_BORDER_COLOR_APP;
$newArr['url'] = "EventID=".$rsEvents[$i]['EventID']."&IsParentID=N&ParentID_=".$rsEvents[$i]['ParentID'];
$eventArr[] = $rsEvents[$i]['ParentID'];
}else{
if($rsEvents[$i]['CancledByAdmin'] == 'Y'){
$newArr['backgroundColor'] = ECAL_BACKGROUND_COLOR_MEE_CANCEL; //yellow
$newArr['borderColor'] = ECAL_BORDER_COLOR_MEE_CANCEL;
}else {
$newArr['backgroundColor'] = ECAL_BACKGROUND_COLOR_MEE; //yellow
$newArr['borderColor'] = ECAL_BORDER_COLOR_MEE;
}
$newArr['url'] = "EventID=".$rsEvents[$i]['EventID']."&IsParentID=N&ParentID_=".$rsEvents[$i]['ParentID'];
$eventArr[] = $rsEvents[$i]['ParentID'];
}
$returnArr[] = $newArr;
}
}
*/
$html = '<div class="row"><div class="col-md-12"><!--<audio style="display:none;" autoplay="" controls="controls"><source src="http://www.soundjay.com/misc/bell-ringing-05.mp3" type="audio/mpeg"></source></audio> --><img width="25" src="theme/black/images/Clock.gif" />';
$eventIDArr = array();
for($i=0; $i<count($rsEvents); $i++){
if($i == 0)
$html .= '<strong> MEETING/APPOINTMENT NOTIFICATION </strong><br /> ';
$html .= '<div class="col-md-12 no-paddin" style="border-bottom:1px solid #00a65a;">';
$html .= '<strong>'.$rsEvents[$i]['Subject'].'</strong><br>'.date("d/m/Y H:i",strtotime($rsEvents[$i]['StartDateTime']));
$html .= '<div class="no-padding pull-right"><input type="button" class="btn btn-success btn-xs" value="DissmissX"> </div><br /><br />
'; $html .= '</div>';
//if($i != count($rsEvents)-1)
//$html .= '<hr class="no-margin form-group" style="border: 1px solid #0D911E" />';
$eventIDArr[] = $rsEvents[$i]['EventID'];
}
if(count($rsEvents) > 0){
$html .= '<div class="col-md-12 no-padding form-group"><br><br>
<div class="col-md-5 no-padding form-group">
<select id="Snooze" name="Snooze" onchange="" class="form-control no-padding input-sm">
<option value="15#M">15 Minuts</option>
<option value="30#M">30 Minuts</option>
<option value="45#M">45 Minuts</option>
<option value="01#H">01 Hour</option>
<option value="05#H">05 Hour</option>
</select>
</div>
<div class="col-md-1 no-padding form-group"><label class="checkbox"></label></div>
<div class="col-md-3 no-padding form-group"><label class="checkbox">Snooze</label></div>
<input type="hidden" name="evntidstringlist" id="evntidstringlist" value="'.implode(",",$eventIDArr).'" >
</div>';
}
$html .= '</div> </div>';
$eventArr = array();
$eventArr[0] = $html;
$eventArr[1] = count($rsEvents);
echo json_encode($eventArr);
exit;
}
else if($acn == 'DismissedAllEvnets'){
$objDB = $objDB->ConnectNewDatabase(DB_USERNAME_ADMIN, DB_PASS_ADMIN, DB_SERVER_ADMIN, DB_DATABASE_ADMIN);
//$SQL = "SELECT EventID FROM `events` WHERE EventID IN (".$EventID.") ";
//$rsEvnets = $objDB->sql_query($SQL);
$SQL = "UPDATE `events` SET IsDismissed = 'Y', IsReCall = 'N' WHERE EventID IN (".$EventID.") ";
$rsEvnets = $objDB->sql_query($SQL);
}else if($acn == 'SetSnoozeOnEvents'){
$snoozeArr = explode("#",$Snooze);
$min = $snoozeArr[0];
$time = strtolower($snoozeArr[1]);
if($time == 'm')
$time = 'minute';
else if($time == 'h')
$time = 'hour';
//$nextSnooze = date("Y-m-d H:i:s",strtotime("+{$min} {$time}"));
//$nextSnooze = date("Y-m-d H:i:s",strtotime("+2 minute"));
$nextSnooze = date("Y-m-d H:i:s");
$objDB = $objDB->ConnectNewDatabase(DB_USERNAME_ADMIN, DB_PASS_ADMIN, DB_SERVER_ADMIN, DB_DATABASE_ADMIN);
$SQL = "UPDATE `events` SET PopupTime = '".$nextSnooze."' WHERE EventID IN (".$EventID.") ";
$rsEvnets = $objDB->sql_query($SQL);
}
}