';
// } Build input
$ret .= ''; // phpcs:ignore WordPress.NamingConventions.ValidVariableName.VariableNotSnakeCase
// } close wrap
$ret .= '';
// } Also need to make sure this is dumped out for js
global $haszbscrmBHURLCustomersOut;
if ( ! isset( $haszbscrmBHURLCustomersOut ) ) {
$nonce = wp_create_nonce( 'wp_rest' );
$rest_base_url = get_rest_url();
// handle bare permalink structure
if ( empty( get_option( 'permalink_structure' ) ) ) {
$param_separator = '&';
} else {
$param_separator = '?';
}
$rest_url = $rest_base_url . 'zbscrm/v1/contacts' . $param_separator . '_wpnonce=' . $nonce;
$ret .= '';
$haszbscrmBHURLCustomersOut = true;
}
// } Global JS does the rest ;)
// } see zbscrm_JS_Bind_Typeaheads_Customers
return $ret;
}
// } Outputs the html for a Company type-ahead list
function zeroBSCRM_CompanyTypeList( $jsCallbackFuncStr = '', $inputDefaultValue = '', $showFullWidthSmaller = false, $jsChangeCallbackFuncStr = '' ) {
$ret = '';
$extraClasses = '';
if ( $showFullWidthSmaller ) {
$extraClasses .= 'zbsbtypeaheadfullwidth';
}
// typeahead
// } Wrap
$ret .= '';
// } Also need to make sure this is dumped out for js
global $haszbscrmBHURLCompaniesOut;
if ( ! isset( $haszbscrmBHURLCompaniesOut ) ) {
$nonce = wp_create_nonce( 'wp_rest' );
$rest_base_url = get_rest_url();
// handle bare permalink structure
if ( empty( get_option( 'permalink_structure' ) ) ) {
$param_separator = '&';
} else {
$param_separator = '?';
}
$rest_url = $rest_base_url . 'zbscrm/v1/companies' . $param_separator . '_wpnonce=' . $nonce;
$ret .= '';
$haszbscrmBHURLCompaniesOut = true;
}
// } Global JS does the rest ;)
// } see zbscrm_JS_Bind_Typeaheads_Customers
return $ret;
}
// WH NOTE: WHY is this getting ALL of them and not s? param
// } Returns json representing the first 10k customers in db... brutal
// } MS NOTE: useful to return EMAIL in the response (for auto filling - WITHOUT getting ALL meta)?
function zeroBSCRM_cjson() {
$ret = array();
if ( is_user_logged_in() && zeroBSCRM_permsCustomers() ) {
$ret = zeroBS_getCustomers( true, 10000, 0, false, false, '', false, false, false );
}
wp_send_json( $ret );
}
// WH NOTE: WHY is this getting ALL of them and not s? param
// } Returns json representing the first 10k customers in db... brutal
function zeroBSCRM_cojson() {
$ret = array();
if ( is_user_logged_in() && zeroBSCRM_permsCustomers() ) {
// $ret = zeroBS_getCustomers(false,10000,0,false,false,'',false,false,false);
$ret = zeroBS_getCompanies( true, 10000, 0 );
$retA = array(); // phpcs:ignore WordPress.NamingConventions.ValidVariableName.VariableNotSnakeCase
foreach ( $ret as $r ) {
if ( isset( $r['name'] ) && $r['name'] !== 'Auto Draft' ) {
$retA[] = $r;
}
}
$ret = $retA; // phpcs:ignore WordPress.NamingConventions.ValidVariableName.VariableNotSnakeCase
unset( $retA );
}
wp_send_json( $ret );
}
/*
======================================================
/ Customer Typeaheads
====================================================== */
/*
======================================================
Customer Filter Funcs
====================================================== */
function zbs_customerFiltersGetApplied( $srcArr = 'usepost', $requireEmail = false ) {
$fieldPrefix = '';
// } Can't use post as a default, so...
if ( is_string( $srcArr ) && $srcArr == 'usepost' ) {
$srcArr = $_POST;
// } Also, posted fields need this prefix
$fieldPrefix = 'zbs-crm-customerfilter-';
$fromPost = true;
}
// } Req.
global $zbsCustomerFields, $zbsCustomerFiltersInEffect, $zbsCustomerFiltersPosted;
$allZBSTags = zeroBS_integrations_getAllCategories();
// } start
$appliedFilters = array();
$activeFilters = 0;
/*
status (str)
namestr (str)
source (str) linked to cf1
valuefrom
valueto
addedfrom
addedto
zbs-crm-customerfilter-tag-'.$tagGroupKey.'-'.$tag->term_id
hasquote (bool int)
hasinv (bool int)
hastransact (bool int)
postcode (str)
To add:
#} modifiedfromtoo
#} External source/id (LATER)
*/
// } process filters
$possibleFilters = array(
// } key => array(type, matching field(notyetused))
'status' => array( 'str', 'status' ),
'namestr' => array( 'str', 'custom:fullname' ),
'source' => array( 'str', 'cf1' ),
'valuefrom' => array( 'float', 'custom:totalval' ),
'valueto' => array( 'float', 'custom:totalval' ),
'addedrange' => array( 'str', '' ), // x - y (dates)
// } these will be added by func below
// 'addedfrom' => array('str',''),
// 'addedto' => array('str',''),
'hasquote' => array( 'bool', '' ),
'hasinv' => array( 'bool', '' ),
'hastransact' => array( 'bool', '' ),
'postcode' => array( 'str', 'postcode' ),
);
// } Tags dealt with separately.
foreach ( $possibleFilters as $key => $filter ) {
$type = $filter[0];
if ( isset( $srcArr[ $fieldPrefix . $key ] ) ) {
switch ( $type ) {
case 'str':
// } Is it a str? cleanse?
if ( ! empty( $srcArr[ $fieldPrefix . $key ] ) ) {
// } add
$appliedFilters[ $key ] = sanitize_text_field( $srcArr[ $fieldPrefix . $key ] );
++$activeFilters;
}
break;
case 'float':
// } Is it a no? cleanse?
if ( ! empty( $srcArr[ $fieldPrefix . $key ] ) ) {
// } Cast
$no = (float) sanitize_text_field( $srcArr[ $fieldPrefix . $key ] );
// } add
$appliedFilters[ $key ] = $no;
++$activeFilters;
}
break;
case 'int':
// } Is it a no? cleanse?
if ( ! empty( $srcArr[ $fieldPrefix . $key ] ) ) {
// } Cast
$no = (int) sanitize_text_field( $srcArr[ $fieldPrefix . $key ] );
// } add
$appliedFilters[ $key ] = $no;
++$activeFilters;
}
break;
case 'bool':
// } Is it a bool? cleanse?
// } double check? no need...
// } made a hack bool here - is either:
// } empty (not set)
// } 1 = true
// } -1 = false
if ( isset( $srcArr[ $fieldPrefix . $key ] ) ) {
if ( $srcArr[ $fieldPrefix . $key ] == '1' ) {
// } add
$appliedFilters[ $key ] = true;
++$activeFilters;
} elseif ( $srcArr[ $fieldPrefix . $key ] == '-1' ) {
// } add
$appliedFilters[ $key ] = false;
++$activeFilters;
}
}
break;
}
}
} // / foreach
// } Added date range
if ( isset( $appliedFilters['addedrange'] ) && ! empty( $appliedFilters['addedrange'] ) ) {
// } Try split
if ( strpos( $appliedFilters['addedrange'], '-' ) > 0 ) {
$dateParts = explode( ' - ', $appliedFilters['addedrange'] );
if ( count( $dateParts ) == 2 ) {
// } No validation here (yet)
if ( ! empty( $dateParts[0] ) ) {
$appliedFilters['addedfrom'] = $dateParts[0];
++$activeFilters;
}
if ( ! empty( $dateParts[1] ) ) {
$appliedFilters['addedto'] = $dateParts[1];
++$activeFilters;
}
}
}
}
// } Tags (From POST)
if ( isset( $fromPost ) ) {
$appliedFilters['tags'] = array();
if ( isset( $allZBSTags ) && count( $allZBSTags ) > 0 ) {
// } Cycle through + catch active
foreach ( $allZBSTags as $tagGroupKey => $tagGroup ) {
if ( count( $tagGroup ) > 0 ) {
foreach ( $tagGroup as $tag ) {
$tagID = $tag['id']; // phpcs:ignore WordPress.NamingConventions.ValidVariableName.VariableNotSnakeCase
// } set?
if ( isset( $_POST[ 'zbs-crm-customerfilter-tag-' . $tagGroupKey . '-' . $tagID ] ) ) {
// } Tagged :) Add
$appliedFilters['tags'][ $tagGroupKey ][ $tagID ] = true;
++$activeFilters;
}
}
}
}
}
} else {
// } From passed array, so just make sure it's an array of arrays and pass :)
// } This all assumes passing a json obj made into array with (array) cast (see mail camp search #tempfilterjsonpass)
$appliedFilters['tags'] = array();
if ( isset( $srcArr['tags'] ) ) {
$srcTags = (array) $srcArr['tags'];
if ( is_array( $srcTags ) && count( $srcTags ) > 0 ) {
foreach ( $srcTags as $tagKey => $tagObj ) {
$appliedFilters['tags'][ $tagKey ] = (array) $tagObj;
}
}
}
}
// } if req email
if (
$requireEmail ||
( isset( $srcArr[ $fieldPrefix . 'require-email' ] ) && ! empty( $srcArr[ $fieldPrefix . 'require-email' ] ) )
) {
$appliedFilters['require_email'] = true;
}
// } this will only be set if filters have been posted/some actually apply:
// } $zbsCustomerFiltersPosted;
if ( $activeFilters > 0 ) {
$zbsCustomerFiltersPosted = $activeFilters;
}
return $appliedFilters;
}
/*
zbs_customerFiltersRetrieveCustomers
#} Retrieves array of customers filtered by zbs_customerFilters
#} Notes:
- This can + will be fired by zeroBS__customerFiltersRetrieveCustomerCount if that is fired BEFORE THIS
.. Thereafter it'll use a cached list (and apply paging) - unless $forceRefresh is set to true
*/
function zbs_customerFiltersRetrieveCustomers( $perPage = 10, $page = 1, $forcePaging = false, $forceRefresh = false ) {
// } Query Performance index
// global $zbsQPI; if (!isset($zbsQPI)) $zbsQPI = array();
// $zbsQPI['retrieveCustomers1'] = zeroBSCRM_mtime_float();
// } Req.
global $zbs,$zbsCustomerFields, $zbsCustomerFiltersInEffect, $zbsCustomerFiltersCurrentList;
// } Already cached?
if (
// } Already cached - yep + force refresh
( isset( $zbsCustomerFiltersCurrentList ) && is_array( $zbsCustomerFiltersCurrentList ) && $forceRefresh ) ||
// } Not cached
( ! isset( $zbsCustomerFiltersCurrentList ) || ! is_array( $zbsCustomerFiltersCurrentList ) )
) {
// DEBUG echo 'NOT CACHED: zbs_customerFiltersRetrieveCustomers
';
// } Any applied filters will be here: $zbsCustomerFiltersInEffect
$appliedFilters = array();
// } No validation here
if ( isset( $zbsCustomerFiltersInEffect ) && is_array( $zbsCustomerFiltersInEffect ) && count( $zbsCustomerFiltersInEffect ) > 0 ) {
$appliedFilters = $zbsCustomerFiltersInEffect;
}
// } Output
// } First build query
// } PAGING NOTE:
// } MOVED TO POST retrieve, to allow for counts to be made :)
// } MVP... search #postpaging
// } Note $forcePaging FORCES pre-paging
// } Page legit? - lazy check
if ( $forcePaging ) {
if ( $perPage < 0 ) {
$perPageArg = 10;
} else {
$perPageArg = (int) $perPage;
}
} else {
$perPageArg = 10000; // } lol.
}
// } Defaults
$args = array(
'post_type' => 'zerobs_customer',
'post_status' => 'publish',
'posts_per_page' => $perPageArg,
'order' => 'DESC',
'orderby' => 'post_date',
);
if ( $forcePaging ) {
// } Add page if page... - dodgy meh
$actualPage = $page - 1;
if ( $actualPage < 0 ) {
$actualPage = 0;
}
if ( $actualPage > 0 ) {
$args['offset'] = $perPageArg * $actualPage;
}
}
// DAL 2 support :)
$dal2Args = array(
'perPage' => $perPageArg,
'sortByField' => 'zbsc_created',
'sortOrder' => 'DESC',
'ignoreowner' => true,
'withQuotes' => true,
'withInvoices' => true,
'withTransactions' => true,
);
// } This is brutal, and needs rethinking #v1.2
// } For now, is split into two sections
// 1) Can be queried via wp_post args
// 2) Can't be... (filtered post query...)
// } Inefficient, but for launch...
// } ===============================================================
// } get_posts queriable attrs
// } ===============================================================
// } Name
// } As of v1.1
// 'name' => $customerEle->post_title
if ( isset( $appliedFilters['namestr'] ) && ! empty( $appliedFilters['namestr'] ) ) {
// } Simples
$args['s'] = $appliedFilters['namestr'];
// DAL2
$dal2Args['searchPhrase'] = $appliedFilters['namestr'];
}
// } Added From + To
// 'created' => $customerEle->post_date_gmt OR post_modified_gmt for modified
if ( isset( $appliedFilters['addedfrom'] ) && ! empty( $appliedFilters['addedfrom'] ) ) {
// } add holder if req
if ( ! $args['date_query'] ) {
$args['date_query'] = array();
}
// } Add
$args['date_query'][] = array(
'column' => 'post_date_gmt',
'after' => $appliedFilters['addedfrom'],
);
// DAL2
// TBC $dal2Args['searchPhrase'] = $appliedFilters['namestr'];
}
if ( isset( $appliedFilters['addedto'] ) && ! empty( $appliedFilters['addedto'] ) ) {
// } ensure date_query array exists
if ( ! isset( $args['date_query'] ) ) {
$args['date_query'] = array();
}
// } Add
$args['date_query'][] = array(
'column' => 'post_date_gmt',
'before' => $appliedFilters['addedto'],
);
// DAL2
// TBC $dal2Args['searchPhrase'] = $appliedFilters['namestr'];
}
// } Tags
if ( isset( $appliedFilters['tags'] ) && is_array( $appliedFilters['tags'] ) && count( $appliedFilters['tags'] ) > 0 ) {
// } Temp holder
$tagQueryArrays = array();
// DAL2 - ignoring taxonomy here
$tagIDS = array();
// } Foreach taxonomy type:
foreach ( $appliedFilters['tags'] as $taxonomyKey => $tagItem ) {
$thisTaxonomyArr = array();
// } Foreach tag in taxonomy
foreach ( $tagItem as $tagID => $activeFlag ) {
// } If logged here, is active, disregard $activeFlag
$thisTaxonomyArr[] = $tagID;
// dal2
$tagIDS[] = $tagID;
}
if ( count( $thisTaxonomyArr ) > 0 ) {
// } Add it
$tagQueryArrays[] = array(
'taxonomy' => $taxonomyKey,
'field' => 'term_id',
'terms' => $thisTaxonomyArr,
);
}
/*
#} Later for "not in"
'terms' => array( 103, 115, 206 ),
'operator' => 'NOT IN',
*/
}
// } Any to add?
if ( count( $tagQueryArrays ) > 0 ) {
// } Set
$args['tax_query'] = array();
// } if multiple, needs this
if ( count( $tagQueryArrays ) > 1 ) {
$args['tax_query']['relation'] = 'AND';
}
// } Add em all :)
foreach ( $tagQueryArrays as $tqArr ) {
$args['tax_query'][] = $tqArr;
}
}
// DAL2
if ( count( $tagIDS ) > 0 ) {
$dal2Args['isTagged'] = $tagIDS;
}
}
// } ===============================================================
// } / end of get_posts queriable attrs
// } ===============================================================
// Debug echo 'ARGS
'; print_r($args); echo '
';
// } QPI
// $zbsQPI['retrieveCustomers1'] = round(zeroBSCRM_mtime_float() - #$zbsQPI['retrieveCustomers1'],2).'s';
// $zbsQPI['retrieveCustomers2'] = zeroBSCRM_mtime_float();
// } Run query
// $potentialCustomerList = get_posts( $args );
$potentialCustomerList = $zbs->DAL->contacts->getContacts( $dal2Args ); // phpcs:ignore WordPress.NamingConventions.ValidVariableName.UsedPropertyNotSnakeCase,WordPress.NamingConventions.ValidVariableName.VariableNotSnakeCase
// $endingCustomerList = zeroBS_getCustomers(true,10,0,true,true,'',true,$args);
$endingCustomerList = array();
// } QPI
// $zbsQPI['retrieveCustomers2'] = round(zeroBSCRM_mtime_float() - #$zbsQPI['retrieveCustomers2'],2).'s';
// $zbsQPI['retrieveCustomers3'] = zeroBSCRM_mtime_float();
// } ===============================================================
// } filter post-query
// } ===============================================================
$x = 0;
if ( count( $potentialCustomerList ) > 0 ) {
foreach ( $potentialCustomerList as $potentialCustomer ) {
// } Innocent until proven...
$includeThisCustomer = true;
// } Stops excess queries
// $botheredAboutQuotes = false; if (isset($appliedFilters['hasquote']) && $appliedFilters['hasquote']) $botheredAboutQuotes = true;
// $botheredAboutInvs = false; if (isset($appliedFilters['hasinv']) && $appliedFilters['hasinv']) $botheredAboutInvs = true;
// $botheredAboutTransactions = false; if (isset($appliedFilters['hastransact']) && $appliedFilters['hastransact']) $botheredAboutTransactions = true;
// } Need them all, whatever, for total value etc.
$botheredAboutQuotes = true;
$botheredAboutInvs = true;
$botheredAboutTransactions = true;
// } Retrieve full cust
// $fullCustomer = zeroBS_getCustomer($potentialCustomer->ID,$botheredAboutQuotes,$botheredAboutInvs,$botheredAboutTransactions);
// } Optimised away from this :)
$fullCustomer = $potentialCustomer;
// } Require email?
if ( isset( $appliedFilters['require_email'] ) ) {
if ( ! zeroBSCRM_validateEmail( $fullCustomer['email'] ) ) {
$includeThisCustomer = false;
}
}
// } Status
if ( isset( $appliedFilters['status'] ) && ! empty( $appliedFilters['status'] ) ) {
// } Check status
if ( $appliedFilters['status'] != $fullCustomer['status'] ) {
$includeThisCustomer = false;
}
}
// } Source - ASSUMES is CF1!!!
if ( isset( $appliedFilters['source'] ) && ! empty( $appliedFilters['source'] ) ) {
// } Check Source
if ( $appliedFilters['source'] != $fullCustomer['cf1'] ) {
$includeThisCustomer = false;
}
}
// } Postcode (can be AL1* etc.)
if ( isset( $appliedFilters['postcode'] ) && ! empty( $appliedFilters['postcode'] ) ) {
// } Remove spaces from both
$cleanPostcode = str_replace( ' ', '', $fullCustomer['postcode'] );
$filterPostcode = str_replace( ' ', '', $appliedFilters['postcode'] );
// } Check Postcode
if ( ! str_starts_with( $cleanPostcode, $filterPostcode ) ) { // phpcs:ignore WordPress.NamingConventions.ValidVariableName.VariableNotSnakeCase
$includeThisCustomer = false;
}
}
// } Value From + To
// } Calc total
$totVal = zeroBS_customerTotalValue( $potentialCustomer['id'], $fullCustomer['invoices'], $fullCustomer['transactions'] );
// } Compare
if ( isset( $appliedFilters['valuefrom'] ) && ! empty( $appliedFilters['valuefrom'] ) ) {
// } If less than valuefrom, then remove
if ( $totVal < $appliedFilters['valuefrom'] ) {
$includeThisCustomer = false;
}
}
if ( isset( $appliedFilters['valueto'] ) && ! empty( $appliedFilters['valueto'] ) ) {
// } If more than valueto, then remove
if ( $totVal > $appliedFilters['valueto'] ) {
$includeThisCustomer = false;
}
}
// } Has Quote, inv, transaction
if ( isset( $appliedFilters['hasquote'] ) && $appliedFilters['hasquote'] && count( $fullCustomer['quotes'] ) < 1 ) {
$includeThisCustomer = false;
}
if ( isset( $appliedFilters['hasinv'] ) && $appliedFilters['hasinv'] && count( $fullCustomer['invoices'] ) < 1 ) {
$includeThisCustomer = false;
}
if ( isset( $appliedFilters['hastransact'] ) && $appliedFilters['hastransact'] && count( $fullCustomer['transactions'] ) < 1 ) {
$includeThisCustomer = false;
}
// } Finally... include or not?
if ( $includeThisCustomer ) {
$endingCustomerList[] = $fullCustomer;
}
}
}
// } ===============================================================
// } / end filter post-query
// } ===============================================================
// } External source/id (LATER)
// 'meta_key' => 'zbs_customer_ext_'.$approvedExternalSource,
// 'meta_value' => $externalID
// } Set as global
$zbsCustomerFiltersCurrentList = $endingCustomerList;
} else { // } / end of "is already cached/not needed"
// } Use cached list
$endingCustomerList = $zbsCustomerFiltersCurrentList;
}
// } Do paging (lol wrong end) #postpaging
if ( ! $forcePaging ) {
// } Per Page
if ( $perPage < 0 ) {
$perPage = 10;
} else {
$perPage = (int) $perPage;
}
// } Offset
$thisOffset = 0;
$actualPage = $page - 1;
if ( $actualPage < 0 ) {
$actualPage = 0;
}
if ( $actualPage > 0 ) {
$thisOffset = $perPage * $actualPage;
}
// } Anything to do?
if ( isset( $thisOffset ) ) {
// } SLICE
$endingCustomerList = array_slice( $endingCustomerList, $thisOffset, $perPage );
}
}
// DEBUG echo 'endingCustomerList
'; print_r($endingCustomerList); echo '
';
// } QPI
// $zbsQPI['retrieveCustomers3'] = round(zeroBSCRM_mtime_float() - #$zbsQPI['retrieveCustomers3'],2).'s';
// } Return
return $endingCustomerList;
}
// } Only used by AJAX, also returns top X customers :)
function zeroBS__customerFiltersRetrieveCustomerCountAndTopCustomers( $countToReturn = 3 ) {
// } REQUIRES that zbs_customerFiltersRetrieveCustomers has been run BEFORE this
global $zbsCustomerFiltersCurrentList;
if ( isset( $zbsCustomerFiltersCurrentList ) && is_array( $zbsCustomerFiltersCurrentList ) ) {
// } return
return array(
'count' => count( $zbsCustomerFiltersCurrentList ),
'top' => array_slice( $zbsCustomerFiltersCurrentList, 0, $countToReturn ),
);
} else {
// } Run - without params it'll return first page, but retrieve all into cache var (what we need for count)
$zbsCustomersFiltered = zbs_customerFiltersRetrieveCustomers();
// } return count
return array(
'count' => count( $zbsCustomerFiltersCurrentList ),
'top' => array_slice( $zbsCustomersFiltered, 0, $countToReturn ),
);
}
}
/*
======================================================
/ Customer Filter Funcs
====================================================== */