| Server IP : 172.67.157.199 / Your IP : 3.148.109.216 [ Web Server : Apache System : Linux b70eb322-3aee-0c53-7c82-0db91281f2c6.secureserver.net 6.1.90-1.el9.elrepo.x86_64 #1 SMP PREEMPT_DYNAMIC Thu May 2 12:09:22 EDT 2024 x86_64 User : root ( 0) PHP Version : 8.0.30.2 Disable Function : NONE Domains : 0 Domains MySQL : ON | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/wp-content/plugins/appointment-hour-booking/addons/ |
Upload File : |
<?php
/*
*/
if ( ! defined( 'ABSPATH' ) ) exit; // Exit if accessed directly
require_once __DIR__.'/base.addon.php';
if( !class_exists( 'CPAPPB_DashboardWidget' ) )
{
class CPAPPB_DashboardWidget extends CPAPPB_BaseAddon
{
/************* ADDON SYSTEM - ATTRIBUTES AND METHODS *************/
protected $addonID = "addon-DashboardWidget-20181221";
protected $name = 'Dashboard Widget: Upcoming appointments';
protected $description;
protected $max_image_width = 250;
public $category = ' Add-ons included in this plugin version';
public $help = 'https://apphourbooking.dwbooster.com/images/articles/dashboard-documentation.png';
public function get_addon_settings()
{
if( isset( $_REQUEST[ 'cpappb_dashboard' ] ) )
{
check_admin_referer( 'session_id_ds_'.session_id(), '_cpappb_nonce_dashboard' );
update_option( 'cpappb_dashboard_maxitems', trim( intval($_REQUEST[ 'cpappb_dashboard_maxitems' ]) ) );
update_option( 'cpappb_dashboard_columns', trim( sanitize_text_field($_REQUEST[ 'cpappb_dashboard_columns' ]) ) );
update_option( 'cpappb_dashboard_columnlabels', trim( sanitize_text_field($_REQUEST[ 'cpappb_dashboard_columnlabels' ]) ) );
}
?>
<form method="post">
<div id="metabox_basic_settings" class="postbox" >
<h3 class='hndle' style="padding:5px;"><span><?php print esc_html(__($this->name, 'appointment-hour-booking')); ?></span></h3>
<div class="inside">
<table cellspacing="0" style="width:100%;">
<tr>
<td style="white-space:nowrap;width:200px;" valign="top"><?php _e('Maximum items listed', 'appointment-hour-booking');?>:</td>
<td>
<input type="text" name="cpappb_dashboard_maxitems" value="<?php echo esc_attr(( ( $key = get_option( 'cpappb_dashboard_maxitems' ) ) !== false ) ? $key : '10'); ?>" size="10" />
</td>
</tr>
<tr>
<td style="white-space:nowrap;width:200px;" valign="top"><?php _e('Columns', 'appointment-hour-booking');?>:</td>
<td>
<input type="text" name="cpappb_dashboard_columns" value="<?php echo esc_attr(( ( $key = get_option( 'cpappb_dashboard_columns' ) ) !== false ) ? $key : 'TIME,SERVICE,data'); ?>" style="width:80%;" /><br />
<em><?php print esc_html(__('Sample column names', 'appointment-hour-booking')); ?>: final_price,formname,...<a href="https://apphourbooking.dwbooster.com/faq#q507" target="_blank"><?php print esc_html(__('Click for more info about supported column names', 'appointment-hour-booking')); ?></a>.</em>
</td>
</tr>
<tr>
<td style="white-space:nowrap;width:200px;" valign="top"><?php _e('Column labels', 'appointment-hour-booking');?>:</td>
<td>
<input type="text" name="cpappb_dashboard_columnlabels" value="<?php echo esc_attr(( ( $key = get_option( 'cpappb_dashboard_columnlabels' ) ) !== false ) ? $key : 'Time,Service,Data'); ?>" style="width:80%;" /><br />
<em><?php print esc_html(__('Visual column names at the top of the table', 'appointment-hour-booking')); ?>.</em>
</td>
</tr>
</table>
<input type="submit" name="subbtnds" value="<?php _e('Save settings', 'appointment-hour-booking');?>" />
</div>
<input type="hidden" name="cpappb_dashboard" value="1" />
<input type="hidden" name="_cpappb_nonce_dashboard" value="<?php echo esc_attr(wp_create_nonce( 'session_id_ds_'.session_id() )); ?>" />
</div>
</form>
<?php
}
/************************ ADDON CODE *****************************/
/************************ ATTRIBUTES *****************************/
/************************ CONSTRUCT *****************************/
function __construct()
{
$this->description = __("The add-on adds a widget to display a list of upcoming appointments in the dashboard welcome page.", 'appointment-hour-booking' );
// Check if the plugin is active
if( !$this->addon_is_active() ) return;
add_action('wp_dashboard_setup', array(&$this, 'add_dashboard_widgets') );
} // End __construct
public function add_dashboard_widgets() {
wp_add_dashboard_widget('dashboard_widget', __('Appointment Hour Booking: Upcoming appointments', 'appointment-hour-booking'), array(&$this, 'pp_DashboardWidget'));
}
/************************ PRIVATE METHODS *****************************/
/************************ PUBLIC METHODS *****************************/
/**
* print list
*/
public function pp_DashboardWidget($atts = array())
{
global $wpdb, $cp_appb_plugin;
extract( shortcode_atts( array(
'calendar' => '',
'showdelete' => '0',
'columnlabels' => __('Time', 'appointment-hour-booking').",". __('Service', 'appointment-hour-booking').",". __('Data', 'appointment-hour-booking'),
'columns' => 'TIME,SERVICE,data',
'datefrom' => 'today',
'dateto' => 'today +1 month',
'paidonly' => "",
'maxitems' => "10",
'datelabel' => __('Date', 'appointment-hour-booking'),
'status' => "-1"
), $atts ) );
$columns = str_replace('>','',str_replace('<','',str_replace('%','',get_option( 'cpappb_dashboard_columns', $columns))));
$columnlabels = strip_tags(get_option( 'cpappb_dashboard_columnlabels', $columnlabels));
$maxitems = get_option( 'cpappb_dashboard_maxitems' );
if ($maxitems == '')
$maxitems = 10;
else
$maxitems = intval($maxitems);
echo '<div style="font-weight:bold;margin-bottom:3px;">'.esc_html(__('Next','appointment-hour-booking'))." ".intval($maxitems)." ".esc_html(__('upcoming appointments:','appointment-hour-booking'))."</div>";
wp_enqueue_script( "jquery" );
$cond = '1=1';
$cond = apply_filters( 'cpappb_the_availability_filter_second', $cond, intval($cp_appb_plugin->getId()) );
if ($calendar)
$cond .= " AND formid=".intval($calendar);
// calculate dates
$from = date("Y-m-d",strtotime($datefrom));
$to = date("Y-m-d",strtotime($dateto));
$events_query = "SELECT * FROM ".$wpdb->prefix.$cp_appb_plugin->table_messages." INNER JOIN ".$wpdb->prefix.$cp_appb_plugin->table_items." ON ".$wpdb->prefix.$cp_appb_plugin->table_messages.".formid=".$wpdb->prefix.$cp_appb_plugin->table_items.".id".
" WHERE ".$cond." ORDER BY time DESC";
$events = $wpdb->get_results($events_query); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
// pre-select time-slots
$selection = array();
foreach($events as $item)
{
$data = unserialize($item->posted_data);
if (!$paidonly || $data['paid'])
{
foreach($data["apps"] as $app)
if ($app["date"] >= $from && $app["date"] <= $to && ($status == '-1' || $status == $app["cancelled"])
&& $app["cancelled"] != 'Cancelled' && $app["cancelled"] != 'Cancelled by customer')
{
$selection[] = array($app["date"]." ".$app["slot"], $app["date"], $app["slot"], $data, sanitize_email($item->notifyto), $item->data, $app["cancelled"], $app["service"]);
}
}
}
// order time-slots
function listgroupd_addon_appbkfastsortfn($a, $b) { return ($a[0] > $b[0]?1:-1); }
usort($selection, "listgroupd_addon_appbkfastsortfn" );
// clean fields IDs
$fields = explode(",",trim($columns));
for($j=0; $j<count($fields); $j++)
$fields[$j] = strtolower(trim($fields[$j]));
$columnlabels = explode(",", $columnlabels);
$columns = explode(",", $columns);
if (!count($selection))
{
echo esc_html(__('No upcoming appointments found','appointment-hour-booking'));
return;
}
echo '<style>.cpappbtable { border-collapse: collapse;border-spacing: 0;width: 100%;} .cpappbtable .cpappbth { text-align: left; border: 1px solid #999; background-color:#BDD7EE; } .cpappbtable .cpappbth th, .cpappbtable td {border: 1px solid #999;text-align: left;padding: 8px;word-break: normal; }.cpappbheadermth,.cpappbheadermtd{ text-align: left; border: 1px solid #999 !important; background-color:#F8CBAD ;}</style>';
// list data rows
$colnum = 0;
$lastdate = '';
for($i=0; $i<count($selection) && $i<$maxitems; $i++)
{
$colnum++;
if ($lastdate != $selection[$i][1])
{
if ($lastdate != '') echo '</table></div>';
$lastdate = $selection[$i][1];
echo '<div style="overflow-x:auto;"><table class="cpappbtable"><tr>';
// list header rows
echo '<th class="cpappbheadermth">'.esc_html($datelabel).'</th>';
echo '<td class="cpappbheadermtd" nowrap>'.esc_html($lastdate).'</td>';
echo '<tr>';
$colnum = 0;
foreach ($columnlabels as $item)
{
$colnum++;
echo '<th class="cpappbheader'.intval($colnum).' cpappbth">'.esc_html(trim($item)).'</th>';
}
if ($showdelete)
echo '<th class="cpappbheader'.intval($colnum++).' cpappbth"></th>';
echo '</tr>';
}
echo '<tr class="'.($selection[$i][6]!=''?' cpappb_cancelled':'').'">';
for($j=0; $j<count($fields); $j++)
{
switch ($fields[$j]) {
case 'date':
$value = esc_html($selection[$i][1]);
break;
case 'time':
$value = esc_html($selection[$i][2]);
break;
case 'email':
$value = sanitize_email($selection[$i][4])." ";
break;
case 'service':
$value = esc_html($selection[$i][7])." ";
break;
case 'cancelled':
if ($selection[$i][6] == '')
$value = __('Approved','appointment-hour-booking');
else
$value = esc_html($selection[$i][6]);
$value = ' ';
break;
case 'data':
$value = esc_html(substr($selection[$i][5],strpos($selection[$i][5],"\n\n")+2));
break;
case 'paid':
$value = ($selection[$i][3]['paid']?__('Yes','appointment-hour-booking'):' ');
break;
default:
$value = esc_html(($selection[$i][3][$fields[$j]]==''?' ':$selection[$i][3][$fields[$j]]))." ";
}
echo '<td class="cpappbcol'.esc_html($colnum).'">'.esc_html(trim($value)).'</td>';
}
if ($showdelete)
echo '<td class="cpappbcol'.esc_html($colnum++).'">[<a href="javascript:cpappb_deleteitem('.intval($event->id).');">'.esc_html(__('delete','appointment-hour-booking')).'</a>]</td>';
echo '</tr>';
}
if ($lastdate != '') echo '</table></div>';
} // end pp_DashboardWidget
private function make_links_clickable($text, $is_upload)
{
$link = preg_replace('!(((f|ht)tp(s)?://)[-a-zA-Zа-яА-Я()0-9@:%_+.~#?&;//=]+)!i', '<a href="$1">*LLLK*</a>', $text);
if ($is_upload)
$link = str_replace('*LLLK*', basename($text), $link);
else
$link = str_replace('*LLLK*', $text, $link);
return $link;
}
} // End Class
// Main add-on code
$CPAPPB_DashboardWidget_obj = new CPAPPB_DashboardWidget();
// Add addon object to the objects list
global $cpappb_addons_objs_list;
$cpappb_addons_objs_list[ $CPAPPB_DashboardWidget_obj->get_addon_id() ] = $CPAPPB_DashboardWidget_obj;
}