/home/techb158/public_html/wp-content/plugins/kirki/includes
Edit: /home/techb158/public_html/wp-content/plugins/kirki/includes/DbQueryUtils.php (5313B)
esc_like( $str );
$like = $wild . $esc_str . $wild;
return $wpdb->prepare( '%1s LIKE %s', array( $column, $like ) );
}
/**
* Does_not_contain query builder
*
* @param string $column The name of the column.
* @param string $str which string needs to find.
* @return string
*/
public static function does_not_contain( $column, $str ) {
global $wpdb;
$wild = '%';
$esc_str = $wpdb->esc_like( $str );
$like = $wild . $esc_str . $wild;
return $wpdb->prepare( '%1s NOT LIKE %s', array( $column, $like ) );
}
/**
* Start_with query builder
*
* @param string $column The name of the column.
* @param string $str which string needs to find.
* @return string
*/
public static function start_with( $column, $str ) {
global $wpdb;
$wild = '%';
$esc_str = $wpdb->esc_like( $str );
$like = $esc_str . $wild;
return $wpdb->prepare( '%1s LIKE %s', array( $column, $like ) );
}
/**
* End_with query builder
*
* @param string $column The name of the column.
* @param string $str which string needs to find.
* @return string
*/
public static function end_with( $column, $str ) {
global $wpdb;
$wild = '%';
$esc_str = $wpdb->esc_like( $str );
$like = $wild . $esc_str;
return $wpdb->prepare( '%1s LIKE %s', array( $column, $like ) );
}
/**
* Is query builder
*
* @param string $column The name of the column.
* @param string $str which string needs to find.
* @return string
*/
public static function is( $column, $str ) {
global $wpdb;
$esc_str = $wpdb->esc_like( $str );
return $wpdb->prepare( '%1s LIKE %s', array( $column, $esc_str ) );
}
/**
* Is_not query builder
*
* @param string $column The name of the column.
* @param string $str which string needs to find.
* @return string
*/
public static function is_not( $column, $str ) {
global $wpdb;
$esc_str = $wpdb->esc_like( $str );
return $wpdb->prepare( '%1s NOT LIKE %s', array( $column, $esc_str ) );
}
/**
* Cell_is_not_empty query builder
*
* @param string $column The name of the column.
* @return string
*/
public static function cell_is_not_empty( $column ) {
global $wpdb;
return $wpdb->prepare( "%1s <> '' OR %1s <> NULL", array( $column, $column ) );
}
/**
* Cell_is_empty query builder
*
* @param string $column The name of the column.
* @return string
*/
public static function cell_is_empty( $column ) {
global $wpdb;
return $wpdb->prepare( "%1s = '' OR %1s = NULL", array( $column, $column ) );
}
/**
* Today query builder
*
* @param string $column The name of the column.
* @return string
*/
public static function today( $column ) {
global $wpdb;
return $wpdb->prepare( 'DATE(%1s) = %s', array( $column, gmdate( 'Y-m-d' ) ) );
}
/**
* This_week query builder
*
* @param string $column The name of the column.
* @return string
*/
public static function this_week( $column ) {
global $wpdb;
return $wpdb->prepare( 'WEEK(%1s) = %d AND YEAR(%1s) = %d', array( $column, (int) gmdate( 'W' ), $column, (int) gmdate( 'Y' ) ) );
}
/**
* Last_month query builder
*
* @param string $column The name of the column.
* @return string
*/
public static function last_month( $column ) {
global $wpdb;
return $wpdb->prepare( 'YEAR(%1s) = YEAR(CURRENT_DATE - INTERVAL 1 MONTH) AND MONTH(%1s) = MONTH(CURRENT_DATE - INTERVAL 1 MONTH)', array( $column, $column ) );
}
/**
* Last_year query builder
*
* @param string $column The name of the column.
* @return string
*/
public static function last_year( $column ) {
global $wpdb;
return $wpdb->prepare( 'YEAR(%1s) - 1 = %d', array( $column, (int) gmdate( 'Y' ) - 1 ) );
}
/**
* Between query builder
*
* @param string $column The name of the column.
* @param string $start start time.
* @param string $end end time.
* @return string
*/
public static function between( $column, $start, $end ) {
global $wpdb;
$start_time = gmdate( 'Y-m-d', strtotime( $start ) );
$end_time = gmdate( 'Y-m-d', strtotime( $end ) );
return $wpdb->prepare( '%1s BETWEEN %s AND %s', array( $column, $start_time, $end_time ) );
}
/**
* Before query builder
*
* @param string $column The name of the column.
* @param string $date date.
* @return string
*/
public static function before( $column, $date ) {
global $wpdb;
$date = gmdate( 'Y-m-d', strtotime( $date ) );
return $wpdb->prepare( 'DATE(%1s) < %s', array( $column, $date ) );
}
/**
* Start_with query builder
*
* @param string $column The name of the column.
* @param string $date date.
* @return string
*/
public static function after( $column, $date ) {
global $wpdb;
$date = gmdate( 'Y-m-d', strtotime( $date ) );
return $wpdb->prepare( 'DATE(%1s) > %s', array( $column, $date ) );
}
}