/**
* function to get the detailed forcasting data
* @param string $where
* @param integer $iduser
* @return void
*/
public function get_detailed_forecast_data($where = '', $iduser = 0)
{
$do_potentials = new Potentials();
$do_potentials->get_list_query();
if ($where == '') {
$user_where = $this->get_report_where($iduser, 'potentials', 'pot_to_grp_rel');
}
$date_where = '';
$start_date = TimeZoneUtil::get_user_timezone_date();
$date_obj = new DateTime($start_date);
$add_89 = $date_obj->modify('+89 day');
$end_date = $add_89->format('Y-m-d');
$date_where = " and `potentials`.`expected_closing_date` >= '{$start_date}' \n\t\tand `potentials`.`expected_closing_date` <= '{$end_date}' \n\t\t";
$qry = $do_potentials->getSqlQuery();
$qry .= $user_where . $date_where . " order by `potentials`.`expected_closing_date`";
$this->query($qry);
}
/**
* event function to add an entity to queue
* @param object $evctl
* @return string
*/
public function eventAjaxAddQueue(EventControler $evctl)
{
if (trim($evctl->date) != '' && (int) $evctl->related_module_id > 0 && (int) $evctl->related_record_id > 0) {
$user_timezone = $_SESSION['do_user']->user_timezone;
$date = FieldType9::convert_before_save($evctl->date);
$today = TimeZoneUtil::get_user_timezone_date($user_timezone);
$todayDateObj = new DateTime($today);
$queueDateObj = new DateTime($date);
$diff = $todayDateObj->diff($queueDateObj);
$day_diff = $diff->format('%R%a');
if ($day_diff < 0) {
echo _('Older date for queue is not allowed !');
} else {
$this->addNew();
$this->sqcrm_record_id = (int) $evctl->related_record_id;
$this->related_module_id = (int) $evctl->related_module_id;
$this->iduser = $_SESSION['do_user']->iduser;
$this->queue_date = $date;
$this->add();
echo '1';
}
} else {
echo _('Missing module id , date or record id to be added in queue !');
}
}
if (isset($_GET["related_to"]) && isset($_GET["related_to_module"])) {
$related_to_id = (int) $_GET["related_to"];
$related_to_module_id = (int) $_GET["related_to_module"];
$module_info = $_SESSION["do_module"]->get_modules_with_full_info();
$related_module_name = $module_info[$related_to_module_id]["name"];
$cancel_return = NavigationControl::getNavigationLink($related_module_name, "detail", $related_to_id);
if ($_SESSION["do_crm_action_permission"]->action_permitted('view', $related_to_module_id, $related_to_id) === true) {
$add_from_related = true;
} else {
$show_add_page = false;
}
} else {
$cancel_return = NavigationControl::getNavigationLink($module, "list");
}
// set event start/end date time
$start_end_date = TimeZoneUtil::get_user_timezone_date();
$start_time = TimeZoneUtil::get_user_timezone_time();
$end_time = date("H:i:s", strtotime("+1 hour", strtotime($start_time)));
//Recurrent event info
$recurrent_events = new RecurrentEvents();
$text_options = $recurrent_events->get_text_options();
$days_in_week = $recurrent_events->get_days_in_week();
if ($show_add_page === true) {
require_once 'view/calendar_add_view.php';
} else {
echo '<div class="alert alert-danger" style="height:100px;margin-top:100px;margin-left:200px;margin-right:200px;">';
echo '<h4>';
echo _('Access Denied ! ');
echo '</h4>';
echo _('You are not authorized to perform this operation.');
echo '</div>';
<?php
// Copyright SQCRM. For licensing, reuse, modification and distribution see license.txt
/**
* Home page call and events
* @author Abhik Chakraborty
*/
?>
<link rel="stylesheet" href="/themes/custom-css/eventcal/eventCalendar.css">
<link rel="stylesheet" href="/themes/custom-css/eventcal/eventCalendar_theme_responsive.css">
<?php
include_once(BASE_PATH.'/widgets/CallsAndEvents/CallsAndEvents.class.php') ;
$current_date = TimeZoneUtil::get_user_timezone_date();
$current_date_exploded = explode("-",$current_date);
$current_year = $current_date_exploded[0];
$current_month = $current_date_exploded[1];
if (isset($_REQUEST["y"]) && isset($_REQUEST["m"])) {
$year = (int)$_REQUEST["y"];
$month = (int)$_REQUEST["m"];
if (isset($_REQUEST["c"])) {
$change_type = $_REQUEST["c"] ;
if ($change_type == 'p') {
$ym = date("Y-m-d",strtotime("- 1 month",strtotime($year.'-'.$month.'-01')));
} elseif ($change_type == 'n') {
$ym = date("Y-m-d",strtotime("+ 1 month",strtotime($year.'-'.$month.'-01')));
}
$year = date("Y",strtotime($ym));
$month = date("m",strtotime($ym));
}
} else {