$query = "select vtiger_crmentity.crmid,vtiger_seactivityrel.crmid as setype,vtiger_activity.*,vtiger_activity_reminder.reminder_time,vtiger_activity_reminder.reminder_sent,vtiger_activity_reminder.recurringid,vtiger_recurringevents.recurringdate from vtiger_activity inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_activity.activityid inner join vtiger_activity_reminder on vtiger_activity.activityid=vtiger_activity_reminder.activity_id left outer join vtiger_recurringevents on vtiger_activity.activityid=vtiger_recurringevents.activityid left outer join vtiger_seactivityrel on vtiger_seactivityrel.activityid = vtiger_activity.activityid where DATE_FORMAT(vtiger_activity.date_start,'%Y-%m-%d, %H:%i:%s') >= '" . date('Y-m-d') . "' and vtiger_crmentity.crmid != 0 and vtiger_activity.eventstatus = 'Planned' and vtiger_activity_reminder.reminder_sent = 0 group by vtiger_activity.activityid,vtiger_recurringevents.recurringid";
$result = $adb->pquery($query, array());
if ($adb->num_rows($result) >= 1) {
while ($result_set = $adb->fetch_array($result)) {
$date_start = $result_set['date_start'];
$time_start = $result_set['time_start'];
$reminder_time = $result_set['reminder_time'];
$date = new DateTimeField(null);
$curr_time = strtotime($date->getDisplayDateTimeValue()) / 60;
$activity_id = $result_set['activityid'];
$activitymode = $result_set['activitytype'] == "Task" ? "Task" : "Events";
$parent_type = $result_set['setype'];
$activity_sub = $result_set['subject'];
$to_addr = '';
if ($parent_type != '') {
$parent_content = getParentInfo($parent_type) . "\n";
} else {
$parent_content = "";
}
//code included for recurring events by jaguar starts
$recur_id = $result_set['recurringid'];
$current_date = date('Y-m-d');
if ($recur_id == 0) {
$date_start = $result_set['date_start'];
} else {
$date_start = $result_set['recurringdate'];
}
//code included for recurring events by jaguar ends
$date = new DateTimeField("{$date_start} {$time_start}");
$activity_time = strtotime($date->getDisplayDateTimeValue()) / 60;
if ($activity_time - $curr_time > 0 && $activity_time - $curr_time <= $reminder_time) {
} else {
$result = array();
}
return $result;
}
}
// Set Up the Database Connection
$databaseConnection = new mysqli(MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_DBNAME);
if ($databaseConnection->connect_errno != 0) {
SendSingleError(HTTP_INTERNAL_ERROR, $databaseConnection->connect_error, ERRTXT_DBCONN_FAILED);
}
$databaseConnection->set_charset(MYSQL_CHARSET);
// Put data in variables
$category_id = isset($_GET['category_id']) ? $_GET['category_id'] : false;
if ($category_id === false) {
SendSingleError(HTTP_BAD_REQUEST, "one or more fields not found", ERRTXT_UNSETVARIABLE);
} else {
$result = array();
$parentID = $category_id;
while ($parentID != NULL) {
$categoryInfo = getParentInfo($databaseConnection, $parentID);
$justIDAndName = array("category_id" => $categoryInfo["category_id"], "name" => $categoryInfo["name"]);
array_unshift($result, $justIDAndName);
$parentID = $categoryInfo["parent"];
}
header(HTTP_OK);
header(API_RESPONSE_CONTENT);
echo json_encode($result);
exit;
}
SendSingleError(HTTP_INTERNAL_ERROR, 'php failed', ERRTXT_FAILED);
