1 | <?php |
||
15 | class Records |
||
16 | { |
||
17 | public const MAX_GET_RECORDS = 500; |
||
18 | public const MAX_POST_RECORDS = 100; |
||
19 | |||
20 | /** |
||
21 | * @var Client |
||
22 | */ |
||
23 | private $client; |
||
24 | |||
25 | 1 | public function __construct(Client $client) |
|
29 | |||
30 | /** |
||
31 | * Get records |
||
32 | * https://cybozudev.zendesk.com/hc/ja/articles/202331474#step2 |
||
33 | * |
||
34 | * @param integer $appId |
||
35 | * @param string $query |
||
36 | * @param integer $guestSpaceId |
||
37 | * @param boolean $totalCount |
||
38 | * @param array|null $fields |
||
39 | * @return array |
||
40 | */ |
||
41 | 3 | public function get($appId, $query = '', $guestSpaceId = null, $totalCount = true, array $fields = null): array |
|
42 | { |
||
43 | 3 | $options = ['json' => ['app' => $appId, 'query' => $query]]; |
|
44 | 3 | if ($totalCount) { |
|
45 | 3 | $options['json']['totalCount'] = $totalCount; |
|
46 | } |
||
47 | 3 | if ($fields) { |
|
48 | 2 | $options['json']['fields'] = $fields; |
|
49 | } |
||
50 | /** @var JsonStream $stream */ |
||
51 | 3 | $stream = $this->client |
|
52 | 3 | ->get(KintoneApi::generateUrl('records.json', $guestSpaceId), $options) |
|
53 | 3 | ->getBody(); |
|
54 | |||
55 | 3 | return $stream->jsonSerialize(); |
|
56 | } |
||
57 | |||
58 | /** |
||
59 | * Get all records |
||
60 | * |
||
61 | * @param integer $appId |
||
62 | * @param string $query |
||
63 | * @param integer $guestSpaceId |
||
64 | * @param array|null $fields |
||
65 | * @return array |
||
66 | */ |
||
67 | 1 | public function all($appId, $query = '', $guestSpaceId = null, array $fields = null): array |
|
68 | { |
||
69 | 1 | $result = []; |
|
70 | 1 | $result[0] = $this->get($appId, $query . ' limit ' . self::MAX_GET_RECORDS, $guestSpaceId, true, $fields); |
|
71 | 1 | $totalCount = $result[0]['totalCount']; |
|
72 | 1 | if ($totalCount <= self::MAX_GET_RECORDS) { |
|
73 | 1 | return $result[0]['records']; |
|
74 | } |
||
75 | |||
76 | 1 | $concurrency = $this->client->getConfig('concurrency'); |
|
77 | 1 | $requests = $this->createGetRequestsCallback($appId, $query, $guestSpaceId, $fields, $totalCount); |
|
78 | 1 | $pool = new Pool($this->client, $requests(), [ |
|
79 | 1 | 'concurrency' => $concurrency ?: 1, |
|
80 | 'fulfilled' => function (ResponseInterface $response, $index) use (&$result) { |
||
81 | /** @var JsonStream $stream */ |
||
82 | 1 | $stream = $response->getBody(); |
|
83 | 1 | $result[$index+1] = array_merge($stream->jsonSerialize()); |
|
84 | 1 | } |
|
85 | ]); |
||
86 | 1 | $pool->promise()->wait(); |
|
87 | |||
88 | 1 | return $this->convertResponseToRecords($result); |
|
89 | } |
||
90 | |||
91 | /** |
||
92 | * @param integer $appId |
||
93 | * @param string $query |
||
94 | * @param integer $guestSpaceId |
||
95 | * @param array|null $fields |
||
96 | * @param integer $totalCount |
||
97 | * @return \Closure |
||
98 | */ |
||
99 | 1 | private function createGetRequestsCallback($appId, $query, $guestSpaceId, $fields, $totalCount): callable |
|
100 | { |
||
101 | 1 | $headers = $this->client->getConfig('headers'); |
|
102 | 1 | $headers['Content-Type'] = 'application/json'; |
|
103 | return function () use ($appId, $query, $guestSpaceId, $fields, $totalCount, $headers) { |
||
104 | 1 | $num = ceil($totalCount / self::MAX_GET_RECORDS); |
|
105 | 1 | for ($i = 1; $i < $num; $i++) { |
|
106 | $body = [ |
||
107 | 1 | 'app' => $appId, |
|
108 | 1 | 'query' => $query . ' limit ' . self::MAX_GET_RECORDS . ' offset ' . $i * self::MAX_GET_RECORDS, |
|
109 | ]; |
||
110 | 1 | if ($fields) { |
|
111 | 1 | $body['fields'] = $fields; |
|
112 | } |
||
113 | 1 | yield new Request( |
|
114 | 1 | 'GET', |
|
115 | 1 | KintoneApi::generateUrl('records.json', $guestSpaceId), |
|
116 | 1 | $headers, |
|
117 | 1 | \GuzzleHttp\json_encode($body) |
|
118 | ); |
||
119 | } |
||
120 | 1 | }; |
|
121 | } |
||
122 | |||
123 | /** |
||
124 | * @param array $result |
||
125 | * @return array |
||
126 | */ |
||
127 | 1 | private function convertResponseToRecords(array $result): array |
|
128 | { |
||
129 | 1 | ksort($result); |
|
130 | 1 | $allRecords = []; |
|
131 | 1 | foreach ($result as $r) { |
|
132 | /** @var array $records */ |
||
133 | 1 | $records = $r['records']; |
|
134 | 1 | foreach ($records as $record) { |
|
135 | 1 | $allRecords[] = $record; |
|
136 | } |
||
137 | } |
||
138 | |||
139 | 1 | return $allRecords; |
|
140 | } |
||
141 | |||
142 | /** |
||
143 | * Post records |
||
144 | * https://cybozudev.zendesk.com/hc/ja/articles/202166160#step2 |
||
145 | * |
||
146 | * @param integer $appId |
||
147 | * @param array $records |
||
148 | * @param integer $guestSpaceId |
||
149 | * @return array |
||
150 | */ |
||
151 | 2 | public function post($appId, array $records, $guestSpaceId = null): array |
|
162 | |||
163 | /** |
||
164 | * Put records |
||
165 | * https://cybozudev.zendesk.com/hc/ja/articles/201941784#step2 |
||
166 | * |
||
167 | * @param integer $appId |
||
168 | * @param array $records |
||
169 | * @param integer $guestSpaceId |
||
170 | * @return array |
||
171 | */ |
||
172 | 1 | public function put($appId, array $records, $guestSpaceId = null): array |
|
183 | |||
184 | /** |
||
185 | * Delete records |
||
186 | * https://cybozudev.zendesk.com/hc/ja/articles/201941794 |
||
187 | * |
||
188 | * @param integer $appId |
||
189 | * @param array $ids |
||
190 | * @param integer $guestSpaceId |
||
191 | * @param array $revisions |
||
192 | * @return array |
||
193 | */ |
||
194 | 1 | public function delete($appId, array $ids, $guestSpaceId = null, array $revisions = []): array |
|
208 | |||
209 | /** |
||
210 | * Put records status |
||
211 | * https://cybozudev.zendesk.com/hc/ja/articles/204791550#anchor_changeRecordStatusBulk |
||
212 | * |
||
213 | * @param integer $appId |
||
214 | * @param array $records |
||
215 | * @param integer $guestSpaceId |
||
216 | * @return array |
||
217 | */ |
||
218 | 1 | public function putStatus($appId, array $records, $guestSpaceId = null): array |
|
229 | } |
||
230 |