function toHtml()
{
$str = "";
if ($this->_flagFrozen) {
$str .= $this->getFrozenHtml();
} else {
$value = $this->getAttribute('value');
if (is_numeric($value)) {
$value = date('Y-m-d', $value);
}
$id = $this->getAttribute('id');
$name = $this->getAttribute('name');
if ($value) {
$this->setAttribute('value', Base_RegionalSettingsCommon::time2reg($value, false, true, false));
}
if (!isset($id)) {
$id = 'datepicker_field_' . $name;
$this->updateAttributes(array('id' => $id));
}
$ex_date = Base_RegionalSettingsCommon::time2reg(null, false, true, false);
$date_format = Base_RegionalSettingsCommon::date_format();
$this->setType('text');
if (!$this->getAttribute('placeholder')) {
$this->setAttribute('placeholder', __('Click to select date'));
}
$js = Utils_PopupCalendarCommon::create_href(md5($id), 'new Ajax.Request(\'modules/Utils/PopupCalendar/up.php\',' . '{method:\'post\', parameters:{date: __YEAR__+\'-\'+__MONTH__+\'-\'+__DAY__},' . 'onSuccess:function(t){e=$(\'' . Epesi::escapeJS($id, false) . '\');if(e) {e.value=t.responseText;jq(e).change();}}})', null, null, 'popup.clonePosition(\'' . $id . '\',{setWidth:false,setHeight:false,offsetTop:$(\'' . $id . '\').getHeight()})', $value, $id);
$str .= $this->_getTabs() . '<input ' . $js . ' ' . $this->_getAttrString($this->_attributes) . ' ' . Utils_TooltipCommon::open_tag_attrs(__('Example date: %s', array($ex_date)), false) . ' />';
eval_js('Event.observe(\'' . $id . '\',\'keypress\',Utils_PopupCalendarDatePicker.validate.bindAsEventListener(Utils_PopupCalendarDatePicker,\'' . Epesi::escapeJS($date_format, false) . '\'))');
eval_js('Event.observe(\'' . $id . '\',\'blur\',Utils_PopupCalendarDatePicker.validate_blur.bindAsEventListener(Utils_PopupCalendarDatePicker,\'' . Epesi::escapeJS($date_format, false) . '\'))');
}
return $str;
}
public static function submit_contact($values, $mode)
{
if ($mode == 'display') {
$ret = array();
$in = self::Instance();
$filename = self::get_photo($values['id']);
if ($filename) {
$file = $in->get_data_dir() . $filename;
} else {
$file = Base_ThemeCommon::get_template_file('CRM/Contacts/Photo', 'placeholder.png');
$ret['photo_note'] = __('Click to change');
}
$ret['photo_link'] = Module::create_href(array('upload_new_photo' => $values['id'])) . ' ' . Utils_TooltipCommon::open_tag_attrs(__('Click to change the photo'), false);
$ret['photo_src'] = $file;
} else {
$ret = $values;
}
if (isset($_REQUEST['upload_new_photo']) && $_REQUEST['upload_new_photo'] == $values['id']) {
unset($_REQUEST['upload_new_photo']);
$x = ModuleManager::get_instance('/Base_Box|0');
if (!$x) {
trigger_error('There is no base box module instance', E_USER_ERROR);
}
$x->push_main('CRM/Contacts/Photo', 'body', array($values));
}
return $ret;
}
public static function print_event($ev, $mode = '', $with_div = true)
{
$th = Base_ThemeCommon::init_smarty();
$ex = self::process_event($ev);
$th->assign('event_id', $ev['id']);
$th->assign('draggable', !isset($ev['draggable']) || $ev['draggable'] === true);
$title = $ev['title'];
$title_st = strip_tags($ev['title']);
$title_s = $title;
$th->assign('with_div', $with_div);
$th->assign('title', $title);
$th->assign('title_s', $title_s);
$th->assign('description', $ev['description']);
$th->assign('color', $ev['color']);
$th->assign('start', $ex['start']);
$th->assign('start_time', $ex['start_time']);
$th->assign('end_time', $ex['end_time']);
$th->assign('start_date', $ex['start_date']);
$th->assign('end_date', $ex['end_date']);
$th->assign('start_day', $ex['start_day']);
$th->assign('end_day', $ex['end_day']);
$th->assign('end', $ex['end']);
$th->assign('duration', $ex['duration']);
$th->assign('show_hide_info', __('Click to show / hide menu'));
$th->assign('additional_info', $ev['additional_info']);
$th->assign('additional_info2', $ev['additional_info2']);
if (isset($ev['custom_tooltip'])) {
$th->assign('custom_tooltip', $ev['custom_tooltip']);
}
ob_start();
Base_ThemeCommon::display_smarty($th, 'Utils_Calendar', 'event_tip');
$tip = ob_get_clean();
$th->assign('tip_tag_attrs', Utils_TooltipCommon::open_tag_attrs($tip, false));
if (!isset($ev['view_action']) || $ev['view_action'] === true) {
$th->assign('view_href', Module::create_href(array('UCev_id' => $ev['id'], 'UCaction' => 'view')));
} elseif ($ev['view_action'] !== false) {
$th->assign('view_href', $ev['view_action']);
}
if (!isset($ev['edit_action']) || $ev['edit_action'] === true) {
$th->assign('edit_href', Module::create_href(array('UCev_id' => $ev['id'], 'UCaction' => 'edit')));
} elseif ($ev['edit_action'] !== false) {
$th->assign('edit_href', $ev['edit_action']);
}
$link_text = Module::create_href_js(array('UCev_id' => $ev['id'], 'UCaction' => 'move', 'UCdate' => '__YEAR__-__MONTH__-__DAY__'));
if (!isset($ev['move_action']) || $ev['move_action'] === true) {
$th->assign('move_href', Utils_PopupCalendarCommon::create_href('move_event' . str_replace(array('#', '-'), '_', $ev['id']), $link_text, null, null, 'popup.clonePosition(\'utils_calendar_event:' . $ev['id'] . '\',{setWidth:false,setHeight:false,offsetTop:$(\'utils_calendar_event:' . $ev['id'] . '\').getHeight()})'));
}
if (!isset($ev['delete_action']) || $ev['delete_action'] === true) {
$th->assign('delete_href', Module::create_confirm_href(__('Delete this event?'), array('UCev_id' => $ev['id'], 'UCaction' => 'delete')));
} elseif ($ev['delete_action'] !== false) {
$th->assign('delete_href', $ev['delete_action']);
}
$th->assign('handle_class', 'handle');
$th->assign('custom_actions', $ev['actions']);
Base_ThemeCommon::display_smarty($th, 'Utils_Calendar', 'event' . ($mode ? '_' . $mode : ''));
}
function toHtml() {
$str = "";
if ($this->_flagFrozen) {
$str .= $this->getFrozenHtml();
} else {
$id = $this->getAttribute('id');
$name = $this->getAttribute('name');
if(!isset($id)) {
$id = 'currency_field_'.$name;
$this->updateAttributes(array('id'=>$id));
}
$this->dec_digits = DB::GetOne('SELECT MAX(decimals) FROM utils_currency');
$str .= $this->_getTabs() . '<div style="position: relative;">';
$str .= $this->_getTabs() .
'<div style="margin-right:45px;" class="currency_amount"><input ' . $this->_getAttrString($this->_attributes) . ' '.
Utils_TooltipCommon::open_tag_attrs(__('Example value: %s',array('123'.Utils_CurrencyFieldCommon::get_decimal_point().implode('',range(4,3+$this->dec_digits)))), false ).
' /></div>';
$str .= $this->_getTabs() .
'<div style="margin-right:5px; width:40px; position:absolute;top:0px;right:0px;"><select style="width:40px;" name="__'.str_replace(array('[',']'),'',$name).'__currency" id="__'.$id.'__currency">';
$curs = DB::GetAll('SELECT id, symbol, active FROM utils_currency ORDER BY code');
foreach ($curs as $v) {
if ($v['id']!=$this->currency && !$v['active']) continue;
$str .= '<option value="'.$v['id'].'"';
if ($v['id']==$this->currency) $str .= ' selected="1"';
$str .= '>'.$v['symbol'].'</option>';
}
$str .= '</select></div>';
$str .= $this->_getTabs() . '</div>';
load_js('modules/Utils/CurrencyField/currency.js');
$curr_format = '-?([0-9]*)\\'.Utils_CurrencyFieldCommon::get_decimal_point().'?[0-9]{0,'.$this->dec_digits.'}';
eval_js('Event.observe(\''.$id.'\',\'keypress\',Utils_CurrencyField.validate.bindAsEventListener(Utils_CurrencyField,\''.Epesi::escapeJS($curr_format,false).'\'))');
eval_js('Event.observe(\''.$id.'\',\'blur\',Utils_CurrencyField.validate_blur.bindAsEventListener(Utils_CurrencyField,\''.Epesi::escapeJS($curr_format,false).'\'))');
}
return $str;
} //end func toHtml
/**
* Displays action bar.
*/
public function body()
{
$this->help('ActionBar basics', 'main');
$icons = Base_ActionBarCommon::get();
//sort
usort($icons, array($this, 'compare'));
//translate
foreach ($icons as &$i) {
$description = $i['description'];
if ($i['description']) {
$t = Utils_TooltipCommon::open_tag_attrs($description);
} else {
$t = '';
}
$i['open'] = '<a ' . $i['action'] . ' ' . $t . '>';
$i['close'] = '</a>';
$i['helpID'] = 'ActionBar_' . $i['icon'];
if (strpos($i['icon'], '/') !== false && file_exists($i['icon'])) {
$i['icon_url'] = $i['icon'];
unset($i['icon']);
}
//if (isset(Base_ActionBarCommon::$available_icons[$i['icon']]))
// $i['icon'] = Base_ThemeCommon::get_template_file('Base_ActionBar','icons/'.$i['icon'].'.png');
}
$launcher = array();
if (Base_AclCommon::is_user()) {
$opts = Base_Menu_QuickAccessCommon::get_options();
if (!empty($opts)) {
self::$launchpad = array();
foreach ($opts as $k => $v) {
if (Base_ActionBarCommon::$quick_access_shortcuts && Base_User_SettingsCommon::get(Base_Menu_QuickAccessCommon::module_name(), $v['name'] . '_d')) {
$ii = array();
$trimmed_label = trim(substr(strrchr($v['label'], ':'), 1));
$ii['label'] = $trimmed_label ? $trimmed_label : $v['label'];
$ii['description'] = $v['label'];
$arr = $v['link'];
if (isset($arr['__url__'])) {
$ii['open'] = '<a href="' . $arr['__url__'] . '" target="_blank">';
} else {
$ii['open'] = '<a ' . Base_MenuCommon::create_href($this, $arr) . '>';
}
$ii['close'] = '</a>';
if (isset($v['link']['__icon__'])) {
$icon = Base_ThemeCommon::get_template_file($v['module'], $v['link']['__icon__']);
} else {
$icon = Base_ThemeCommon::get_template_file($v['module'], 'icon.png');
}
if (!$icon) {
$icon = Base_ThemeCommon::get_template_file($this->get_type(), 'default_icon.png');
}
$ii['icon'] = $icon;
$launcher[] = $ii;
}
if (Base_User_SettingsCommon::get(Base_Menu_QuickAccessCommon::module_name(), $v['name'] . '_l')) {
$ii = array();
$trimmed_label = trim(substr(strrchr($v['label'], ':'), 1));
$ii['label'] = $trimmed_label ? $trimmed_label : $v['label'];
$ii['description'] = $v['label'];
$arr = $v['link'];
if (isset($arr['__url__'])) {
$ii['open'] = '<a href="' . $arr['__url__'] . '" target="_blank" onClick="actionbar_launchpad_deactivate()">';
} else {
$ii['open'] = '<a onClick="actionbar_launchpad_deactivate();' . Base_MenuCommon::create_href_js($this, $arr) . '" href="javascript:void(0)">';
}
$ii['close'] = '</a>';
if (isset($v['link']['__icon__'])) {
$icon = Base_ThemeCommon::get_template_file($v['module'], $v['link']['__icon__']);
} else {
$icon = Base_ThemeCommon::get_template_file($v['module'], 'icon.png');
}
if (!$icon) {
$icon = Base_ThemeCommon::get_template_file($this->get_type(), 'default_icon.png');
}
$ii['icon'] = $icon;
self::$launchpad[] = $ii;
}
}
}
}
//display
$th = $this->pack_module(Base_Theme::module_name());
$th->assign('icons', $icons);
$th->assign('launcher', array_reverse($launcher));
$th->display();
}
public function body()
{
Libs_LeightboxCommon::display('aboutepesi', $this->get_info(), 'About');
print '<a ' . Libs_LeightboxCommon::get_open_href('aboutepesi') . ' ' . Utils_TooltipCommon::open_tag_attrs(__('Click to get more info')) . '><img src="images/epesi-powered.png" border=0></a>';
}
public function applet($conf, &$opts)
{
Epesi::load_js('modules/CRM/Roundcube/utils.js');
$opts['go'] = true;
$accounts = array();
$ret = array();
$update_applet = '';
foreach ($conf as $key => $on) {
$x = explode('_', $key);
if ($x[0] == 'account' && $on) {
$id = $x[1];
$accounts[] = $id;
}
}
$accs = Utils_RecordBrowserCommon::get_records('rc_accounts', array('epesi_user' => Acl::get_user(), 'id' => $accounts));
print '<ul>';
foreach ($accs as $row) {
$mail = $row['account_name'];
$cell_id = 'mailaccount_' . $opts['id'] . '_' . $row['id'];
//interval execution
eval_js_once('setInterval(\'CRM_RC.update_msg_num(' . $opts['id'] . ' ,' . $row['id'] . ' , 0)\',300000)');
//and now
$update_applet .= 'CRM_RC.update_msg_num(' . $opts['id'] . ' ,' . $row['id'] . ' ,1);';
print '<li><i><a' . $this->create_callback_href(array($this, 'open_rc_account'), $row['id']) . '>' . $mail . '</a></i> - <span id="' . $cell_id . '"></span></li>';
}
print '</ul>';
$this->js($update_applet);
$href = $this->create_callback_href(array('Base_BoxCommon', 'push_module'), array($this->get_type(), 'account_manager', array(true)));
$img = '<img src="' . Base_ThemeCommon::get_template_file('Base_Dashboard', 'configure.png') . '" border="0">';
$tooltip = Utils_TooltipCommon::open_tag_attrs(__('Go to account settings'));
$opts['actions'][] = "<a {$tooltip} {$href}>{$img}</a>";
}
public static function submit_task($values, $mode)
{
$me = CRM_ContactsCommon::get_my_record();
switch ($mode) {
case 'display':
$values['title'] = __('Follow-up') . ': ' . $values['title'];
$values['status'] = 0;
$values['deadline'] = date('Y-m-d', strtotime('+1 day'));
$ret = array();
$cus = reset($values['customers']);
if (ModuleManager::is_installed('CRM/Meeting') >= 0) {
$ret['new']['event'] = '<a ' . Utils_TooltipCommon::open_tag_attrs(__('New Meeting')) . ' ' . Utils_RecordBrowserCommon::create_new_record_href('crm_meeting', array('title' => $values['title'], 'permission' => $values['permission'], 'priority' => $values['priority'], 'description' => $values['description'], 'date' => date('Y-m-d'), 'time' => date('H:i:s'), 'duration' => 3600, 'employees' => $values['employees'], 'customers' => $values['customers'], 'status' => 0), 'none', false) . '><img border="0" src="' . Base_ThemeCommon::get_template_file('CRM_Calendar', 'icon-small.png') . '" /></a>';
}
$ret['new']['task'] = '<a ' . Utils_TooltipCommon::open_tag_attrs(__('New Task')) . ' ' . Utils_RecordBrowserCommon::create_new_record_href('task', $values) . '><img border="0" src="' . Base_ThemeCommon::get_template_file('CRM_Tasks', 'icon-small.png') . '" /></a>';
if (ModuleManager::is_installed('CRM/PhoneCall') >= 0) {
$ret['new']['phonecall'] = '<a ' . Utils_TooltipCommon::open_tag_attrs(__('New Phonecall')) . ' ' . Utils_RecordBrowserCommon::create_new_record_href('phonecall', array('subject' => $values['title'], 'permission' => $values['permission'], 'priority' => $values['priority'], 'description' => $values['description'], 'date_and_time' => date('Y-m-d H:i:s'), 'employees' => $values['employees'], 'customer' => $cus, 'status' => 0), 'none', false) . '><img border="0" src="' . Base_ThemeCommon::get_template_file('CRM_PhoneCall', 'icon-small.png') . '" /></a>';
}
$ret['new']['note'] = Utils_RecordBrowser::$rb_obj->add_note_button('task/' . $values['id']);
return $ret;
case 'adding':
$values['deadline_time'] = strtotime(date('Y-m-d') . ' 23:59:59');
$values['permission'] = Base_User_SettingsCommon::get('CRM_Common', 'default_record_permission');
break;
case 'add':
break;
case 'edit':
$old_values = Utils_RecordBrowserCommon::get_record('task', $values['id']);
$old_related = array_merge($old_values['employees'], $old_values['customers']);
case 'added':
if (isset($values['follow_up'])) {
CRM_FollowupCommon::add_tracing_notes($values['follow_up'][0], $values['follow_up'][1], $values['follow_up'][2], 'task', $values['id'], $values['title']);
}
self::subscribed_employees($values);
$related = array_merge($values['employees'], $values['customers']);
foreach ($related as $v) {
if ($mode === 'edit' && in_array($v, $old_related)) {
continue;
}
if (!is_numeric($v)) {
list($t, $id) = explode(':', $v);
} else {
$t = 'P';
$id = $v;
}
if ($t == 'P') {
$t = 'contact';
} else {
$t = 'company';
}
$subs = Utils_WatchdogCommon::get_subscribers($t, $id);
foreach ($subs as $s) {
Utils_WatchdogCommon::user_subscribe($s, 'task', $values['id']);
}
}
break;
}
return $values;
}
public function register_form($data = null)
{
if ($this->is_back()) {
return false;
}
Base_ActionBarCommon::add('back', __('Back'), $this->create_back_href());
$f = $this->init_module(Libs_QuickForm::module_name());
$admin_email_tooltip = '<img ' . Utils_TooltipCommon::open_tag_attrs(__('This email will be used to send registation link and to contact Administator directly.'), false) . ' src="' . Base_ThemeCommon::get_icon('info') . '"/> ';
$tax_id_tooltip = '<img ' . Utils_TooltipCommon::open_tag_attrs(__('Your company Tax ID for invoices.'), false) . ' src="' . Base_ThemeCommon::get_icon('info') . '"/> ';
$f->addElement('text', 'company_name', __('Company Name'), array('maxlength' => 128));
$f->addRule('company_name', __('Field required'), 'required');
$f->addRule('company_name', __('Max length exceeded'), 'maxlength', 128);
$f->addElement('text', 'short_name', __('Short Name'), array('maxlength' => 64));
$f->addRule('short_name', __('Max length exceeded'), 'maxlength', 64);
$f->addElement('text', 'phone', __('Phone'), array('maxlength' => 64));
$f->addRule('phone', __('Max length exceeded'), 'maxlength', 64);
$f->addElement('text', 'fax', __('Fax'), array('maxlength' => 64));
$f->addRule('fax', __('Max length exceeded'), 'maxlength', 64);
$f->addElement('text', 'email', __('Company email'), array('maxlength' => 128));
$f->addRule('email', __('Max length exceeded'), 'maxlength', 128);
$f->addRule('email', __('Invalid e-mail address'), 'email');
$f->addElement('text', 'web_address', __('Web address'), array('maxlength' => 64));
$f->addRule('web_address', __('Max length exceeded'), 'maxlength', 64);
$f->addElement('text', 'address_1', __('Address 1'), array('maxlength' => 64));
$f->addRule('address_1', __('Field required'), 'required');
$f->addRule('address_1', __('Max length exceeded'), 'maxlength', 64);
$f->addElement('text', 'address_2', __('Address 2'), array('maxlength' => 64));
$f->addRule('address_2', __('Max length exceeded'), 'maxlength', 64);
$f->addElement('text', 'city', __('City'), array('maxlength' => 64));
$f->addRule('city', __('Field required'), 'required');
$f->addRule('city', __('Max length exceeded'), 'maxlength', 64);
$f->addElement('commondata', 'country', __('Country'), 'Countries');
$f->addRule('country', __('Field required'), 'required');
$f->addElement('commondata', 'zone', __('Zone'), array('Countries', 'country'), array('empty_option' => true));
$f->addElement('text', 'postal_code', __('Postal Code'), array('maxlength' => 64));
$f->addRule('postal_code', __('Field required'), 'required');
$f->addRule('postal_code', __('Max length exceeded'), 'maxlength', 64);
$f->addElement('text', 'tax_id', $tax_id_tooltip . __('Tax ID'), array('maxlength' => 64));
$f->addRule('admin_email', __('Max length exceeded'), 'maxlength', 64);
$f->addElement('text', 'admin_first_name', __('Administrator\'s first name'), array('maxlength' => 64));
$f->addRule('admin_first_name', __('Field required'), 'required');
$f->addRule('admin_first_name', __('Max length exceeded'), 'maxlength', 64);
$f->addElement('text', 'admin_last_name', __('Administrator\'s last name'), array('maxlength' => 64));
$f->addRule('admin_last_name', __('Field required'), 'required');
$f->addRule('admin_last_name', __('Max length exceeded'), 'maxlength', 64);
$f->addElement('text', 'admin_email', $admin_email_tooltip . __('Administrator\'s email'), array('maxlength' => 128));
$f->addRule('admin_email', __('Field required'), 'required');
$f->addRule('admin_email', __('Max length exceeded'), 'maxlength', 128);
$f->addRule('admin_email', __('Invalid e-mail address'), 'email');
if ($f->validate()) {
$ret = $f->exportValues();
$ret = Base_EssClientCommon::server()->register_installation_request($ret);
if ($ret) {
if (is_string($ret)) {
Base_EssClientCommon::set_license_key($ret);
}
location(array());
return false;
}
}
// set defaults
print '<div class="important_notice">';
print __('Enter Company and Administrator details. This data will be sent to EPESI Store Server to provide us with contact information. The data sent to EPESI Store Server is limited only to the data you enter using this form and what modules are being purchased and downloaded.');
print '<br>';
if ($data) {
$f->setDefaults($data);
} else {
if (ModuleManager::is_installed('CRM_Contacts') > -1) {
print '<span style="color:gray;font-size:10px;">' . __('Data below was auto-filled based on Main Company and first Super administrator. Make sure that the data is correct and change it if necessary.') . '</span>';
$defaults = Base_EssClientCommon::get_possible_admin();
$mc = CRM_ContactsCommon::get_main_company();
if ($mc > 0) {
$company = CRM_ContactsCommon::get_company($mc);
if ($company) {
$defaults = array_merge($company, $defaults);
}
}
$f->setDefaults($defaults);
}
}
if ($data) {
if (isset($data['status']) && strcasecmp($data['status'], 'Confirmed') == 0) {
print '<div style="color:gray;font-size:10px;">' . __('Updating Company data will require re-validation by our representative.') . '</div>';
}
print '<div style="color:red;font-size:10px;">' . __('Changing Administrator e-mail address will require e-mail confirmation.') . '</div>';
}
print '<center>';
$f->addElement('submit', 'submit', $data ? __('Update') : __('Register'));
$f->display_as_column();
print '</center>';
print '</div>';
return true;
}
public static function submit_meeting($values, $mode)
{
$me = CRM_ContactsCommon::get_my_record();
switch ($mode) {
case 'delete':
Utils_MessengerCommon::delete_by_id('CRM_Calendar_Event:' . $values['id']);
break;
case 'display':
$pdf = Utils_RecordBrowser::$rb_obj->pack_module('Libs/TCPDF', 'L');
if ($pdf->prepare()) {
$pdf->set_title($values['title']);
$pdf->set_subject('');
$pdf->prepare_header();
$pdf->AddPage();
$v = CRM_Calendar_EventCommon::get(DB::GetOne('SELECT id FROM crm_calendar_custom_events_handlers WHERE group_name=%s', array('Meetings')) . '#' . $values['id']);
$ev_mod = Utils_RecordBrowser::$rb_obj->init_module('CRM/Calendar/Event');
$ev_mod->make_event_PDF($pdf, $v, true, 'view');
}
$pdf->add_actionbar_icon('Print');
if (isset($_REQUEST['day'])) {
$values['date'] = $_REQUEST['day'];
}
$ret = array();
if ($values['time']) {
// normal event
$start = $values['time'];
// time in unix timestamp UTC
$start_disp = strtotime(Base_RegionalSettingsCommon::time2reg($start, true, true, true, false));
} else {
// when event is timeless - all day event
$time = $values['date'] . ' 00:00:01';
$start = Base_RegionalSettingsCommon::reg2time($time);
$start_disp = strtotime($time);
}
$end = strtotime('+' . $values['duration'] . ' seconds', $start);
$ret['day_details'] = array('start' => array('day' => '<a ' . Base_BoxCommon::create_href(null, 'CRM/Calendar', 'body', array(array('default_view' => 'day', 'default_date' => strtotime($values['date']))), array()) . '>' . date('j', $start_disp) . '</a>', 'month' => '<a ' . Base_BoxCommon::create_href(null, 'CRM/Calendar', 'body', array(array('default_view' => 'month', 'default_date' => strtotime($values['date']))), array()) . '>' . __date('F', $start_disp) . '</a>', 'year' => '<a ' . Base_BoxCommon::create_href(null, 'CRM/Calendar', 'body', array(array('default_view' => 'year', 'default_date' => strtotime($values['date']))), array()) . '>' . date('Y', $start_disp) . '</a>', 'weekday' => '<a ' . Base_BoxCommon::create_href(null, 'CRM/Calendar', 'body', array(array('default_view' => 'week', 'default_date' => strtotime($values['date']))), array()) . '>' . __date('l', $start_disp) . '</a>'));
if (!isset($values['timeless']) || !$values['timeless']) {
$ret['event_info'] = array('start_time' => Base_RegionalSettingsCommon::time2reg($start, 2, false), 'end_time' => Base_RegionalSettingsCommon::time2reg($end, 2, false), 'duration' => Base_RegionalSettingsCommon::seconds_to_words($values['duration']), 'start_date' => '-', 'end_date' => '-');
}
$ret['form_data']['timeless'] = array('label' => __('Timeless'), 'html' => 'value');
$ret['toggle_duration'] = 'tog';
$ret['duration_block_id'] = '1';
$ret['event_end_block_id'] = '2';
$values['title'] = __('Follow-up') . ': ' . $values['title'];
$values['status'] = 0;
$cus = reset($values['customers']);
if (ModuleManager::is_installed('CRM/Meeting') >= 0) {
$ret['new']['event'] = '<a ' . Utils_TooltipCommon::open_tag_attrs(__('New Meeting')) . ' ' . Utils_RecordBrowserCommon::create_new_record_href('crm_meeting', array('title' => $values['title'], 'permission' => $values['permission'], 'priority' => $values['priority'], 'description' => $values['description'], 'date' => date('Y-m-d'), 'time' => date('H:i:s'), 'duration' => 3600, 'employees' => $values['employees'], 'customers' => $values['customers'], 'status' => 0), 'none', false) . '><img border="0" src="' . Base_ThemeCommon::get_template_file('CRM_Calendar', 'icon-small.png') . '" /></a>';
}
if (ModuleManager::is_installed('CRM/Tasks') >= 0) {
$ret['new']['task'] = '<a ' . Utils_TooltipCommon::open_tag_attrs(__('New Task')) . ' ' . Utils_RecordBrowserCommon::create_new_record_href('task', array('title' => $values['title'], 'permission' => $values['permission'], 'priority' => $values['priority'], 'description' => $values['description'], 'employees' => $values['employees'], 'customers' => $values['customers'], 'status' => 0, 'deadline' => date('Y-m-d', strtotime('+1 day')))) . '><img border="0" src="' . Base_ThemeCommon::get_template_file('CRM_Tasks', 'icon-small.png') . '"></a>';
}
if (ModuleManager::is_installed('CRM/PhoneCall') >= 0) {
$ret['new']['phonecall'] = '<a ' . Utils_TooltipCommon::open_tag_attrs(__('New Phonecall')) . ' ' . Utils_RecordBrowserCommon::create_new_record_href('phonecall', array('subject' => $values['title'], 'permission' => $values['permission'], 'priority' => $values['priority'], 'description' => $values['description'], 'date_and_time' => date('Y-m-d H:i:s'), 'employees' => $values['employees'], 'customer' => $cus, 'status' => 0), 'none', false) . '><img border="0" src="' . Base_ThemeCommon::get_template_file('CRM_PhoneCall', 'icon-small.png') . '" /></a>';
}
$ret['new']['note'] = Utils_RecordBrowser::$rb_obj->add_note_button('crm_meeting/' . $values['id']);
return $ret;
case 'edit':
self::subscribed_employees($values);
$alarms = Utils_MessengerCommon::get_alarms('CRM_Calendar_Event:' . $values['id']);
$old = Utils_RecordBrowserCommon::get_record('crm_meeting', $values['id']);
$old_time = strtotime($old['date'] . ' ' . date('H:i:s', strtotime($old['time'])));
$new_time = strtotime($values['date'] . ' ' . date('H:i:s', strtotime($values['time'])));
foreach ($alarms as $id => $time) {
$time = strtotime($time);
$diff = $old_time - $time;
Utils_MessengerCommon::update_time($id, $new_time - $diff);
}
case 'add':
if (isset($values['duration_switch']) && !$values['duration_switch']) {
$values['duration'] = strtotime($values['end_time']) - strtotime($values['time']);
if ($values['duration'] < 0) {
$values['duration'] += 60 * 60 * 24;
}
// failsafe
}
if (isset($values['timeless']) && $values['timeless']) {
$values['duration'] = -1;
}
$new = '';
foreach (array(0 => 'Mon', 1 => 'Tue', 2 => 'Wed', 3 => 'Thu', 4 => 'Fri', 5 => 'Sat', 6 => 'Sun') as $k => $v) {
if (isset($values['recurrence_hash_' . $k]) && $values['recurrence_hash_' . $k]) {
$new .= '1';
} else {
$new .= '0';
}
}
if ($new != '0000000') {
$values['recurrence_hash'] = $new;
}
if ($values['duration'] != -1) {
if (isset($values['modded'])) {
$time = Base_RegionalSettingsCommon::time2reg($values['time'], true, true, true, false);
$reg_timestamp = $values['date'] . ' ' . date('H:i:s', strtotime($time));
$timestamp = Base_RegionalSettingsCommon::reg2time($reg_timestamp);
$values['date'] = date('Y-m-d', $timestamp);
$values['time'] = date('Y-m-d H:i:s', $timestamp);
if (isset($values['recurrence_end']) && $values['recurrence_end']) {
$values['recurrence_end'] = date('Y-m-d', Base_RegionalSettingsCommon::reg2time($values['recurrence_end'] . ' ' . date('H:i:s', strtotime($time))));
if ($values['recurrence_end'] < $values['date']) {
$values['recurrence_end'] = $values['date'];
}
if ($values['recurrence_type'] == 8) {
$date = date('Y-m-d', strtotime('+6 days', strtotime($values['date'])));
if ($values['recurrence_end'] < $date) {
$values['recurrence_end'] = $date;
}
}
}
}
} else {
$values['time'] = '';
}
break;
case 'adding':
$values['permission'] = Base_User_SettingsCommon::get('CRM_Common', 'default_record_permission');
case 'editing':
case 'view':
$values['modded'] = 1;
if (!isset($values['date'])) {
$values['date'] = date('Y-m-d');
}
if (!isset($values['time'])) {
$values['time'] = time();
}
if (!isset($values['duration'])) {
$values['duration'] = 3600;
}
if (!is_numeric($values['time'])) {
$values['time'] = strtotime($values['time']);
}
if ($values['duration'] != -1) {
if (isset($values['date']) && $values['date']) {
$values['date'] = Base_RegionalSettingsCommon::time2reg($values['date'] . ' ' . date('H:i:s', $values['time']), false, true, true, false);
$values['time'] = Base_RegionalSettingsCommon::time2reg($values['date'] . ' ' . date('H:i:s', $values['time']), true, false, true, false);
$values['time'] = Base_RegionalSettingsCommon::reg2time($values['date'] . ' ' . $values['time']);
}
if (isset($values['recurrence_end']) && $values['recurrence_end']) {
$values['recurrence_end'] = Base_RegionalSettingsCommon::time2reg($values['recurrence_end'] . ' ' . date('H:i:s', $values['time']), false, true, true, false);
}
}
break;
case 'added':
if (isset($values['follow_up'])) {
CRM_FollowupCommon::add_tracing_notes($values['follow_up'][0], $values['follow_up'][1], $values['follow_up'][2], 'meeting', $values['id'], $values['title']);
}
self::subscribed_employees($values);
$related = array_merge($values['employees'], $values['customers']);
foreach ($related as $v) {
if ($mode === 'edit' && in_array($v, $old_related)) {
continue;
}
if (!is_numeric($v)) {
list($t, $id) = explode(':', $v);
} else {
$t = 'P';
$id = $v;
}
if ($t == 'P') {
$t = 'contact';
} else {
$t = 'company';
}
$subs = Utils_WatchdogCommon::get_subscribers($t, $id);
foreach ($subs as $s) {
Utils_WatchdogCommon::user_subscribe($s, 'crm_meeting', $values['id']);
}
}
if (isset($values['messenger_on']) && $values['messenger_on'] != 'none') {
$start = strtotime($values['date'] . ' ' . date('H:i:s', strtotime($values['time'])));
if ($values['messenger_on'] == 'me') {
Utils_MessengerCommon::add('CRM_Calendar_Event:' . $values['id'], 'CRM_Meeting', $values['messenger_message'], $start - $values['messenger_before'], array('CRM_MeetingCommon', 'get_alarm'), array($values['id']));
} else {
$eee = array();
foreach ($values['employees'] as $v) {
$c = CRM_ContactsCommon::get_contact($v);
if (isset($c['login'])) {
$eee[] = $c['login'];
}
}
Utils_MessengerCommon::add('CRM_Calendar_Event:' . $values['id'], 'CRM_Meeting', $values['messenger_message'], $start - $values['messenger_before'], array('CRM_MeetingCommon', 'get_alarm'), array($values['id']), $eee);
}
}
break;
}
return $values;
}
public function get_jump_to_id_button() {
$jump_to_id = DB::GetOne('SELECT jump_to_id FROM recordbrowser_table_properties WHERE tab=%s', array($this->tab));
if (!$jump_to_id) {
return '';
}
$link = Module::create_href_js(Utils_RecordBrowserCommon::get_record_href_array($this->tab, '__ID__'));
if (isset($_REQUEST['__jump_to_RB_record'])) Base_StatusBarCommon::message(__('Record not found'), 'warning');
$link = str_replace('__ID__', '\'+this.value+\'', $link);
return ' <a '.Utils_TooltipCommon::open_tag_attrs(__('Jump to record by ID')).' href="javascript:void(0);" onclick="jump_to_record_id(\''.$this->tab.'\')"><img border="0" src="'.Base_ThemeCommon::get_template_file('Utils_RecordBrowser','jump_to.png').'"></a><input type="text" id="jump_to_record_input" style="display:none;width:50px;" onkeypress="if(event.keyCode==13)'.$link.'">';
}
public function applet($conf, &$opts)
{
$categories = array();
$methods = DB::GetAssoc('SELECT id,callback FROM utils_watchdog_category');
foreach ($methods as $k => $v) {
$methods[$k] = explode('::', $v);
if (isset($conf['category_' . $k]) && $conf['category_' . $k] && is_numeric($k)) {
$categories[] = $k;
}
}
if (empty($categories)) {
print __('No category selected');
return;
}
$records_limit = isset($conf['records_limit']) ? $conf['records_limit'] : 15;
if ($records_limit == '__all__') {
$records_limit = null;
}
$header = array(array('name' => __('Cat.'), 'width' => 5), array('name' => __('Title'), 'width' => 15));
if (count($categories) == 1) {
$title = call_user_func($methods[$categories[0]]);
$opts['title'] = __('Watchdog - %s', array($title['category']));
$header = array(array('name' => __('Title')));
} elseif (count($categories) == count($methods)) {
$opts['title'] = __('Watchdog - All');
} else {
$opts['title'] = __('Watchdog - Selection');
}
$only_new = ' AND last_seen_event<(SELECT MAX(id) FROM utils_watchdog_event AS uwe WHERE uwe.internal_id=uws.internal_id AND uwe.category_id=uws.category_id)';
$records = DB::GetAll('SELECT internal_id,category_id FROM utils_watchdog_subscription AS uws WHERE user_id=%d ' . $only_new . 'AND category_id IN (' . implode(',', $categories) . ')', array(Acl::get_user()));
$gb = $this->init_module(Utils_GenericBrowser::module_name(), 'subscriptions', 'subscriptions');
$gb->set_table_columns($header);
$something_to_purge = false;
$count = 0;
foreach ($records as $rec_key => $w) {
$k = $w['internal_id'];
$v = $w['category_id'];
$changes = Utils_WatchdogCommon::check_if_notified($v, $k);
if (!is_array($changes)) {
$changes = array();
}
$data = call_user_func($methods[$v], $k, $changes);
if ($data == null) {
// mark events as seen when user can't see them
Utils_WatchdogCommon::notified($v, $k);
unset($records[$rec_key]);
continue;
}
$gb_row = $gb->get_new_row();
if (count($categories) == 1) {
$gb_row->add_data($data['title']);
} else {
$gb_row->add_data($data['category'], $data['title']);
}
$gb_row->add_action(Utils_WatchdogCommon::get_confirm_change_subscr_href($v, $k), 'Stop Watching', __('Click to stop watching this record for changes'), Base_ThemeCommon::get_template_file(Utils_Watchdog::module_name(), 'watching_small_new_events.png'));
$gb_row->add_action($data['view_href'], 'View');
if ($only_new || Utils_WatchdogCommon::check_if_notified($v, $k) !== true) {
$gb_row->set_attrs('name="watchdog_table_row_' . $v . '__' . $k . '"');
load_js('modules/Utils/Watchdog/applet_mark_as_read.js');
$gb_row->add_action('href="javascript:void(0);" onclick="watchdog_applet_mark_as_read(\'' . $v . '__' . $k . '\')"', 'Mark as Read', __('Mark as read'), Base_ThemeCommon::get_template_file(Utils_Watchdog::module_name(), 'mark_as_read.png'));
$something_to_purge = true;
}
if (isset($data['events']) && $data['events']) {
$gb_row->add_info($data['events'], true);
}
$count++;
if ($records_limit && $count >= $records_limit) {
break;
}
}
$records_qty = count($records);
if ($records_limit && $count < $records_qty) {
print __('Displaying %s of %s records', array($count, $records_qty));
}
$this->set_module_variable('display_at_time', time());
if ($something_to_purge) {
$opts['actions'][] = '<a ' . Utils_TooltipCommon::open_tag_attrs(__('Mark all entries as read')) . ' ' . $this->create_confirm_callback_href(__('This will mark all entries in selected categories as read, are you sure you want to continue?'), array($this, 'purge_subscriptions_applet'), array($categories)) . '><img src="' . Base_ThemeCommon::get_template_file('Utils_Watchdog', 'purge.png') . '" border="0"></a>';
}
$this->display_module($gb);
}
public function applet() {
$gb = $this->init_module('Utils/GenericBrowser', null, 'agenda');
$columns = array(
array('name'=>__('Done'), 'order'=>'done', 'width'=>5),
array('name'=>__('Start'), 'order'=>'alert_on', 'width'=>15),
array('name'=>__('Info'), 'width'=>80)
);
$gb->set_table_columns($columns);
$gb->set_default_order(array(__('Start')=>'ASC'));
$this->lp = $this->init_module('Utils_LeightboxPrompt');
$this->lp->add_option('holdon_'.(5*60), __('5 minutes'),null);
$this->lp->add_option('holdon_'.(15*60), __('15 minutes'),null);
$this->lp->add_option('holdon_'.(30*60), __('30 minutes'),null);
$this->lp->add_option('holdon_'.(60*60), __('1 hour'),null);
$this->lp->add_option('holdon_'.(240*60), __('4 hours'),null);
$this->lp->add_option('holdon_'.(12*3600), __('12 hours'),null);
$this->lp->add_option('holdon_'.(24*3600), __('24 hours'),null);
$this->display_module($this->lp, array('Hold on', array('alert_id'), '', false));
$vals = $this->lp->export_values();
if ($vals) {
if(preg_match('/^holdon_([0-9]+)$/',$vals['option'],$reqs)) {
$_SESSION['utils_messenger_holdon'][$vals['params']['alert_id']] = time()+$reqs[1];
}
}
$t = time();
// postgres compatible interval with type cast
$interval = DB::is_postgresql() ? '::timestamp - interval \'1 hour\'' : '-INTERVAL 1 hour';
$ret = DB::Execute('(SELECT u.done,m.* FROM utils_messenger_message m INNER JOIN utils_messenger_users u ON u.message_id=m.id WHERE u.user_login_id=%d AND u.done=0 AND m.alert_on<%T)'.
' UNION '.
'(SELECT u.done,m.* FROM utils_messenger_message m INNER JOIN utils_messenger_users u ON u.message_id=m.id WHERE u.user_login_id=%d AND m.alert_on<%T AND u.done_on>=%T'.$interval.' AND u.done=1 ORDER BY m.alert_on DESC LIMIT 3)'.
' UNION '.
'(SELECT 0 as done,m.* FROM utils_messenger_message m INNER JOIN utils_messenger_users u ON u.message_id=m.id WHERE u.user_login_id=%d AND m.alert_on>=%T ORDER BY m.alert_on ASC LIMIT 5)'.$gb->get_query_order(),array(Acl::get_user(),$t,Acl::get_user(),$t,$t,Acl::get_user(),$t));
while($row = $ret->FetchRow()) {
$info = call_user_func_array(unserialize($row['callback_method']),unserialize($row['callback_args']));
$info = str_replace("\n",'<br>',$info);
$alert_on = Base_RegionalSettingsCommon::time2reg($row['alert_on']);
$gb->add_row(($row['done']?'<span class="checkbox_on" />':'<a '.Utils_TooltipCommon::open_tag_attrs(__('Turn off alarm')).' '.$this->create_confirm_callback_href(__('Are you sure you want to turn off the alarm?'),array('Utils_MessengerCommon','turn_off'),array($row['id'])).'><span class="checkbox_off" /></a>'),
(($row['done'] || $row['alert_on']>$t)?$alert_on:'<a '.Utils_TooltipCommon::open_tag_attrs(__('Hold on')).' '.$this->lp->get_href(array($row['id'])).'>'.$alert_on.'</a>'),
$info.'<br>'.($row['message']?__('Alarm comment: %s',array($row['message'])):''));
}
$this->display_module($gb);
}
/**
* Displays the table.
*
* @param string template file that should be used to display the table, use Base_ThemeCommon::get_template_filename() for proper filename
* @param bool enabling paging, true by default
*/
public function body($template=null,$paging=true){
if(!$this->columns) trigger_error('columns array empty, please call set_table_columns',E_USER_ERROR);
$md5_id = md5($this->get_path());
$this->set_module_variable('first_display','done');
$theme = $this->init_module('Base/Theme');
$per_page = $this->get_module_variable('per_page');
$order = $this->get_module_variable('order');
$this->expandable = $this->get_module_variable('expandable',$this->expandable);
$expand_action_only = false;
if ($this->expandable) {
if(!$this->en_actions) {
$expand_action_only = true;
$this->en_actions = true;
}
}
if ($this->en_actions) $actions_position = Base_User_SettingsCommon::get('Utils/GenericBrowser','actions_position');
$ch_adv_search = $this->get_unique_href_variable('adv_search');
if (isset($ch_adv_search)) {
$this->set_module_variable('adv_search',$ch_adv_search);
$this->set_module_variable('search',array());
location(array());
}
$search = $this->get_module_variable('search');
$renderer = new HTML_QuickForm_Renderer_TCMSArraySmarty();
$form_p = $this->init_module('Libs/QuickForm');
$pager_on = false;
if(isset($this->rows_qty) && $paging) {
if(!$this->forced_per_page) {
$form_p->addElement('select','per_page',__('Number of rows per page'), Utils_GenericBrowserCommon::$possible_vals_for_per_page, 'onChange="'.$form_p->get_submit_form_js(false).'"');
$form_p->setDefaults(array('per_page'=>$per_page));
}
$qty_pages = ceil($this->rows_qty/$this->per_page);
if ($qty_pages<=25) {
$pages = array();
if($this->rows_qty==0)
$pages[0] = 1;
else
foreach (range(1, $qty_pages) as $v) $pages[$v] = $v;
$form_p->addElement('select','page',__('Page'), $pages, 'onChange="'.$form_p->get_submit_form_js(false).'"');
$form_p->setDefaults(array('page'=>(int)(ceil($this->offset/$this->per_page)+1)));
} else {
$form_p->addElement('text','page',__('Page (%s to %s)', array(1,$qty_pages)), array('onclick'=>'this.focus();this.select();', 'onChange'=>$form_p->get_submit_form_js(false), 'style'=>'width:'.(7*strlen($qty_pages)).'px;'));
$form_p->setDefaults(array('page'=>(int)(ceil($this->offset/$this->per_page)+1)));
}
$pager_on = true;
}
$search_on=false;
if(!$this->is_adv_search_on()) {
foreach($this->columns as $k=>$v)
if (isset($v['search'])) {
$this->form_s->addElement('text','search',__('Keyword'), array('id'=>'gb_search_field', 'placeholder'=>__('search keyword...'), 'x-webkit-speech'=>'x-webkit-speech', 'lang'=>Base_LangCommon::get_lang_code(), 'onwebkitspeechchange'=>$this->form_s->get_submit_form_js()));
$this->form_s->setDefaults(array('search'=>isset($search['__keyword__'])?$search['__keyword__']:''));
$search_on=true;
break;
}
} else {
$search_fields = array();
if ($this->en_actions && $actions_position==0) $mov = 1;
else $mov=0;
foreach($this->columns as $k=>$v) {
if(isset($v['display']) && !$v['display']) {
$mov--;
continue;
}
if (isset($v['search'])) {
$this->form_s->addElement('hidden','search__'.$v['search'],'');
$default = isset($search[$v['search']])?$search[$v['search']]:'';
$this->form_s->setDefaults(array('search__'.$v['search']=>$default));
$in = '<input value="'.$default.'" x-webkit-speech="x-webkit-speech" lang="'.Base_LangCommon::get_lang_code().'" name="search__textbox_'.$v['search'].'" placeholder="'.__('search keyword...').'" onblur="document.forms[\''.$this->form_s->getAttribute('name').'\'].search__'.$v['search'].'.value = this.value;" onkeydown="if (event.keyCode==13) {document.forms[\''.$this->form_s->getAttribute('name').'\'].search__'.$v['search'].'.value = this.value;'.$this->form_s->get_submit_form_js().';}" />';
$search_fields[$k+$mov] = $in;
$search_on=true;
}
}
$theme->assign('search_fields', $search_fields);
}
if ($search_on) {
$this->form_s->addElement('submit','submit_search',__('Search'), array('id'=>'gb_search_button'));
if (Base_User_SettingsCommon::get($this->get_type(), 'show_all_button')) {
$el = $this->form_s->addElement('hidden','show_all_pressed');
$this->form_s->addElement('button','show_all',__('Show all'), array('onclick'=>'document.forms["'.$this->form_s->getAttribute('name').'"].show_all_pressed.value="1";'.$this->form_s->get_submit_form_js()));
$el->setValue('0');
}
}
if ($pager_on) {
$form_p->accept($renderer);
$form_array = $renderer->toArray();
$theme->assign('form_data_paging', $form_array);
$theme->assign('form_name_paging', $form_p->getAttribute('name'));
// form processing
if($form_p->validate()) {
$values = $form_p->exportValues();
if(isset($values['per_page'])) {
$this->set_module_variable('per_page',$values['per_page']);
Base_User_SettingsCommon::save('Utils/GenericBrowser','per_page',$values['per_page']);
}
if(isset($values['page']) && is_numeric($values['page']) && ($values['page']>=1 && $values['page']<=$qty_pages)) {
$this->set_module_variable('offset',($values['page']-1)*$this->per_page);
}
location(array());
return;
}
}
if ($search_on) {
$this->form_s->accept($renderer);
$form_array = $renderer->toArray();
$theme->assign('form_data_search', $form_array);
$theme->assign('form_name_search', $this->form_s->getAttribute('name'));
// form processing
if($this->form_s->validate()) {
$values = $this->form_s->exportValues();
if (isset($values['show_all_pressed']) && $values['show_all_pressed']) {
$this->set_module_variable('search',array());
$this->set_module_variable('show_all_triggered',true);
location(array());
return;
}
$search = array();
foreach ($values as $k=>$v){
if ($k=='search') {
if ($v!=__('search keyword...') && $v!='')
$search['__keyword__'] = $v;
break;
}
if (substr($k,0,8)=='search__') {
$val = substr($k,8);
if ($v!=__('search keyword...') && $v!='') $search[$val] = $v;
}
}
$this->set_module_variable('search',$search);
location(array());
return;
}
}
$headers = array();
if ($this->en_actions) {
$max_actions = 0; // Possibly improve it to calculate it during adding actions
foreach($this->actions as $i=>$v) {
$this_width = 0;
foreach ($v as $vv) {
$this_width += $vv['size'];
}
if ($this_width>$max_actions) $max_actions = $this_width;
}
if ($actions_position==0) $headers[-1] = array('label'=>'<span>'.' '.'</span>','attrs'=>'style="width: '.($max_actions*16+6).'px;" class="Utils_GenericBrowser__actions"');
else $headers[count($this->columns)] = array('label'=>'<span>'.' '.'</span>','attrs'=>'style="width: '.($max_actions*16+6).'px;" class="Utils_GenericBrowser__actions"');
}
$all_width = 0;
foreach($this->columns as $k=>$v) {
if (!isset($this->columns[$k]['width'])) $this->columns[$k]['width'] = 100;
if (!is_numeric($this->columns[$k]['width'])) continue;
$all_width += $this->columns[$k]['width'];
if (isset($v['quickjump'])) {
$quickjump = $this->set_module_variable('quickjump',$v['quickjump']);
$quickjump_col = $k;
}
}
$i = 0;
$is_order = false;
$adv_history = Base_User_SettingsCommon::get('Utils/GenericBrowser','adv_history');
foreach($this->columns as $v) {
if (array_key_exists('display', $v) && $v['display']==false) {
$i++;
continue;
}
if(isset($v['order'])) $is_order = true;
if(!isset($headers[$i])) $headers[$i] = array('label'=>'');
if (!$adv_history && $v['name'] && $v['name']==$order[0]['column']) $label = '<span style="padding-right: 12px; margin-right: 12px; background-image: url('.Base_ThemeCommon::get_template_file('Utils_GenericBrowser','sort-'.strtolower($order[0]['direction']).'ending.png').'); background-repeat: no-repeat; background-position: right;">'.$v['name'].'</span>';
else $label = $v['name'];
$headers[$i]['label'] .= (isset($v['preppend'])?$v['preppend']:'').(isset($v['order'])?'<a '.$this->create_unique_href(array('change_order'=>$v['name'])).'>' . $label . '</a>':$label).(isset($v['append'])?$v['append']:'');
//if ($v['search']) $headers[$i] .= $form_array['search__'.$v['search']]['label'].$form_array['search__'.$v['search']]['html'];
if ($this->absolute_width) {
$headers[$i]['attrs'] = 'width="'.$v['width'].'" ';
} elseif (!is_numeric($v['width'])) {
$headers[$i]['attrs'] = 'style="width:'.$v['width'].'" ';
} else {
$headers[$i]['attrs'] = 'width="'.intval(100*$v['width']/$all_width).'%" ';
}
$headers[$i]['attrs'] .= 'nowrap="1" ';
if (isset($v['attrs'])) $headers[$i]['attrs'] .= $v['attrs'].' ';
$i++;
}
ksort($headers);
$out_headers = array_values($headers);
unset($headers);
$out_data = array();
if($this->expandable) {
eval_js_once('gb_expandable["'.$md5_id.'"] = {};');
eval_js_once('gb_expanded["'.$md5_id.'"] = 0;');
eval_js_once('gb_expand_icon = "'.Base_ThemeCommon::get_template_file('Utils/GenericBrowser', 'expand.gif').'";');
eval_js_once('gb_collapse_icon = "'.Base_ThemeCommon::get_template_file('Utils/GenericBrowser', 'collapse.gif').'";');
eval_js_once('gb_expand_icon_off = "'.Base_ThemeCommon::get_template_file('Utils/GenericBrowser', 'expand_gray.gif').'";');
eval_js_once('gb_collapse_icon_off = "'.Base_ThemeCommon::get_template_file('Utils/GenericBrowser', 'collapse_gray.gif').'";');
}
foreach($this->rows as $i=>$r) {
$col = array();
if($this->expandable) {
$row_id = $md5_id.'_'.$i;
$this->__add_row_action($i,'style="display:none;" href="javascript:void(0)" onClick="gb_expand(\''.$md5_id.'\',\''.$i.'\')" id="gb_more_'.$row_id.'"','Expand', null, Base_ThemeCommon::get_template_file('Utils/GenericBrowser', 'plus_gray.png'), 1001);
$this->__add_row_action($i,'style="display:none;" href="javascript:void(0)" onClick="gb_collapse(\''.$md5_id.'\',\''.$i.'\')" id="gb_less_'.$row_id.'"','Collapse', null, Base_ThemeCommon::get_template_file('Utils/GenericBrowser', 'minus_gray.png'), 1001, false, 0);
$this->__add_row_js($i,'gb_expandable_init("'.Epesi::escapeJS($md5_id,true,false).'","'.Epesi::escapeJS($i,true,false).'")');
if(!isset($this->row_attrs[$i])) $this->row_attrs[$i]='';
$this->row_attrs[$i] .= 'id="gb_row_'.$row_id.'"';
}
if ($this->en_actions) {
if ($actions_position==0) $column_no = -1;
else $column_no = count($this->columns);
$col[$column_no]['attrs'] = '';
if (!empty($this->actions[$i])) {
uasort($this->actions[$i], array($this,'sort_actions'));
$actions = '';
foreach($this->actions[$i] as $icon=>$arr) {
$actions .= '<a '.Utils_TooltipCommon::open_tag_attrs($arr['tooltip']!==null?$arr['tooltip']:$arr['label'], $arr['tooltip']===null).' '.$arr['tag_attrs'].'>';
if ($icon=='view' || $icon=='delete' || $icon=='edit' || $icon=='info' || $icon=='restore' || $icon=='append data' || $icon=='active-on' || $icon=='active-off' || $icon=='history' || $icon=='move-down' || $icon=='move-up' || $icon=='history_inactive' || $icon=='print' || $icon == 'move-up-down') {
$actions .= '<img class="action_button" src="'.Base_ThemeCommon::get_template_file('Utils/GenericBrowser',$icon.($arr['off']?'-off':'').'.png').'" border="0">';
} elseif(file_exists($icon)) {
$actions .= '<img class="action_button" src="'.$icon.'" border="0">';
} else {
$actions .= $arr['label'];
}
$actions .= '</a>';
}
$col[$column_no]['label'] = $actions;
$col[$column_no]['attrs'] .= ' class="Utils_GenericBrowser__actions Utils_GenericBrowser__td"';
// Add overflow_box to actions
$settings = Base_User_SettingsCommon::get('Utils_GenericBrowser', 'zoom_actions');
if ($settings==2 || ($settings==1 && detect_iphone()))
$col[$column_no]['attrs'] .= ' onmouseover="if(typeof(table_overflow_show)!=\'undefined\')table_overflow_show(this,true);"';
} else {
$col[$column_no]['label'] = ' ';
$col[$column_no]['attrs'] .= 'nowrap="nowrap"'.' class="Utils_GenericBrowser__td"';
}
if (isset($this->no_actions[$i]))
$col[$column_no]['attrs'] .= ' style="display:none;"';
}
foreach($r as $k=>$v) {
if (is_array($v) && isset($v['dummy'])) $v['style'] = 'display:none;';
if (array_key_exists('display',$this->columns[$k]) && $this->columns[$k]['display']==false) continue;
if (is_array($v) && isset($v['attrs'])) $col[$k]['attrs'] = $v['attrs'];
else $col[$k]['attrs'] = '';
if ($this->absolute_width) $col[$k]['attrs'] .= ' width="'.$this->columns[$k]['width'].'"';
if (!is_array($v)) $v = array('value'=>$v);
$col[$k]['label'] = $v['value'];
if (!isset($v['overflow_box']) || $v['overflow_box']) {
$col[$k]['attrs'] .= ' onmouseover="if(typeof(table_overflow_show)!=\'undefined\')table_overflow_show(this);"';
} else {
if (!isset($v['style'])) $v['style'] = '';
$v['style'] .= 'white-space: normal;';
}
$col[$k]['attrs'] .= ' class="Utils_GenericBrowser__td '.(isset($v['class'])?$v['class']:'').'"';
$col[$k]['attrs'] .= isset($v['style'])? ' style="'.$v['style'].'"':'';
if (isset($quickjump_col) && $k==$quickjump_col) $col[$k]['attrs'] .= ' class="Utils_GenericBrowser__quickjump"';
if ((!isset($this->columns[$k]['wrapmode']) || $this->columns[$k]['wrapmode']!='cut') && isset($v['hint'])) $col[$k]['attrs'] .= ' title="'.$v['hint'].'"';
$col[$k]['attrs'] .= (isset($this->columns[$k]['wrapmode']) && $this->columns[$k]['wrapmode']=='nowrap')?' nowrap':'';
if ($all_width!=0)
$max_width = 130*$this->columns[$k]['width']/$all_width*(7+(isset($this->columns[$k]['fontsize'])?$this->columns[$k]['fontsize']:0));
else
$max_width = 0;
if (isset($this->columns[$k]['wrapmode']) && $this->columns[$k]['wrapmode']=='cut'){
if (strlen($col[$k]['label'])>$max_width){
if (is_array($v) && isset($v['hint'])) $col[$k]['attrs'] .= ' title="'.$col[$k]['label'].': '.$v['hint'].'"';
else $col[$k]['attrs'] .= ' title="'.$col[$k]['label'].'"';
$col[$k]['label'] = substr($col[$k]['label'],0,$max_width-3).'...';
} elseif (is_array($v) && isset($v['hint'])) $col[$k]['attrs'] .= ' title="'.$v['hint'].'"';
$col[$k]['attrs'] .= ' nowrap';
}
}
ksort($col);
$expanded = $this->expandable ? ' expanded' : '';
foreach($col as $v)
$out_data[] = array('label'=>'<div class="expandable'.$expanded.'">'.$v['label'].'</div>','attrs'=>$v['attrs']);
if(isset($this->rows_jses[$i]))
eval_js($this->rows_jses[$i]);
}
if (isset($quickjump)) {
$quickjump_to = $this->get_module_variable('quickjump_to');
$all = '<span class="all">'.__('All').'</span>';
if (isset($quickjump_to) && $quickjump_to != '') $all = '<a class="all" '.$this->create_unique_href(array('quickjump_to'=>'')).'>'.__('All').'</a>';
$letter_links = array(0 => $all);
if ($quickjump_to != '0')
$letter_links[] .= '<a class="all" '.$this->create_unique_href(array('quickjump_to'=>'0')).'>'.'123'.'</a>';
else
$letter_links[] .= '<span class="all">' . '123' . '</span>';
$letter = 'A';
while ($letter<='Z') {
if ($quickjump_to != $letter)
$letter_links[] .= '<a class="letter" '.$this->create_unique_href(array('quickjump_to'=>$letter)).'>'.$letter.'</a>';
else
$letter_links[] .= '<span class="letter">' . $letter . '</span>';
$letter = chr(ord($letter)+1);
}
$theme->assign('letter_links', $letter_links);
$theme->assign('quickjump_to', $quickjump_to);
}
$theme->assign('data', $out_data);
$theme->assign('cols', $out_headers);
$theme->assign('row_attrs', $this->row_attrs);
$theme->assign('table_id','table_'.$md5_id);
if($expand_action_only) {
eval_js('gb_expandable_hide_actions("'.$md5_id.'")');
}
$theme->assign('table_prefix', $this->table_prefix);
$theme->assign('table_postfix', $this->table_postfix);
$theme->assign('summary', $this->summary());
$theme->assign('first', $this->gb_first());
$theme->assign('prev', $this->gb_prev());
$theme->assign('next', $this->gb_next());
$theme->assign('last', $this->gb_last());
$theme->assign('custom_label', $this->custom_label);
$theme->assign('custom_label_args', $this->custom_label_args);
if($this->expandable) {
$theme->assign('expand_collapse',array(
'e_label'=>__('Expand All'),
'e_href'=>'href="javascript:void(0);" onClick=\'gb_expand_all("'.$md5_id.'")\'',
'e_id'=>'expand_all_button_'.$md5_id,
'c_label'=>__('Collapse All'),
'c_href'=>'href="javascript:void(0);" onClick=\'gb_collapse_all("'.$md5_id.'")\'',
'c_id'=>'collapse_all_button_'.$md5_id
));
$max_actions = isset($max_actions) ? $max_actions : 0;
eval_js('gb_expandable_adjust_action_column("'.$md5_id.'", ' . $max_actions . ')');
eval_js('gb_show_hide_buttons("'.$md5_id.'")');
}
if ($search_on) $theme->assign('adv_search','<a id="switch_search_'.($this->is_adv_search_on()?'simple':'advanced').'" class="button" '.$this->create_unique_href(array('adv_search'=>!$this->is_adv_search_on())).'>' . ($this->is_adv_search_on()?__('Simple Search'):__('Advanced Search')) . ' <img src="' . Base_ThemeCommon::get_template_file($this -> get_type(), 'advanced.png') . '" width="8px" height="20px" border="0" style="vertical-align: middle;"></a>');
else $theme->assign('adv_search','');
if (Base_User_SettingsCommon::get('Utils/GenericBrowser','adv_history') && $is_order){
$theme->assign('reset', '<a '.$this->create_unique_href(array('action'=>'reset_order')).'>'.__('Reset Order').'</a>');
$theme->assign('order',$this->get_module_variable('order_history_display'));
}
$theme->assign('id',md5($this->get_path()));
if ($this->resizable_columns) {
load_js($this->get_module_dir().'js/col_resizable.js');
$fixed_col_setting = !empty($this->fixed_columns_selector)? ', skipColumnClass:"'.$this->fixed_columns_selector.'"':'';
eval_js('jq("#table_'.$md5_id.'").colResizable({liveDrag:true, postbackSafe:true, partialRefresh:true'.$fixed_col_setting.'});');
}
if(isset($template))
$theme->display($template,true);
else
$theme->display();
$this->set_module_variable('show_all_triggered',false);
}
public function display_dashboard($tab_id)
{
// Base_ActionBarCommon::add('add',__('Add applet'),$this->create_callback_href(array($this,'applets_list'),$tab_id));
$default_dash = $this->get_module_variable('default');
$colors = Base_DashboardCommon::get_available_colors();
$applets = array(0 => array(), 1 => array(), 2 => array());
$config_mode = $this->get_module_variable('config_mode', false);
if ($default_dash || !Base_DashboardCommon::has_permission_to_manage_applets()) {
$ret = DB::Execute('SELECT col,id,module_name,color FROM base_dashboard_default_applets WHERE tab=%d ORDER BY col,pos', array($tab_id));
} else {
$ret = DB::Execute('SELECT col,id,module_name,color FROM base_dashboard_applets WHERE user_login_id=%d AND tab=%d ORDER BY pos', array(Base_AclCommon::get_user(), $tab_id));
}
while ($row = $ret->FetchRow()) {
$applets[$row['col']][] = $row;
}
print '<div id="dashboard" style="width: 100%;">';
for ($j = 0; $j < 3; $j++) {
print '<div id="dashboard_applets_' . $tab_id . '_' . $j . '" style="width:33%;min-height:200px;padding-bottom:10px;vertical-align:top;display:inline-block">';
foreach ($applets[$j] as $row) {
if (!is_callable(array($row['module_name'] . 'Common', 'applet_caption'))) {
continue;
}
$cap = call_user_func(array($row['module_name'] . 'Common', 'applet_caption'));
if (!$cap || ModuleManager::is_installed($row['module_name']) == -1) {
//if its invalid entry
continue;
}
$m = $this->init_module($row['module_name'], null, $row['id']);
$opts = array();
$opts['title'] = $cap;
$opts['toggle'] = true;
$opts['href'] = null;
$opts['go'] = false;
$opts['go_function'] = 'body';
$opts['go_arguments'] = array();
$opts['go_constructor_arguments'] = array();
$opts['actions'] = array();
$opts['id'] = $row['id'];
$th = $this->init_module(Base_Theme::module_name());
if ($config_mode || !$m) {
$content = '';
} else {
$content = $this->get_html_of_module($m, array($this->get_values($row['id'], $row['module_name']), &$opts, $row['id']), 'applet');
}
$th->assign('content', '<div class="content">' . $content . '</div>');
$th->assign('handle_class', 'handle');
$th->assign('fixed', !($default_dash || Base_DashboardCommon::has_permission_to_manage_applets()));
if ($opts['toggle'] && !$config_mode) {
$th->assign('toggle', '<a class="toggle" ' . Utils_TooltipCommon::open_tag_attrs(__('Toggle')) . '>=</a>');
}
foreach ($opts['actions'] as $k => $v) {
if (!$v) {
unset($opts['actions'][$k]);
}
}
if ($opts['go']) {
$opts['href'] = $this->create_main_href($row['module_name'], $opts['go_function'], $opts['go_arguments'], $opts['go_constructor_arguments']);
}
if ($opts['href']) {
$th->assign('href', '<a class="href" ' . Utils_TooltipCommon::open_tag_attrs(__('Fullscreen')) . ' ' . $opts['href'] . '>G</a>');
}
if ($default_dash || Base_DashboardCommon::has_permission_to_manage_applets()) {
$th->assign('remove', Base_DashboardCommon::get_remove_applet_button($row['id'], $default_dash));
if (!$config_mode) {
$th->assign('configure', '<a class="configure" ' . Utils_TooltipCommon::open_tag_attrs(__('Configure')) . ' ' . $this->create_callback_href(array($this, 'configure_applet'), array($row['id'], $row['module_name'])) . '>c</a>');
}
}
$th->assign('caption', $opts['title']);
$th->assign('color', $colors[$row['color']]['class']);
$th->assign('actions', $opts['actions']);
$th->assign('config_mode', $config_mode);
print '<div class="applet" id="ab_item_' . $row['id'] . '">';
$th->display();
print '</div>';
}
print '</div>';
}
print '</div>';
}
public static function get_remove_applet_button($id, $default_dash)
{
return '<a class="remove" id="dashboard_remove_applet_' . $id . '" ' . (is_numeric($id) ? '' : 'style="display:none;" ') . Utils_TooltipCommon::open_tag_attrs(__('Remove')) . ' href="javascript:void(0);" onClick="if(confirm(\'' . __('Delete this applet?') . '\'))remove_applet(' . (is_numeric($id) ? $id : -1) . ',' . ($default_dash ? 1 : 0) . ');">x</a>';
}
public static function submit_attachment($values, $mode) {
static $new_values, $old_password;
switch ($mode) {
case 'browse':
if (isset($values['id']) && isset($values['crypted']) && $values['crypted'] == false) {
// store to mark as read. Do not mark it here, because
// we won't get red eye in the table view
self::$mark_as_read[] = $values['id'];
}
return $values;
case 'index':
if($values['crypted']) unset($values['note']);
return $values;
case 'adding':
$values['edited_on'] = time();
return $values;
case 'add':
case 'edit':
if(isset($values['__date'])) $values['edited_on'] = $values['__date'];
else $values['edited_on'] = time();
$crypted = 0;
$old_pass = ($mode=='edit' && isset($_SESSION['client']['cp'.$values['id']]))?$_SESSION['client']['cp'.$values['id']]:($mode=='add' && isset($values['clone_id']) && isset($_SESSION['client']['cp'.$values['clone_id']])?$_SESSION['client']['cp'.$values['clone_id']]:'');
if((is_array($values['crypted']) && isset($values['crypted']['crypted']) && $values['crypted']['crypted']) || (!is_array($values['crypted']) && $values['crypted'])) {
if(is_array($values['crypted']) && isset($values['crypted']['note_password'])) {
if($values['crypted']['note_password']=='*@#old@#*')
$values['crypted']['note_password'] = $old_pass;
}
$crypted = 1;
}
if(is_array($values['crypted']) && isset($values['crypted']['note_password']) && $mode=='edit' && $old_pass!=$values['crypted']['note_password']) {
//reencrypt old revisions
$old_notes = DB::GetAssoc('SELECT hd.edit_id,hd.old_value FROM utils_attachment_edit_history h INNER JOIN utils_attachment_edit_history_data hd ON h.id=hd.edit_id WHERE h.utils_attachment_id=%d AND hd.field="note"', array($values['id']));
foreach($old_notes as $old_id=>$old_note) {
if($old_pass!=='') $old_note = Utils_AttachmentCommon::decrypt($old_note,$old_pass);
if($old_note===false) continue;
if($crypted && $values['crypted']['note_password']) $old_note = Utils_AttachmentCommon::encrypt($old_note,$values['crypted']['note_password']);
if($old_note===false) continue;
DB::Execute('UPDATE utils_attachment_edit_history_data SET old_value=%s WHERE edit_id=%d AND field="note"',array($old_note,$old_id));
}
//file reencryption
$old_files = DB::GetCol('SELECT uaf.id as id FROM utils_attachment_file uaf WHERE uaf.attach_id=%d',array($values['id']));
foreach($old_files as $old_id) {
$filename = DATA_DIR.'/Utils_Attachment/'.$values['id'].'/'.$old_id;
$content = @file_get_contents($filename);
if($content===false) continue;
if($old_pass!=='') $content = Utils_AttachmentCommon::decrypt($content,$old_pass);
if($content===false) continue;
if($crypted && $values['crypted']['note_password']) $content = Utils_AttachmentCommon::encrypt($content,$values['crypted']['note_password']);
if($content===false) continue;
file_put_contents($filename,$content);
}
}
if($crypted) {
if(is_array($values['crypted']) && isset($values['crypted']['note_password'])) {
$values['note'] = Utils_AttachmentCommon::encrypt($values['note'],$values['crypted']['note_password']);
$values['note_password']=$values['crypted']['note_password'];
}
$values['crypted'] = 1;
} else {
$values['crypted'] = 0;
}
$new_values = $values;
break;
case 'cloning':
$values['clone_id']=$values['id'];
break;
case 'added':
if(isset($values['local']))
DB::Execute('INSERT INTO utils_attachment_local(attachment,local,func,args) VALUES(%d,%s,%s,%s)',array($values['id'],$values['local'],$values['func'],$values['args']));
$new_values = $values;
break;
case 'edit_changes':
if(isset($values['note']) && isset($values['crypted']) && $new_values['crypted']!=$values['crypted']) {
if($new_values['crypted'] && isset($new_values['note_password'])) {
$values['note'] = Utils_AttachmentCommon::encrypt($values['note'],$new_values['note_password']);
} elseif(!$new_values['crypted'] && isset($_SESSION['client']['cp'.$new_values['id']])) {
$values['note'] = Utils_AttachmentCommon::decrypt($values['note'],$_SESSION['client']['cp'.$new_values['id']]);
unset($_SESSION['client']['cp'.$new_values['id']]);
}
} elseif(isset($new_values['note_password']) && isset($old_password) && $new_values['note_password']!=$old_password) {
$values['note'] = Utils_AttachmentCommon::decrypt($values['note'],$old_password);
$values['note'] = Utils_AttachmentCommon::encrypt($values['note'],$new_values['note_password']);
}
break;
case 'view':
$ret = self::get_access($values['id']);
if(!$ret) print(__('Access denied'));
return $ret;
case 'display':
if(DB::GetOne('SELECT 1 FROM utils_attachment_file WHERE attach_id=%d',array($values['id']))) {
$ret = array();
$ret['new'] = array();
$ret['new']['crm_filter'] = '<a '.Utils_TooltipCommon::open_tag_attrs(__('File history')).' '.Module::create_href(array('file_history'=>1)).'>F</a>';
if (isset($_REQUEST['file_history']) && (!$values['crypted'] || isset($_SESSION['client']['cp'.$values['id']])))
Base_BoxCommon::push_module('Utils_Attachment','file_history',array($values));
// CRM_FiltersCommon::set_profile('c'.$values['id']);
return $ret;
}
break;
case 'delete':
if($values['crypted'] && !isset($_SESSION['client']['cp'.$values['id']])) {
Epesi::alert(__('Cannot delete encrypted note'));
return false;
}
$count_locals = DB::GetOne('SELECT count(DISTINCT local) FROM utils_attachment_local WHERE attachment=%d',array($values['id']));
if($count_locals>1) {
$is_local = false;
if(isset($_SESSION['client']['utils_attachment_group']))
$is_local = DB::GetOne('SELECT 1 FROM utils_attachment_local WHERE attachment=%d AND local=%s',array($values['id'],$_SESSION['client']['utils_attachment_group']));
if($is_local) {
DB::Execute('DELETE FROM utils_attachment_local WHERE attachment=%d AND local=%s',array($values['id'],$_SESSION['client']['utils_attachment_group']));
self::new_watchdog_event($_SESSION['client']['utils_attachment_group'], '-', $values['id']);
} else
Epesi::alert(__('This note is attached to multiple records - please go to record and delete note there.'));
location(array());
return false;
}
location(array());
return true;
}
switch($mode) {
case 'edit':
case 'added':
if(isset($values['note_password'])) {
$old_password = isset($_SESSION['client']['cp' . $values['id']])
? $_SESSION['client']['cp' . $values['id']] : '';
$_SESSION['client']['cp'.$values['id']] = $values['note_password'];
}
$note_id = $values['id'];
$files_dir = self::Instance()->get_data_dir().$note_id;
if(isset($values['delete_files']))
$deleted_files = array_filter(explode(';',$values['delete_files']));
else
$deleted_files = array();
foreach ($deleted_files as $k=>$v)
$deleted_files[$k] = intVal($v);
if($deleted_files) $deleted_files = array_combine($deleted_files,$deleted_files);
if($mode=='added' && isset($values['clone_id'])) { //on cloning
$locals = DB::Execute('SELECT local,func,args FROM utils_attachment_local WHERE attachment=%d',array($values['clone_id']));
while($local = $locals->FetchRow())
DB::Execute('INSERT INTO utils_attachment_local(attachment,local,func,args) VALUES(%d,%s,%s,%s)',array($note_id,$local['local'],$local['func'],$local['args']));
$clone_files = DB::GetAll('SELECT id,original,created_by,created_on FROM utils_attachment_file uaf WHERE uaf.attach_id=%d AND uaf.deleted=0', array($values['clone_id']));
foreach($clone_files as $file) {
$cf = self::Instance()->get_data_dir().$values['clone_id'].'/'.$file['id'];
if(!file_exists($cf)) continue;
if(!file_exists($files_dir))
mkdir($files_dir,0777,true);
DB::Execute('INSERT INTO utils_attachment_file (attach_id,deleted,original,created_by,created_on) VALUES(%d,0,%s,%d,%T)',array($note_id,$file['original'],$file['created_by'],$file['created_on']));
$new_file_id = DB::Insert_ID('utils_attachment_file','id');
if(isset($deleted_files[$file['id']])) $deleted_files[$file['id']] = $new_file_id;
$cf2 = $files_dir.'/'.$new_file_id;
copy($cf,$cf2);
if(isset($_SESSION['client']['cp'.$values['clone_id']]) && $_SESSION['client']['cp'.$values['clone_id']])
file_put_contents($cf2,Utils_AttachmentCommon::decrypt(file_get_contents($cf2),$_SESSION['client']['cp'.$values['clone_id']]));
if($values['crypted'])
file_put_contents($cf2,Utils_AttachmentCommon::encrypt(file_get_contents($cf2),$values['note_password']));
}
}
$current_files = DB::GetAssoc('SELECT id, id FROM utils_attachment_file uaf WHERE uaf.attach_id=%d AND uaf.deleted=0', array($note_id));
$remaining_files = $current_files;
foreach ($deleted_files as $k=>$v) {
if (!isset($remaining_files[$v])) unset($deleted_files[$k]);
else unset($remaining_files[$v]);
}
foreach ($deleted_files as $v)
DB::Execute('UPDATE utils_attachment_file SET deleted=1 WHERE id=%d', array($v));
if(isset($values['clipboard_files'])) {
$clipboard_files = array_filter(explode(';',$values['clipboard_files']));
foreach ($clipboard_files as $cf_id) {
$cf = DB::GetOne('SELECT filename FROM utils_attachment_clipboard WHERE id=%d', array($cf_id));
if($values['crypted'])
file_put_contents($cf,Utils_AttachmentCommon::encrypt(file_get_contents($cf),$values['note_password']));
Utils_AttachmentCommon::add_file($note_id, Acl::get_user(), __('clipboard').'.png', $cf);
}
}
$files = isset($_SESSION['client']['utils_attachment'][CID]['files'])?$_SESSION['client']['utils_attachment'][CID]['files']:array();
$_SESSION['client']['utils_attachment'][CID]['files'] = array();
foreach ($files as $f) {
$file_path = $f['path'];
$file_name = $f['name'];
if($values['crypted'])
file_put_contents($file_path,Utils_AttachmentCommon::encrypt(file_get_contents($file_path),$values['note_password']));
Utils_AttachmentCommon::add_file($note_id, Acl::get_user(), $file_name, $file_path);
}
$locals = DB::GetCol('SELECT local FROM utils_attachment_local WHERE attachment=%d',array($note_id));
foreach ($locals as $local) {
$param = explode('/', $local);
if (count($param) == 2 && preg_match('/^[1-9][0-9]*$/', $param[1])) {
$subscribers = Utils_WatchdogCommon::get_subscribers($param[0], $param[1]);
foreach ($subscribers as $user_id) {
Utils_WatchdogCommon::user_subscribe($user_id, 'utils_attachment', $note_id);
}
}
}
break;
}
return $values;
}
private function create_tooltip($ref_rec, $col, $value, $c = '')
{
if ($this->pdf) {
return '';
}
return Utils_TooltipCommon::open_tag_attrs(strip_tags($ref_rec) . '<hr>' . $col . '<br>' . ($c != '' ? $c . ': ' : '') . $value, false) . ' ';
}
protected function GB_row_data_transform_module_licenses(array $data)
{
// module name
if (isset($data['module'])) {
$data['module'] = $this->module_info_tooltip($data['module']);
}
// paid
if (isset($data['paid'])) {
if (!$data['paid']) {
$this->navigation_button_orders();
}
$data['paid'] = $data['paid'] ? __('Yes') : __('No - Go to orders to pay');
}
// active
if (isset($data['active'])) {
$text = $data['active'] ? __('Yes') : __('No');
$tip = $data['active'] ? __('You can download newer version if it\'s available') : __('You cannot download newer version');
$data['active'] = "<a " . Utils_TooltipCommon::open_tag_attrs($tip) . ">{$text}</a>";
}
return $data;
}
public function display_activities($events, $tasks, $phonecalls)
{
$gb = $this->init_module(Utils_GenericBrowser::module_name(), 'activities', 'activities');
$gb->set_table_columns(array(array('name' => __('Type'), 'wrapmode' => 'nowrap', 'width' => 8), array('name' => __('Subject'), 'width' => 20), array('name' => __('Date/Deadline'), 'wrapmode' => 'nowrap', 'width' => 8), array('name' => __('Employees'), 'width' => 11), array('name' => __('Customers'), 'width' => 11), array('name' => __('Attachments'), 'width' => 4)));
$amount = 0;
if ($this->display['events']) {
$amount += count($events);
}
if ($this->display['tasks']) {
$amount += count($tasks);
}
if ($this->display['phonecalls']) {
$amount += count($phonecalls);
}
$limit = $gb->get_limit($amount);
for ($i = 0; $i < $limit['offset'] + $limit['numrows'] && $i < $amount; $i++) {
if ($this->display['events'] && count($events)) {
$ev = current($events);
} else {
$ev = array('start' => -1);
}
if ($this->display['tasks'] && count($tasks)) {
$t = current($tasks);
if (!$t['deadline']) {
$t['deadline'] = 0;
} else {
$t['deadline'] = strtotime($t['deadline']);
}
} else {
$t = array('deadline' => -1);
}
if ($this->display['phonecalls'] && count($phonecalls)) {
$ph = current($phonecalls);
$ph['date_and_time'] = strtotime($ph['date_and_time']);
} else {
$ph = array('date_and_time' => -1);
}
$maxt = max($ev['start'], $t['deadline'], $ph['date_and_time']);
$gb_row = $gb->get_new_row();
if ($ev['start'] == $maxt) {
$v = array_shift($events);
if ($i >= $limit['offset'] && $v) {
if (isset($v['view_action'])) {
$view_href = $v['view_action'];
} else {
$view_href = $this->create_callback_href(array($this, 'view_event'), array($v['id']));
}
$title = '<a ' . $view_href . '>' . $v['title'] . '</a>';
if (isset($v['description']) && $v['description'] != '') {
$title = '<span ' . Utils_TooltipCommon::open_tag_attrs($v['description'], false) . '>' . $title . '</span>';
}
$gb_row->add_info(Utils_RecordBrowserCommon::get_html_record_info('crm_meeting', $v['id']));
$gb_row->add_data(__('Meeting'), $title, Base_RegionalSettingsCommon::time2reg($v['start'], $v['duration'] == -1 ? false : 2), CRM_ContactsCommon::display_contact(array('employees' => $v['employees']), false, array('id' => 'employees', 'param' => ';CRM_ContactsCommon::contact_format_no_company')), CRM_ContactsCommon::display_company_contact(array('customers' => $v['customers']), false, array('id' => 'customers', 'param' => ';::')), Utils_AttachmentCommon::count('crm_meeting/' . $v['id']));
}
} elseif ($t['deadline'] == $maxt) {
$v = array_shift($tasks);
$v = Utils_RecordBrowserCommon::filter_record_by_access('task', $v);
if ($i >= $limit['offset'] && $v) {
$gb_row->add_info(Utils_RecordBrowserCommon::get_html_record_info('task', $v['id']));
$gb_row->add_data(__('Task'), CRM_TasksCommon::display_title($v, false), !isset($v['deadline']) || !$v['deadline'] ? __('No deadline') : Base_RegionalSettingsCommon::time2reg($v['deadline'], false, true, false), CRM_ContactsCommon::display_contact($v, false, array('id' => 'employees', 'param' => ';CRM_ContactsCommon::contact_format_no_company')), CRM_ContactsCommon::display_company_contact($v, false, array('id' => 'customers')), Utils_AttachmentCommon::count('task/' . $v['id']));
}
} else {
$v = array_shift($phonecalls);
$v = Utils_RecordBrowserCommon::filter_record_by_access('phonecall', $v);
if ($i >= $limit['offset'] && $v) {
$gb_row->add_info(Utils_RecordBrowserCommon::get_html_record_info('phonecall', $v['id']));
$gb_row->add_data(__('Phonecall'), CRM_PhoneCallCommon::display_subject($v), Base_RegionalSettingsCommon::time2reg($v['date_and_time'], 2), CRM_ContactsCommon::display_contact($v, false, array('id' => 'employees', 'param' => ';CRM_ContactsCommon::contact_format_no_company')), CRM_PhoneCallCommon::display_contact_name($v, false), Utils_AttachmentCommon::count('phonecall/' . $v['id']));
}
}
}
$this->display_module($gb);
}
public static function display_contacts_with_notification($recordset, $record, $nolink, $desc)
{
$icon_on = Utils_TooltipCommon::open_tag_attrs(__('This person is up to date with all changes made to this record.')) . ' src="' . Base_ThemeCommon::get_template_file('Utils_Watchdog', 'watching_small.png') . '"';
$icon_off = Utils_TooltipCommon::open_tag_attrs(__('This person has notifications pending about changes made to this record.')) . ' src="' . Base_ThemeCommon::get_template_file('Utils_Watchdog', 'watching_small_new_events.png') . '"';
$icon_none = Utils_TooltipCommon::open_tag_attrs(__('This person is not watching this record.')) . ' src="' . Base_ThemeCommon::get_template_file('Utils_Watchdog', 'not_watching_small.png') . '"';
$v = $record[$desc['id']];
$def = '';
$first = true;
$param = explode(';', $desc['param']);
if (!is_array($v) && !is_numeric($v)) {
return $v;
}
if ($param[1] == '::') {
$callback = array('CRM_ContactsCommon', 'contact_format_default');
} else {
$callback = explode('::', $param[1]);
}
if (!is_array($v)) {
$v = array($v);
}
foreach ($v as $k => $w) {
if ($w == '') {
break;
}
if ($first) {
$first = false;
} else {
$def .= '<br>';
}
$contact = CRM_ContactsCommon::get_contact($w);
if (!$nolink) {
if ($contact['login'] == '') {
$icon = $icon_none;
} else {
$icon = Utils_WatchdogCommon::user_check_if_notified($contact['login'], $recordset, $record['id']);
if ($icon === null) {
$icon = $icon_none;
} elseif ($icon === true) {
$icon = $icon_on;
} else {
$icon = $icon_off;
}
}
$def .= '<img style="margin-right:4px;" ' . $icon . ' />';
}
$def .= Utils_RecordBrowserCommon::no_wrap(call_user_func($callback, $contact, $nolink));
}
if (!$def) {
$def = '---';
}
return $def;
}
public static function QFfield_select(&$form, $field, $label, $mode, $default, $desc, $rb_obj)
{
if (self::QFfield_static_display($form, $field, $label, $mode, $default, $desc, $rb_obj)) {
return;
}
$record = $rb_obj->record;
$comp = array();
$param = explode(';', $desc['param']);
$crits_callback = isset($param[1]) ? $param[1] : null;
$multi_adv_params_callback = isset($param[2]) ? explode('::', $param[2]) : null;
$multi_adv_params = array();
if (is_callable($multi_adv_params_callback)) {
$multi_adv_params = call_user_func($multi_adv_params_callback, $record);
}
// check multi_adv_params structure and fill empty values
if (!is_array($multi_adv_params)) {
$multi_adv_params = array();
}
if (!isset($multi_adv_params['order'])) {
$multi_adv_params['order'] = array();
}
if (!isset($multi_adv_params['cols'])) {
$multi_adv_params['cols'] = array();
}
if (!isset($multi_adv_params['format_callback'])) {
$multi_adv_params['format_callback'] = array();
}
$reference = explode('::', $param[0]);
$tab = $reference[0];
$columns = isset($reference[1]) ? $reference[1] : null;
if (!isset($columns)) {
trigger_error("Columns not set for field: {$field}");
}
if ($tab == '__COMMON__') {
$order = isset($reference[2]) ? $reference[2] : 'value';
$data = Utils_CommonDataCommon::get_translated_tree($columns, $order == 'key');
if (!is_array($data)) {
$data = array();
}
$comp = $comp + $data;
$rec_count = 0;
$label = Utils_RecordBrowserCommon::get_field_tooltip($label, 'commondata', $columns);
} else {
if (isset($crits_callback)) {
$crit_callback = explode('::', $crits_callback);
if (is_callable($crit_callback)) {
$crits = call_user_func($crit_callback, false, $record);
$adv_crits = call_user_func($crit_callback, true, $record);
} else {
$crits = $adv_crits = array();
}
if ($adv_crits === $crits) {
$adv_crits = null;
}
if ($adv_crits !== null) {
$crits = $adv_crits;
}
} else {
$crits = array();
}
if ($tab == '__RECORDSETS__') {
$tabs = DB::GetCol('SELECT tab FROM recordbrowser_table_properties');
} else {
$tabs = explode(',', $tab);
}
$single_tab = count($tabs) == 1;
if (!$single_tab && empty($crits)) {
foreach ($tabs as $tab) {
$crits[$tab] = array();
}
}
// get related records with proper columns
$col_id = array();
if ($single_tab) {
$columns = array_filter(explode('|', $columns));
foreach ($columns as $c) {
$col_id[] = self::get_field_id($c);
}
}
$rec_count = 0;
foreach ($tabs as $t) {
if (!empty($crits) && !$single_tab && !isset($crits[$t])) {
continue;
}
$rec_count += Utils_RecordBrowserCommon::get_records_count($t, $single_tab ? $crits : $crits[$t], null);
}
if ($rec_count <= Utils_RecordBrowserCommon::$options_limit) {
$records = array();
foreach ($tabs as $t) {
if (!empty($crits) && !$single_tab && !isset($crits[$t])) {
continue;
}
$access = self::get_access($t, 'selection', null, true);
if ($access === false) {
continue;
}
if ($access !== true && is_array($access)) {
if ($single_tab) {
$crits = self::merge_crits($crits, $access);
} elseif (isset($crits[$t]) && is_array($crits[$t]) && $crits[$t]) {
$crits[$t] = self::merge_crits($crits[$t], $access);
} else {
$crits[$t] = $access;
}
}
$records_tmp = Utils_RecordBrowserCommon::get_records($t, $single_tab ? $crits : $crits[$t], array(), !empty($multi_adv_params['order']) ? $multi_adv_params['order'] : array());
foreach ($records_tmp as $key => $rec) {
if (!self::get_access($t, 'view', $rec)) {
continue;
}
$records[($single_tab ? '' : $t . '/') . $key] = $rec;
}
}
} else {
$records = array();
}
// set current record field value to array
if (isset($record[$field])) {
if (!is_array($record[$field])) {
if ($record[$field] != '') {
$record[$field] = array($record[$field] => $record[$field]);
} else {
$record[$field] = array();
}
}
}
if ($default) {
if (!is_array($default)) {
$record[$field][$default] = $default;
} else {
foreach ($default as $v) {
$record[$field][$v] = $v;
}
}
}
$ext_rec = array();
$columns_qty = count($col_id);
if (isset($record[$field])) {
$ext_rec = array_flip($record[$field]);
foreach ($ext_rec as $k => $v) {
$kk = explode('/', $k, 2);
if (count($kk) == 1) {
if ($single_tab && is_numeric($kk[0])) {
$t = $tab;
$record_id = $kk[0];
} else {
continue;
}
} else {
$t = $kk[0];
$record_id = $kk[1];
if (!self::check_table_name($t, false, false) || !is_numeric($record_id)) {
continue;
}
}
$c = Utils_RecordBrowserCommon::get_record($t, $record_id);
if (!empty($multi_adv_params['format_callback'])) {
$n = call_user_func($multi_adv_params['format_callback'], $c);
} else {
if ($columns_qty == 0) {
$n = self::create_default_linked_label($t, $record_id, true);
} elseif ($columns_qty == 1) {
$n = self::get_val($t, $col_id[0], $c, true);
} else {
$n = array();
foreach ($col_id as $cid) {
$n[] = self::get_val($t, $cid, $c, true);
}
$n = implode(' ', $n);
}
}
$comp[($single_tab ? '' : $t . '/') . $record_id] = $n;
}
}
// if (!empty($multi_adv_params['order']))
// natcasesort($comp);
foreach ($records as $k => $v) {
if (!empty($multi_adv_params['format_callback'])) {
$n = call_user_func($multi_adv_params['format_callback'], $v);
} else {
if ($single_tab && is_numeric($k)) {
$t = $tab;
$record_id = $k;
} else {
$kk = explode('/', $k, 2);
$t = $kk[0];
$record_id = $kk[1];
}
if ($columns_qty == 0) {
$n = self::create_default_linked_label($t, $record_id, true);
} elseif ($columns_qty == 1) {
$n = self::get_val($t, $col_id[0], $v, true);
} else {
$n = array();
foreach ($col_id as $cid) {
$n[] = self::get_val($t, $cid, $v, true);
}
$n = implode(' ', $n);
}
}
$comp[$k] = $n;
unset($ext_rec[$v['id']]);
unset($ext_rec[$k]);
}
if (empty($multi_adv_params['order'])) {
natcasesort($comp);
}
if ($single_tab) {
$label = Utils_RecordBrowserCommon::get_field_tooltip($label, $desc['type'], reset($tabs), $crits);
}
}
if ($rec_count > Utils_RecordBrowserCommon::$options_limit) {
$f_callback = $multi_adv_params['format_callback'];
if (empty($f_callback)) {
$f_callback = array('Utils_RecordBrowserCommon', 'autoselect_label');
}
if ($desc['type'] == 'multiselect') {
$el = $form->addElement('automulti', $field, $label, array('Utils_RecordBrowserCommon', 'automulti_suggestbox'), array($rb_obj->tab, $crits, $f_callback, $desc['param']), $f_callback);
if ($single_tab) {
${'rp_' . $field} = $rb_obj->init_module(Utils_RecordBrowser_RecordPicker::module_name(), array());
$filters_defaults = isset($multi_adv_params['filters_defaults']) ? $multi_adv_params['filters_defaults'] : array();
$rb_obj->display_module(${'rp_' . $field}, array($tab, $field, $multi_adv_params['format_callback'], $crits, array(), array(), array(), $filters_defaults));
$el->set_search_button('<a ' . ${'rp_' . $field}->create_open_href() . ' ' . Utils_TooltipCommon::open_tag_attrs(__('Advanced Selection')) . ' href="javascript:void(0);"><img border="0" src="' . Base_ThemeCommon::get_template_file('Utils_RecordBrowser', 'icon_zoom.png') . '"></a>');
}
} else {
$form->addElement('autoselect', $field, $label, $comp, array(array('Utils_RecordBrowserCommon', 'automulti_suggestbox'), array($rb_obj->tab, $crits, $f_callback, $desc['param'])), $f_callback);
}
} else {
if ($desc['type'] === 'select') {
$comp = array('' => '---') + $comp;
}
$form->addElement($desc['type'], $field, $label, $comp, array('id' => $field));
}
if ($mode !== 'add') {
$form->setDefaults(array($field => $default));
}
}
public function simple_setup()
{
Base_ActionBarCommon::add('settings', __('Advanced view'), $this->create_confirm_callback_href(__('Switch to advanced view?'), array($this, 'switch_simple'), false));
$module_dirs = $this->get_module_dirs();
$is_required = ModuleManager::required_modules(true);
$structure = array();
foreach ($module_dirs as $entry => $versions) {
$installed = ModuleManager::is_installed($entry);
$module_install_class = $entry . 'Install';
$func_simple = array($module_install_class, 'simple_setup');
if (is_callable($func_simple)) {
$simple_module = call_user_func($func_simple);
} else {
$simple_module = false;
}
if ($simple_module === false) {
continue;
}
if ($simple_module === true) {
$simple_module = array('package' => __('Uncategorized'), 'option' => $entry);
}
if (is_string($simple_module)) {
$simple_module = array('package' => $simple_module);
}
if (!isset($simple_module['option'])) {
$simple_module['option'] = null;
}
$simple_module['module'] = $entry;
$simple_module['installed'] = $installed >= 0;
$simple_module['key'] = $simple_module['package'] . ($simple_module['option'] ? '|' . $simple_module['option'] : '');
$structure[$entry] = $simple_module;
}
$packages = array();
foreach ($structure as $s) {
if (!isset($packages[$s['key']])) {
$packages[$s['key']] = array('also_uninstall' => array(), 'modules' => array(), 'is_required' => array(), 'installed' => null, 'icon' => false, 'version' => null, 'url' => null, 'core' => 0);
}
$package =& $packages[$s['key']];
$package['modules'][] = $s['module'];
$package['name'] = $s['package'];
$package['option'] = $s['option'];
if (isset($s['core'])) {
$package['core'] = $s['core'];
}
if ($package['installed'] === null) {
$package['installed'] = $s['installed'];
} else {
if ($s['installed'] && !$package['installed'] || !$s['installed'] && $package['installed']) {
$package['installed'] = 'partial';
}
}
if (!isset($is_required[$s['module']])) {
$is_required[$s['module']] = array();
}
foreach ($is_required[$s['module']] as $r) {
if (!isset($structure[$r])) {
$package['also_uninstall'][] = $r;
continue;
}
if ($structure[$r]['package'] == $s['package']) {
continue;
}
$package['is_required'][$structure[$r]['key']] = $structure[$r]['key'];
}
if (isset($s['icon'])) {
$package['icon'] = Base_ThemeCommon::get_template_file($s['module'], 'package-icon.png');
}
if (isset($s['version'])) {
$package['version'] = $s['version'];
}
if (isset($s['url'])) {
$package['url'] = $s['url'];
}
}
$sorted = array();
foreach ($packages as $key => $p) {
if ($key === 0) {
continue;
}
$name = $p['name'];
$option = $p['option'];
if (!isset($sorted[$name])) {
$sorted[$name] = array();
$sorted[$name]['name'] = $name;
$sorted[$name]['modules'] = array();
$sorted[$name]['buttons'] = array();
$sorted[$name]['options'] = array();
$sorted[$name]['status'] = __('Options only');
$sorted[$name]['filter'] = array('available');
$sorted[$name]['style'] = 'disabled';
$sorted[$name]['installed'] = null;
$sorted[$name]['instalable'] = 0;
$sorted[$name]['uninstalable'] = 0;
$sorted[$name]['core'] = 0;
}
$sorted[$name]['core'] |= $p['core'];
$buttons = array();
$status = '';
if ($p['installed'] === true || $p['installed'] === 'partial') {
if (!$p['core'] && empty($p['is_required'])) {
$mods = $p['modules'];
foreach ($p['also_uninstall'] as $pp) {
$mods[] = $pp;
}
if ($p['option'] === null) {
// also add all options as available for uninstall
foreach ($packages as $pp) {
if ($pp['name'] === $p['name']) {
$mods = array_merge($mods, $pp['modules']);
}
}
}
$buttons[] = array('label' => __('Uninstall'), 'style' => 'uninstall', 'href' => $this->create_confirm_callback_href(__('Are you sure you want to uninstall this package and remove all associated data?'), array($this, 'simple_uninstall'), array($mods)));
} else {
if ($p['core']) {
$message = __('EPESI Core can not be uninstalled');
} elseif (empty($p['is_required'])) {
$message = __('This package can not be uninstalled');
} else {
$required = array();
foreach ($p['is_required'] as $v) {
$required[] = str_replace('|', ' / ', $v);
}
$message = __('This package is required by the following packages: %s', array('<br>' . implode('<br>', $required)));
}
$buttons[] = array('label' => __('Uninstall'), 'style' => 'disabled', 'href' => Utils_TooltipCommon::open_tag_attrs($message, false));
}
}
if ($p['installed'] === false || $p['installed'] === 'partial') {
$buttons[] = array('label' => __('Install'), 'style' => 'install', 'href' => $this->create_callback_href(array($this, 'simple_install'), array($p['modules'])));
}
switch (true) {
case $p['installed'] === false:
$style = 'available';
$filter = array('available');
$status = __('Available');
break;
case $p['installed'] === true:
$style = 'install';
$filter = array('installed');
$status = __('Installed');
break;
case $p['installed'] === 'partial':
$style = 'partial-install';
$filter = array('installed');
$status = __('Partially');
break;
}
if ($option === null) {
$sorted[$name]['modules'] = $p['modules'];
$sorted[$name]['buttons'] = $buttons;
$sorted[$name]['status'] = $status;
$sorted[$name]['style'] = $style;
$sorted[$name]['installed'] = $p['installed'];
$sorted[$name]['instalable'] = 1;
$sorted[$name]['uninstalable'] = empty($p['is_required']);
$sorted[$name]['filter'] = $filter;
$sorted[$name]['icon'] = $p['icon'];
$sorted[$name]['version'] = $p['version'];
$sorted[$name]['url'] = $p['url'];
} else {
$sorted[$name]['options'][$option] = array('name' => $option, 'buttons' => $buttons, 'status' => $status, 'style' => $style);
}
}
$filters = array(__('All') => array('arg' => ''), __('Installed') => array('arg' => 'installed'), __('Available') => array('arg' => 'available'));
if (ModuleManager::is_installed('Base_EpesiStore') >= 0) {
$store_visible = Base_SetupCommon::is_store_visible();
if ($store_visible) {
$this->add_store_products($sorted, $filters);
}
$icon = $store_visible ? 'delete' : 'add';
$text = $store_visible ? __('Disable EPESI Store') : __('Enable EPESI Store');
$href = $this->create_callback_href(array('Base_SetupCommon', 'set_store_visibility'), array(!$store_visible));
$desc = $store_visible ? __('Disabling communication with EPESI Store will improve processing speed, but will not update the list of additional modules in the store.') : '';
Base_ActionBarCommon::add($icon, $text, $href, $desc);
}
foreach ($sorted as $name => $v) {
ksort($sorted[$name]['options']);
$buttons_tooltip =& $sorted[$name]['buttons_tooltip'];
$buttons_tooltip = $buttons_tooltip ? Utils_TooltipCommon::open_tag_attrs($buttons_tooltip, false) : '';
}
uasort($sorted, array($this, 'simple_setup_sort'));
$t = $this->init_module('Base/Theme');
$t->assign('packages', $sorted);
$t->assign('filters', $filters);
$t->assign('version_label', __('Ver. '));
$t->assign('labels', array('options' => __('Optional')));
$t->display();
}
public function body()
{
if (!Acl::is_user()) {
return;
}
$th = $this->init_module('Base/Theme');
eval_js_once('crm_filters_deactivate = function(){leightbox_deactivate(\'crm_filters\');}');
$th->assign('my', '<a ' . $this->create_callback_href(array('CRM_FiltersCommon', 'set_profile'), 'my') . ' id="crm_filters_my">' . __('My records') . '</a>');
eval_js('Event.observe(\'crm_filters_my\',\'click\', crm_filters_deactivate)');
/*$th->assign('all','<a '.$this->create_callback_href(array('CRM_FiltersCommon','set_profile'),'all').' id="crm_filters_all">'.__('All records').'</a>');
eval_js('Event.observe(\'crm_filters_all\',\'click\', crm_filters_deactivate)');*/
$th->assign('manage', '<a ' . $this->create_callback_href(array($this, 'manage_filters')) . ' id="crm_filters_manage">' . __('Manage presets') . '</a>');
eval_js('Event.observe(\'crm_filters_manage\',\'click\', crm_filters_deactivate)');
$ret = DB::Execute('SELECT id,name,description FROM crm_filters_group WHERE user_login_id=%d', array(Acl::get_user()));
$filters = array();
while ($row = $ret->FetchRow()) {
$filters[] = array('title' => $row['name'], 'description' => '', 'open' => '<a ' . Utils_TooltipCommon::open_tag_attrs($row['description'], false) . ' ' . $this->create_callback_href(array('CRM_FiltersCommon', 'set_profile'), $row['id']) . ' id="crm_filters_' . $row['id'] . '">', 'close' => '</a>');
eval_js('Event.observe(\'crm_filters_' . $row['id'] . '\',\'click\', crm_filters_deactivate)');
}
$th->assign('filters', $filters);
$qf = $this->init_module('Libs/QuickForm');
$fcallback = array('CRM_ContactsCommon', 'contact_format_no_company');
$recent_crits = array();
if (!Base_User_SettingsCommon::get('CRM_Contacts', 'show_all_contacts_in_filters')) {
$recent_crits = array('(company_name' => CRM_ContactsCommon::get_main_company(), '|related_companies' => array(CRM_ContactsCommon::get_main_company()));
}
if (Base_User_SettingsCommon::get('CRM_Contacts', 'show_only_users_in_filters')) {
$recent_crits['!login'] = '';
}
$contacts = CRM_ContactsCommon::get_contacts($recent_crits, array(), array(), 15);
$cont = array();
foreach ($contacts as $v) {
$cont[$v['id']] = call_user_func($fcallback, $v, true);
}
asort($cont);
$crits = array();
if (!Base_User_SettingsCommon::get('CRM_Contacts', 'show_all_contacts_in_filters')) {
$crits = array('(company_name' => CRM_ContactsCommon::get_main_company(), '|related_companies' => array(CRM_ContactsCommon::get_main_company()));
}
$qf->addElement('autoselect', 'crm_filter_contact', __('Records of'), $cont, array(array('CRM_ContactsCommon', 'autoselect_contact_suggestbox'), array($crits, $fcallback, false)), $fcallback);
if (isset($_SESSION['client']['filter_' . Acl::get_user()]['value'])) {
$qf->setDefaults(array('crm_filter_contact' => explode(',', $_SESSION['client']['filter_' . Acl::get_user()]['value'])));
}
$qf->addElement('submit', 'submit', __('Show'), array('onclick' => 'crm_filters_deactivate()'));
if ($qf->validate()) {
$c = $qf->exportValue('crm_filter_contact');
CRM_FiltersCommon::set_profile('c' . $c);
location(array());
}
$th->assign('saved_filters', __('Saved Presets'));
$qf->assign_theme('contacts', $th);
//$th->assign('contacts',$qf->toHtml());
ob_start();
$th->display();
$profiles_out = ob_get_clean();
Libs_LeightboxCommon::display('crm_filters', $profiles_out, __('Perspective'), true);
if (!isset($_SESSION['client']['filter_' . Acl::get_user()]['desc'])) {
CRM_FiltersCommon::set_profile('my');
}
//Base_ActionBarCommon::add('folder',__('Filters'),'class="lbOn" rel="crm_filters"',$this->get_module_variable('profile_desc',__('My records')));
if (isset($_REQUEST['__location'])) {
$in_use = CRM_FiltersCommon::$in_use === $_REQUEST['__location'];
} else {
$in_use = CRM_FiltersCommon::$in_use;
}
print '<a class="lbOn' . ($in_use ? '' : ' disabled') . ' button" rel="crm_filters">' . __('Perspective') . ': ' . '<b>' . $_SESSION['client']['filter_' . Acl::get_user()]['desc'] . '</b><div class="filter_icon_img"></div></a>';
}
public static function get_change_subscription_icon_tags($category_name, $id)
{
$category_id = self::get_category_id($category_name);
if (!$category_id) {
return;
}
$last_seen = self::check_if_notified($category_name, $id);
load_js('modules/Utils/Watchdog/subscribe.js');
$tag_id = 'watchdog_sub_button_' . $category_name . '_' . $id;
$href = ' onclick="utils_watchdog_set_subscribe(' . ($last_seen === null ? 1 : 0) . ',\'' . $category_name . '\',' . $id . ',\'' . $tag_id . '\')" href="javascript:void(0);"';
if ($last_seen === null) {
$icon = Base_ThemeCommon::get_template_file('Utils_Watchdog', 'not_watching_small.png');
$tooltip = __('Click to watch this record for changes.');
} else {
if ($last_seen === true) {
$icon = Base_ThemeCommon::get_template_file('Utils_Watchdog', 'watching_small.png');
$tooltip = __('You are watching this record, click to stop watching this record for changes.');
} else {
$icon = Base_ThemeCommon::get_template_file('Utils_Watchdog', 'watching_small_new_events.png');
$ev = self::display_events($category_id, $last_seen, $id);
$tooltip = __('You are watching this record, click to stop watching this record for changes.') . ($ev ? '<br>' . __('The following changes were made since the last time you were viewing this record:') . '<br><br>' . $ev['events'] : '');
}
}
$subscribers = self::get_subscribers($category_name, $id);
$my_user = Base_AclCommon::get_user();
if ($subscribers) {
$icon_on = ' src="' . Base_ThemeCommon::get_template_file('Utils_Watchdog', 'watching_small.png') . '"';
$icon_off = ' src="' . Base_ThemeCommon::get_template_file('Utils_Watchdog', 'watching_small_new_events.png') . '"';
$other_subscribers = array();
foreach ($subscribers as $subscriber) {
if ($subscriber == $my_user) {
continue;
}
if (class_exists('CRM_ContactsCommon')) {
$contact = CRM_ContactsCommon::get_user_label($subscriber, true);
} else {
$contact = Base_UserCommon::get_user_login($subscriber);
}
$notified = self::user_check_if_notified($subscriber, $category_name, $id);
$icon2 = $notified === true ? $icon_on : $icon_off;
$other_subscribers[] = '<img style="margin-right:4px;" ' . $icon2 . ' /><a>' . Utils_RecordBrowserCommon::no_wrap($contact) . '</a>';
}
if ($other_subscribers) {
$tooltip .= '<hr />' . implode('<br>', $other_subscribers);
}
}
$tooltip = Utils_TooltipCommon::open_tag_attrs($tooltip);
return '<a ' . $href . ' ' . $tooltip . '><img border="0" src="' . $icon . '"></a>';
}
public function body($arg = null, $rb = null, $uid = null)
{
if (isset($arg) && isset($rb)) {
$this->group = $rb->tab . '/' . $arg['id'];
if (Utils_WatchdogCommon::get_category_id($rb->tab) !== null) {
$this->watchdog_category = $rb->tab;
$this->watchdog_id = $arg['id'];
}
$this->set_view_func(array('Utils_RecordBrowserCommon', 'create_default_linked_label'), array($rb->tab, $arg['id']));
}
if (!isset($this->group) && !$uid) {
trigger_error('Key not given to attachment module', E_USER_ERROR);
}
$_SESSION['client']['utils_attachment_group'] = $this->group;
load_js('modules/Utils/Attachment/attachments.js');
Base_ThemeCommon::load_css('Utils_Attachment', 'browse');
$this->rb = $this->init_module(Utils_RecordBrowser::module_name(), 'utils_attachment', 'utils_attachment');
$defaults = array('permission' => Base_User_SettingsCommon::get('CRM_Common', 'default_record_permission'), 'func' => serialize($this->func), 'args' => serialize($this->args));
$rb_cols = array();
$single_group = is_string($this->group) || count($this->group) == 1;
if ($this->force_multiple) {
$single_group = false;
}
if ($single_group) {
$group = is_string($this->group) ? $this->group : reset($this->group);
$defaults['local'] = $group;
} else {
// force attached to display
$rb_cols['attached_to'] = true;
$this->rb->set_button(false);
}
$this->rb->set_defaults($defaults);
$this->rb->set_additional_actions_method(array($this, 'add_actions'));
$this->rb->set_header_properties(array('sticky' => array('width' => 1, 'display' => false), 'attached_to' => array('width' => "16em"), 'edited_on' => array('width' => "12em"), 'title' => array('width' => "20em")));
if ($uid) {
$this->rb->set_button(false);
$this->rb->disable_actions(array('delete'));
$this->display_module($this->rb, array(array(':Created_by' => $uid), $rb_cols, array('sticky' => 'DESC', 'edited_on' => 'DESC')), 'show_data');
} else {
$crits = array();
if (!is_array($this->group)) {
$this->group = array($this->group);
}
if (isset($_SESSION['attachment_copy']) && count($this->group) == 1 && $_SESSION['attachment_copy']['group'] != $this->group) {
$this->rb->new_button(Base_ThemeCommon::get_template_file(Utils_Attachment::module_name(), 'link.png'), __('Paste'), Utils_TooltipCommon::open_tag_attrs($_SESSION['attachment_copy']['text']) . ' ' . $this->create_callback_href(array($this, 'paste')));
}
if ($this->group) {
$g = array_map(array('DB', 'qstr'), $this->group);
$crits['id'] = DB::GetCol('SELECT attachment FROM utils_attachment_local WHERE local IN (' . implode(',', $g) . ')');
} else {
$crits['id'] = 0;
}
$this->display_module($this->rb, array($crits, $rb_cols, array('sticky' => 'DESC', 'edited_on' => 'DESC')), 'show_data');
}
}
public static function get_change_subscription_icon_tags($category_name, $id) {
$category_id = self::get_category_id($category_name);
if (!$category_id) return;
$last_seen = self::check_if_notified($category_name, $id);
load_js('modules/Utils/Watchdog/subscribe.js');
$tag_id = 'watchdog_sub_button_'.$category_name.'_'.$id;
$href = ' onclick="utils_watchdog_set_subscribe('.(($last_seen===null)?1:0).',\''.$category_name.'\','.$id.',\''.$tag_id.'\')" href="javascript:void(0);"';
if ($last_seen===null) {
$icon = Base_ThemeCommon::get_template_file('Utils_Watchdog','not_watching_small.png');
$tooltip = Utils_TooltipCommon::open_tag_attrs(__('Click to watch this record for changes.'));
} else {
if ($last_seen===true) {
$icon = Base_ThemeCommon::get_template_file('Utils_Watchdog','watching_small.png');
$tooltip = Utils_TooltipCommon::open_tag_attrs(__('You are watching this record, click to stop watching this record for changes.'));
} else {
$icon = Base_ThemeCommon::get_template_file('Utils_Watchdog','watching_small_new_events.png');
$ev = self::display_events($category_id, $last_seen, $id);
$tooltip = Utils_TooltipCommon::open_tag_attrs(__('You are watching this record, click to stop watching this record for changes.').($ev?'<br>'.__('The following changes were made since the last time you were viewing this record:').'<br><br>'.$ev['events']:''));
}
}
return '<a '.$href.' '.$tooltip.'><img border="0" src="'.$icon.'"></a>';
}
