function save_module($module)
{
$adb = PearDatabase::getInstance();
//Handling module specific save
$recordId = $this->id;
$recur_type = '';
if (($recur_type == "--None--" || $recur_type == '') && $this->mode == "edit") {
$sql = 'delete from vtiger_recurringevents where activityid=?';
$adb->pquery($sql, array($this->id));
}
//Handling for recurring type
//Insert into vtiger_recurring event table
if (isset($this->column_fields['recurringtype']) && $this->column_fields['recurringtype'] != '' && $this->column_fields['recurringtype'] != '--None--') {
$recur_type = trim($this->column_fields['recurringtype']);
$recur_data = getrecurringObjValue();
if (is_object($recur_data)) {
$this->insertIntoRecurringTable($recur_data);
}
}
//Insert into vtiger_activity_remainder table
$this->insertIntoReminderTable('vtiger_activity_reminder', $module, "");
//Handling for invitees
$selected_users_string = $_REQUEST['inviteesid'];
$invitees_array = explode(';', $selected_users_string);
$this->insertIntoInviteeTable($module, $invitees_array);
//Inserting into sales man activity rel
$this->insertIntoSmActivityRel($module);
$adb->pquery('UPDATE vtiger_activity SET smownerid = ? WHERE `activityid` = ?;', array($this->column_fields['assigned_user_id'], $recordId));
$this->insertIntoActivityReminderPopup($module);
}
function save_module($module)
{
global $adb;
$insertion_mode = $this->mode;
//Handling module specific save
//Insert into seactivity rel
if (isset($this->column_fields['parent_id']) && $this->column_fields['parent_id'] != '') {
$this->insertIntoEntityTable("vtiger_seactivityrel", $module);
} elseif ($this->column_fields['parent_id'] == '' && $insertion_mode == "edit") {
$this->deleteRelation("vtiger_seactivityrel");
}
//Insert into cntactivity rel
if (isset($this->column_fields['contact_id']) && $this->column_fields['contact_id'] != '') {
$ctovalue = $this->column_fields['contact_id'];
$listofctos = explode(';', $this->column_fields['contact_id']);
foreach ($listofctos as $cto) {
$this->column_fields['contact_id'] = $cto;
$this->insertIntoEntityTable('vtiger_cntactivityrel', $module);
}
$this->column_fields['contact_id'] = $ctovalue;
} elseif ($this->column_fields['contact_id'] == '' && $insertion_mode == "edit") {
$this->deleteRelation('vtiger_cntactivityrel');
}
$recur_type = '';
if (($recur_type == "--None--" || $recur_type == '') && $this->mode == "edit") {
$sql = 'delete from vtiger_recurringevents where activityid=?';
$adb->pquery($sql, array($this->id));
}
//Handling for recurring type
//Insert into vtiger_recurring event table
if (isset($this->column_fields['recurringtype']) && $this->column_fields['recurringtype'] != '' && $this->column_fields['recurringtype'] != '--None--') {
$recur_type = trim($this->column_fields['recurringtype']);
$recur_data = getrecurringObjValue();
if (is_object($recur_data)) {
$this->insertIntoRecurringTable($recur_data);
}
}
//Insert into vtiger_activity_remainder table
$this->insertIntoReminderTable('vtiger_activity_reminder', $module, 0);
//Handling for invitees
$selected_users_string = isset($_REQUEST['inviteesid']) ? $_REQUEST['inviteesid'] : '';
$invitees_array = explode(';', $selected_users_string);
$this->insertIntoInviteeTable($module, $invitees_array);
//Inserting into sales man activity rel
$this->insertIntoSmActivityRel($module);
$this->insertIntoActivityReminderPopup($module);
}
function save_module($module)
{
global $adb;
//Handling module specific save
//Insert into seactivity rel
$insertion_mode = $this->mode;
if (isset($this->column_fields['parent_id']) && $this->column_fields['parent_id'] != '') {
$this->insertIntoEntityTable("vtiger_seactivityrel", $module);
} elseif ($this->column_fields['parent_id'] == '' && $insertion_mode == "edit") {
$this->deleteRelation("vtiger_seactivityrel");
}
$recordId = $this->id;
if (isset($_REQUEST['contactidlist']) && $_REQUEST['contactidlist'] != '') {
$adb->pquery('DELETE from vtiger_cntactivityrel WHERE activityid = ?', array($recordId));
$contactIdsList = explode(';', $_REQUEST['contactidlist']);
$count = count($contactIdsList);
$sql = 'INSERT INTO vtiger_cntactivityrel VALUES ';
for ($i = 0; $i < $count; $i++) {
$sql .= " ({$contactIdsList[$i]}, {$recordId})";
if ($i != $count - 1) {
$sql .= ',';
}
}
$adb->pquery($sql, array());
} else {
if (isset($this->column_fields['contact_id']) && $this->column_fields['contact_id'] != '') {
$adb->pquery('DELETE from vtiger_cntactivityrel WHERE activityid = ?', array($recordId));
$adb->pquery('INSERT INTO vtiger_cntactivityrel (`contactid`, `activityid`) VALUES (?, ?)', array($this->column_fields['contact_id'], $recordId));
} else {
if ($_REQUEST['contactidlist'] == '' && $this->column_fields['contact_id'] == '' && $insertion_mode == "edit") {
$adb->pquery('DELETE FROM vtiger_cntactivityrel WHERE activityid = ?', array($recordId));
}
}
}
$recur_type = '';
if (($recur_type == "--None--" || $recur_type == '') && $this->mode == "edit") {
$sql = 'delete from vtiger_recurringevents where activityid=?';
$adb->pquery($sql, array($this->id));
}
//Handling for recurring type
//Insert into vtiger_recurring event table
if (isset($this->column_fields['recurringtype']) && $this->column_fields['recurringtype'] != '' && $this->column_fields['recurringtype'] != '--None--') {
$recur_type = trim($this->column_fields['recurringtype']);
$recur_data = getrecurringObjValue();
if (is_object($recur_data)) {
$this->insertIntoRecurringTable($recur_data);
}
}
//Insert into vtiger_activity_remainder table
$this->insertIntoReminderTable('vtiger_activity_reminder', $module, "");
//Handling for invitees
$selected_users_string = $_REQUEST['inviteesid'];
$invitees_array = explode(';', $selected_users_string);
$this->insertIntoInviteeTable($module, $invitees_array);
//Inserting into sales man activity rel
$this->insertIntoSmActivityRel($module);
$adb->pquery('UPDATE vtiger_activity SET smownerid = ? WHERE `activityid` = ?;', array($this->column_fields['assigned_user_id'], $recordId));
$this->insertIntoActivityReminderPopup($module);
}
static function repeatFromRequest($focus)
{
global $log, $default_charset, $current_user;
$recurObj = getrecurringObjValue();
self::repeat($focus, $recurObj);
}
static function repeatFromRequest($focus)
{
$recurObj = getrecurringObjValue();
self::repeat($focus, $recurObj);
}
/**
* Repeat Activity instance till given limit.
*/
static function repeat($focus)
{
global $log;
$repeat = getrecurringObjValue();
$frequency = $repeat->recur_freq;
$repeattype = $repeat->recur_type;
$base_focus = new Activity();
$base_focus->retrieve_entity_info($focus->id, 'Events');
$base_focus->id = $_REQUEST['record'];
$base_focus_start = $base_focus->column_fields['date_start'] . ' ' . $base_focus->column_fields['time_start'];
$base_focus_end = $base_focus->column_fields['due_date'] . ' ' . $base_focus->column_fields['time_end'];
$repeat_limit = getDBInsertDateValue($_REQUEST['calendar_repeat_limit_date']) . ' ' . $base_focus->column_fields['time_start'];
$repeatIntervals = self::getRepeatInterval($repeattype, $frequency, $repeat, $base_focus_start, $repeat_limit);
$base_focus_start = self::mktime($base_focus_start);
$base_focus_end = self::mktime($base_focus_end);
$skip_focus_fields = array('record_id', 'createdtime', 'modifiedtime', 'recurringtype');
/** Create instance before and reuse */
$new_focus = new Activity();
foreach ($repeatIntervals as $interval) {
$new_focus_start_timing = self::nexttime($base_focus_start, "+{$interval} days");
$new_focus_start_timing = self::splittime(self::formattime($new_focus_start_timing));
$new_focus_end_timing = self::nexttime($base_focus_end, "+{$interval} days");
$new_focus_end_timing = self::splittime(self::formattime($new_focus_end_timing));
// Reset the new_focus and prepare for reuse
if (isset($new_focus->id)) {
unset($new_focus->id);
}
foreach ($new_focus->column_fields as $key => $value) {
$new_focus->column_fields[$key] = '';
}
foreach ($base_focus->column_fields as $key => $value) {
if (in_array($key, $skip_focus_fields)) {
// skip copying few fields
} else {
if ($key == 'date_start') {
$new_focus->column_fields['date_start'] = $new_focus_start_timing[0];
} else {
if ($key == 'time_start') {
$new_focus->column_fields['time_start'] = $new_focus_start_timing[1];
} else {
if ($key == 'time_end') {
$new_focus->column_fields['time_end'] = $new_focus_end_timing[1];
} else {
if ($key == 'due_date') {
$new_focus->column_fields['due_date'] = $new_focus_end_timing[0];
} else {
$new_focus->column_fields[$key] = $value;
}
}
}
}
}
}
$new_focus->save('Calendar');
}
}
function save_module($module)
{
global $adb;
//Handling module specific save
//Insert into seactivity rel
if (isset($this->column_fields['parent_id']) && $this->column_fields['parent_id'] != '') {
$this->insertIntoEntityTable("vtiger_seactivityrel", $module);
} elseif ($this->column_fields['parent_id'] == '' && $insertion_mode == "edit") {
$this->deleteRelation("vtiger_seactivityrel");
}
//Insert into cntactivity rel
if (isset($this->column_fields['contact_id']) && $this->column_fields['contact_id'] != '') {
$this->insertIntoEntityTable('vtiger_cntactivityrel', $module);
} elseif ($this->column_fields['contact_id'] == '' && $insertion_mode == "edit") {
$this->deleteRelation('vtiger_cntactivityrel');
}
if (!empty($this->column_fields['sendnotification'])) {
$mail_data = array();
$mail_data['user_id'] = $this->column_fields['assigned_user_id'];
$mail_data['subject'] = $this->column_fields['subject'];
$mail_data['status'] = $this->column_fields['activitytype'] == 'Task' ? $this->column_fields['taskstatus'] : $this->column_fields['eventstatus'];
$mail_data['taskpriority'] = $this->column_fields['taskpriority'];
$relatedContacts = getActivityRelatedContacts($this->id);
$mail_data['contact_name'] = implode(',', $relatedContacts);
$mail_data['description'] = $this->column_fields['description'];
$mail_data['st_date_time'] = $this->column_fields['date_start'] . ' ' . $this->column_fields['time_start'];
$mail_data['end_date_time'] = $this->column_fields['due_date'] . ' ' . $this->column_fields['time_end'];
$mail_data['relatedto'] = getParentName($this->column_fields['parent_id']);
$mail_data['location'] = $this->column_fields['location'];
getEventNotification($this->column_fields['activitytype'], $this->column_fields['subject'], $mail_data);
}
$recur_type = '';
if (($recur_type == "--None--" || $recur_type == '') && $this->mode == "edit") {
$sql = 'delete from vtiger_recurringevents where activityid=?';
$adb->pquery($sql, array($this->id));
}
//Handling for recurring type
//Insert into vtiger_recurring event table
if (isset($this->column_fields['recurringtype']) && $this->column_fields['recurringtype'] != '' && $this->column_fields['recurringtype'] != '--None--') {
$recur_type = trim($this->column_fields['recurringtype']);
$recur_data = getrecurringObjValue();
if (is_object($recur_data)) {
$this->insertIntoRecurringTable($recur_data);
}
}
//Insert into vtiger_activity_remainder table
$this->insertIntoReminderTable('vtiger_activity_reminder', $module, "");
//Handling for invitees
$selected_users_string = $_REQUEST['inviteesid'];
$invitees_array = explode(';', $selected_users_string);
$this->insertIntoInviteeTable($module, $invitees_array);
//Inserting into sales man activity rel
$this->insertIntoSmActivityRel($module);
$this->insertIntoActivityReminderPopup($module);
}
function save_module($module)
{
global $adb, $log;
//Handling module specific save
//Insert into seactivity rel
if (isset($this->column_fields['parent_id']) && $this->column_fields['parent_id'] != '') {
$this->insertIntoEntityTable("vtiger_seactivityrel", $module);
} elseif ($this->column_fields['parent_id'] == '' && $insertion_mode == "edit") {
$this->deleteRelation("vtiger_seactivityrel");
}
//Insert into cntactivity rel
if (isset($this->column_fields['contact_id']) && $this->column_fields['contact_id'] != '') {
$this->insertIntoEntityTable('vtiger_cntactivityrel', $module);
} elseif ($this->column_fields['contact_id'] == '' && $insertion_mode == "edit") {
$this->deleteRelation('vtiger_cntactivityrel');
}
$recordId = $this->id;
if (isset($_REQUEST['contactidlist']) && $_REQUEST['contactidlist'] != '') {
$adb->pquery('DELETE from vtiger_cntactivityrel WHERE activityid = ?', array($recordId));
$contactIdsList = explode(';', $_REQUEST['contactidlist']);
$count = count($contactIdsList);
$sql = 'INSERT INTO vtiger_cntactivityrel VALUES ';
for ($i = 0; $i < $count; $i++) {
$sql .= " ({$contactIdsList[$i]}, {$recordId})";
if ($i != $count - 1) {
$sql .= ',';
}
}
$adb->pquery($sql, array());
}
$recur_type = '';
if (($recur_type == "--None--" || $recur_type == '') && $this->mode == "edit") {
$sql = 'delete from vtiger_recurringevents where activityid=?';
$adb->pquery($sql, array($this->id));
}
//Handling for recurring type
//Insert into vtiger_recurring event table
if (isset($this->column_fields['recurringtype']) && $this->column_fields['recurringtype'] != '' && $this->column_fields['recurringtype'] != '--None--') {
$recur_type = trim($this->column_fields['recurringtype']);
$recur_data = getrecurringObjValue();
if (is_object($recur_data)) {
$this->insertIntoRecurringTable($recur_data);
}
}
//Insert into vtiger_activity_remainder table
$this->insertIntoReminderTable('vtiger_activity_reminder', $module, "");
//Handling for invitees
$selected_users_string = $_REQUEST['inviteesid'];
$invitees_array = explode(';', $selected_users_string);
$this->insertIntoInviteeTable($module, $invitees_array);
//Inserting into sales man activity rel
$this->insertIntoSmActivityRel($module);
$this->insertIntoActivityReminderPopup($module);
/////// Modified by jmangarret 08/05/2015 ENVIO DE EMAIL ///////
/*
array(40) { ["picklistDependency"]=> string(2) "[]" ["module"]=> string(6) "Events" ["action"]=> string(4) "Save" ["record"]=> string(0) ""
["defaultCallDuration"]=> string(1) "5" ["defaultOtherEventDuration"]=> string(1) "5" ["subject"]=> string(6) "prueba" ["assigned_user_id"]=> string(1) "1"
["date_start"]=> string(10) "07-05-2015" ["time_start"]=> string(8) "12:54:00" ["due_date"]=> string(10) "07-05-2015"
["time_end"]=> string(8) "12:59:00" ["eventstatus"]=> string(7) "Planned" ["sendnotification"]=> string(1) "0"
["activitytype"]=> string(4) "Call" ["location"]=> string(0) "" ["taskpriority"]=> string(0) ""
["visibility"]=> string(6) "Public" ["followup_date_start"]=> string(10) "07-05-2015" ["followup_time_start"]=> string(8) "12:54 PM"
["remdays"]=> string(1) "0" ["remhrs"]=> string(1) "0" ["remmin"]=> string(1) "1" ["repeat_frequency"]=> string(1) "1"
["recurringtype"]=> string(8) "--None--" ["calendar_repeat_limit_date"]=> string(10) "08-05-2015"
["repeatMonth"]=> string(4) "date" ["repeatMonth_date"]=> string(1) "2" ["repeatMonth_daytype"]=> string(5) "first"
["repeatMonth_day"]=> string(1) "0" ["popupReferenceModule"]=> string(8) "Accounts"
["contact_id_display"]=> string(0) "" ["relatedContactInfo"]=> string(0) "" ["parent_id"]=> string(0) ""
["parent_id_display"]=> string(0) "" ["description"]=> string(0) "" ["contactidlist"]=> string(0) ""
["inviteesid"]=> string(0) "" ["set_reminder"]=> string(2) "No" ["currentid"]=> int(9389) }
*/
$userid = $_REQUEST['assigned_user_id'];
$tarea = $_REQUEST['subject'];
$notificar = $_REQUEST['sendnotification'];
$descripcion = $_REQUEST["description"];
$fini = $_REQUEST["date_start"];
$ffin = $_REQUEST["due_date"];
$prioridad = $_REQUEST["taskpriority"];
$descripcion = $_REQUEST["description"];
$query = $adb->pquery("select * from vtiger_users where id = ? ", array($userid));
$row = $adb->fetchByAssoc($query);
$email = $row["email1"];
$nombre = $row["first_name"];
$asunto = "Informacion";
$mensaje = " \n\t\t<html> \n\t\t<head> \n\t\t<title>Info - Tu Agencia 24</title> \n\t\t</head> \n\t\t<body> \n\t\t<p>" . $nombre . ",</p>\n\t\t<p>Se te ha asignado una nueva tarea con los siguientes datos:</p>\n\t\t<p><b>Tarea: </b>" . $tarea . "</p>\n\t\t<p><b>Fecha Inicio: </b>" . $fini . "</p>\n\t\t<p><b>Fecha Final: </b>" . $ffin . "</p>\t\t\n\t\t<p><b>Prioridad: </b>" . $prioridad . "</p>\t\t\n\t\t<p><b>Descripcion: </b>" . $descripcion . "</p>\t\t\n\t\t<BR><BR><BR>\n\t\t<i>\n\t\tGracias,\t\t\n\t\t<p>Equipo TuAgencia24.com</p>\n\t\t</i>\n\t\t</body> \n\t\t</html> ";
if ($notificar) {
enviarEmail($email, $asunto, $mensaje);
}
/////////////////////////////////////////////////// FIN ENVIO DE EMAIL //////////////////////////
}
