class-wpml-st-db-mappers-string-positions.php
1.86 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
<?php
class WPML_ST_DB_Mappers_String_Positions {
/**
* @var wpdb
*/
private $wpdb;
/**
* @param wpdb $wpdb
*/
public function __construct( wpdb $wpdb ) {
$this->wpdb = $wpdb;
}
/**
* @param int $string_id
* @param int $kind
*
* @return int
*/
public function get_count_of_positions_by_string_and_kind( $string_id, $kind ) {
$query = "
SELECT COUNT(id)
FROM {$this->wpdb->prefix}icl_string_positions
WHERE string_id = %d AND kind = %d
";
/** @var string $sql */
$sql = $this->wpdb->prepare( $query, $string_id, $kind );
return (int) $this->wpdb->get_var( $sql );
}
/**
* @param int $string_id
* @param int $kind
*
* @return array
*/
public function get_positions_by_string_and_kind( $string_id, $kind ) {
$query = "
SELECT position_in_page
FROM {$this->wpdb->prefix}icl_string_positions
WHERE string_id = %d AND kind = %d
";
/** @var string $sql */
$sql = $this->wpdb->prepare( $query, $string_id, $kind );
return $this->wpdb->get_col( $sql );
}
/**
* @param int $string_id
* @param string $position
* @param int $kind
*
* @return bool
*/
public function is_string_tracked( $string_id, $position, $kind ) {
$query = "
SELECT id
FROM {$this->wpdb->prefix}icl_string_positions
WHERE string_id=%d AND position_in_page=%s AND kind=%s
";
/** @var string $sql */
$sql = $this->wpdb->prepare( $query, $string_id, $position, $kind );
return (bool) $this->wpdb->get_var( $sql );
}
/**
* @param int $string_id
* @param string $position
* @param int $kind
*/
public function insert( $string_id, $position, $kind ) {
$this->wpdb->insert( $this->wpdb->prefix . 'icl_string_positions', array(
'string_id' => $string_id,
'kind' => $kind,
'position_in_page' => $position,
) );
}
}