Lines Matching refs:row
157 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
158 $sqlite->storeEntry('label', array('id' => $row['id'],
159 'name' => $row['pl'],
165 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
166 $sqlite->storeEntry('task_program', array('id' => $row['id'],
167 'name' => $row['pl'],
174 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
175 if ($row['type'] == '0') {
177 } elseif ($row['type'] == '1') {
179 } elseif ($row['type'] == '2') {
183 array('id' => $row['id'],
184 'thread_id' => $row['issue'],
186 'author' => $row['reporter'],
187 'create_date' => date('c', strtotime($row['datetime'])),
188 'last_modification_date' => date('c', strtotime($row['datetime'])),
189 'content' => $row['content'],
190 'content_html' => $row['content_cache'],
191 'task_count' => $row['task_count']));
199 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
200 if ($row['close_date'] != '') {
201 $last_mod = date('c', (int) $row['close_date']);
203 $last_mod = date('c', (int) $row['date']);
206 $data = array('id' => $row['id'],
207 'original_poster' => $row['reporter'],
208 'assignee' => $row['executor'],
209 'create_date' => date('c', (int) $row['date']),
212 'plan_date' => $row['plan_date'],
213 'all_day_event' => $row['all_day_event'],
214 'start_time' => $row['start_time'],
215 'finish_time' => $row['finish_time'],
216 'content' => $row['task'],
217 'content_html' => $row['task_cache'],
218 'thread_id' => $row['issue'],
219 'thread_comment_id' => $row['cause'],
220 'task_program_id' => $row['tasktype']
227 $task_assignee[$data['thread_id']][$row['executor']] = $row['executor'];
230 if ($row['cost'] != '0') {
231 $data['cost'] = $row['cost'];
234 if ($row['issue'] == '') {
236 } elseif ($row['cause'] == '') {
238 } elseif ($row['cause_type'] == '1') {
244 if ($row['state'] == '0') {
246 } elseif ($row['state'] == '1' || $row['state'] == '2') {
248 $data['closed_by'] = $row['executor'];
249 $data['close_date'] = date('c', (int) $row['close_date']);
251 if ($row['reason'] != '') {
253 array('task_id' => $row['id'],
254 'author' => $row['executor'],
257 'content' => $row['reason'],
258 'content_html' => $row['reason_cache']));
264 $subscribents = explode(',', $row['subscribents']);
284 $part['task_id'] = $row['id'];
308 while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
310 $data = array('id' => $row['id'],
311 'original_poster' => $row['reporter'],
312 'coordinator' => $row['coordinator'],
313 'create_date' => date('c', (int) $row['date']),
314 'last_activity_date' => date('c', strtotime($row['last_activity'])),
315 'last_modification_date' => date('c', (int) $row['last_mod']),
316 'title' => $row['title'],
317 'content' => $row['description'],
318 'content_html' => $row['description_cache'],
319 'task_count' => $row['task_count'],
320 'task_count_closed' => $row['task_closed_count']
323 if ($row['task_sum_cost'] != '0') {
324 $data['task_sum_cost'] = $row['task_sum_cost'];
327 if ($row['coordinator'] == '') {
329 } elseif ($row['state'] == '1') {
330 $data['closed_by'] = $row['coordinator'];
335 array('thread_id' => $row['id'],
337 'author' => $row['coordinator'],
340 'content' => $row['opinion'],
341 'content_html' => $row['opinion_cache']));
344 } elseif ($row['state'] == '2') {
345 $data['closed_by'] = $row['coordinator'];
349 if ($row['opinion'] != '') {
351 array('thread_id' => $row['id'],
353 'author' => $row['coordinator'],
356 'content' => $row['opinion'],
357 'content_html' => $row['opinion_cache']));
369 array('thread_id' => $row['id'],
370 'label_id' => $row['type']));
375 $org_participants = array_filter(explode(',', $row['participants']));
380 $subscribents = array_filter(explode(',', $row['subscribents']));
388 $stmt_i = $bez->query('SELECT reporter FROM commcauses WHERE issue=' . $row['id']);
397 if (is_array($task_assignee[$row['id']])) foreach ($task_assignee[$row['id']] as $user_id) {
419 $part['thread_id'] = $row['id'];