"; print_r ( $var ); echo "
';
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$where = '';
if (isset($_GET['wpdev_filter_customer'])) {
if ( $_GET['wpdev_filter_customer'] != '0') {
if ($where !== '') { $where .= ' AND '; }
$where .= ' custmr.customer_id = '. $_GET['wpdev_filter_customer'] . ' ';
}
}
// TODO: add here filter and set it to pro
$where = apply_crm_filter('wpdev_where_filter', $where);
/*// Pro functionality //////////////////////////////////////////////////////////////////////////////
if (isset($_GET['wpdev_filter_order_type'])) {
if ( ( $_GET['wpdev_filter_order_type'] !== '' ) && ( $_GET['wpdev_filter_order_type'] != '0' ) ) {
if ($where !== '') { $where .= ' AND '; }
$where .= ' ordr.internal_filters1 = '. $_GET['wpdev_filter_order_type'] . ' ';
}
}
if (isset($_GET['wpdev_filter_bk_dates_start'])) {
if ( ( $_GET['wpdev_filter_bk_dates_start'] !== '' ) && ( $_GET['wpdev_filter_bk_dates_start'] != '0' ) ) {
if ($where !== '') { $where .= ' AND '; }
$my_date = explode('-',$_GET['wpdev_filter_bk_dates_start']);
$my_date = sprintf( "%04d-%02d-%02d %02d:%02d:%02d", $my_date[0], $my_date[1], $my_date[2], '00', '00', '00' );
$where .= ' ordr.internal_filters2 > \''. $my_date . '\' ';
}
}
if (isset($_GET['wpdev_filter_bk_dates_fin'])) {
if ( ( $_GET['wpdev_filter_bk_dates_fin'] !== '' ) && ( $_GET['wpdev_filter_bk_dates_fin'] != '0' ) ) {
if ($where !== '') { $where .= ' AND '; }
$my_date = explode('-',$_GET['wpdev_filter_bk_dates_fin']);
$my_date = sprintf( "%04d-%02d-%02d %02d:%02d:%02d", $my_date[0], $my_date[1], $my_date[2], '23', '59', '59' );
$where .= ' ordr.internal_filters3 < \''. $my_date . '\' ';
}
}
if (isset($_GET['wpdev_filter_cost_start'])) {
if ( ($_GET['wpdev_filter_cost_start'] +0) > 0 ) {
if ($where !== '') { $where .= ' AND '; }
$where .= ' ordr.cost > '. $_GET['wpdev_filter_cost_start'] . ' ';
}
}
if (isset($_GET['wpdev_filter_cost_fin'])) {
if ( ($_GET['wpdev_filter_cost_fin'] +0) > 0 ) {
if ($where !== '') { $where .= ' AND '; }
$where .= ' ordr.cost < '. $_GET['wpdev_filter_cost_fin'] . ' ';
}
}/**/
///////////////////////////////////////////////////////////////////////////////////////////////////
//debuge($where);
if ($where !== '') $where = ' WHERE ' . $where;
//Set here order by some field
$sql = "SELECT count(ordr.order_id) as cnt
FROM ".$wpdb->prefix ."wpdev_crm_orders as ordr
INNER JOIN ".$wpdb->prefix ."wpdev_crm_customers as custmr
ON ordr.customer_id = custmr.customer_id
" . $where ."
ORDER BY ".$sort_tag_for_table." ordr.order_id DESC";
$result = $wpdb->get_results( $sql );
$togather_pages = ceil($result[0]->cnt / ((int) $cont_on_page));
$sql = "SELECT *
FROM ".$wpdb->prefix ."wpdev_crm_orders as ordr
INNER JOIN ".$wpdb->prefix ."wpdev_crm_customers as custmr
ON ordr.customer_id = custmr.customer_id " .
$where ."
ORDER BY ".$sort_tag_for_table." ordr.order_id DESC LIMIT " .$start_page . "," . $cont_on_page;
// debuge($sql);
$result = $wpdb->get_results( $sql );
// debuge($result);
?>
| ');"> |
(',''); ?>
');">
, ');">
)
 
|
');"> | ');"> | ');"> | ');"> |
|---|---|---|---|---|---|
|
Booking Calendar v.2.1'); ?> ', 'Booking Calendar Standard',''); ?> | |||||
';
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//Set here order by some field
$sql = "SELECT count(custmr.customer_id) as cnt
FROM ".$wpdb->prefix ."wpdev_crm_customers as custmr
ORDER BY ".$sort_tag_for_table." custmr.customer_id DESC";
$result = $wpdb->get_results( $sql );
$togather_pages = ceil($result[0]->cnt / ((int) $cont_on_page));
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// S Q L
$sql = "SELECT custmr.*, count(ordr.order_id) as cnt
FROM ".$wpdb->prefix ."wpdev_crm_customers as custmr
INNER JOIN ".$wpdb->prefix ."wpdev_crm_orders as ordr
ON ordr.customer_id = custmr.customer_id
GROUP by customer_id
ORDER BY ".$sort_tag_for_table." custmr.customer_id DESC LIMIT " .$start_page . "," . $cont_on_page ;
$result = $wpdb->get_results( $sql );
$alternative_color = '';
?>
| "> | "> | "> | "> | "> | "> | "> | "> | |
|---|---|---|---|---|---|---|---|---|
| >customer_id; ?> | > second_name . ' ' . $result[$i]->name; ?> | >email; ?> | >phone; ?> | >adress; ?> | >city; ?> | >country; ?> | > cnt; ?> | >
' . $type_items[ $bk['booking_type'] ] . '';
?>
 '
/>
 ' />
";
make_CRM_action('show_remark_editing_field',$bk['id'],$bk,"height:1px;padding:0px;margin:0px;border:none;");
?>
|
|
Booking Calendar v.2.1'); ?> ', 'Booking Calendar Standard',''); ?> | ||||||||
*/ ?>
"; print_r ( $var ); echo "
