function zayav_spisok($v) { $filter = zayavFilter($v); $filter = _filterJs('ZAYAV', $filter); define('ZAYAV_PAGE1', $filter['page'] == 1); $page = $filter['page']; $limit = $filter['limit']; $cond = "`ws_id`=" . WS_ID . " AND !`deleted`"; $nomer = 0; if ($filter['find']) { $engRus = _engRusChar($filter['find']); $cond .= " AND (`find` LIKE '%" . $filter['find'] . "%'" . ($engRus ? " OR `find` LIKE '%" . $engRus . "%'" : '') . ")"; $reg = '/(' . $filter['find'] . ')/i'; if ($engRus) { $regEngRus = '/(' . $engRus . ')/i'; } if (ZAYAV_PAGE1 && _num($filter['find'])) { $nomer = intval($filter['find']); } } else { if ($filter['client_id']) { $cond .= " AND `client_id`=" . $filter['client_id']; } if ($filter['status']) { $cond .= " AND `status`=" . $filter['status']; } } $sql = "SELECT COUNT(*) FROM `zayav` WHERE " . $cond; $all = query_value($sql); $zayav = array(); if ($nomer) { $sql = "SELECT * FROM `zayav` WHERE `ws_id`=" . WS_ID . " AND `nomer`=" . $nomer; if ($r = query_assoc($sql)) { $all++; $limit--; $r['nomer_find'] = 1; $zayav[$r['id']] = $r; } } if (!$all) { return array('all' => 0, 'result' => 'Заявок не найдено' . $filter['clear'], 'spisok' => $filter['js'] . '<div class="_empty">Заявок не найдено</div>', 'filter' => $filter); } $send = array('all' => $all, 'result' => 'Показан' . _end($all, 'а', 'о') . ' ' . $all . ' заяв' . _end($all, 'ка', 'ки', 'ок') . $filter['clear'], 'spisok' => $filter['js'], 'filter' => $filter); $sql = "SELECT\n\t *,\n\t '' `note`\n\t\t\tFROM `zayav`\n\t\t\tWHERE " . $cond . "\n\t\t\tORDER BY `" . ($filter['sort'] == 2 ? 'status_dtime' : 'dtime_add') . "` " . ($filter['desc'] ? 'ASC' : 'DESC') . "\n\t\t\tLIMIT " . _startLimit($filter); $q = query($sql); while ($r = mysql_fetch_assoc($q)) { if ($nomer == $r['nomer']) { continue; } $zayav[$r['id']] = $r; } if (!$filter['client_id']) { $zayav = _clientValToList($zayav); } //Заметки $sql = "SELECT\n\t\t\t\t`table_id`,\n\t\t\t\t`txt`\n\t\t\tFROM `vk_comment`\n\t\t\tWHERE `table_name`='zayav'\n\t\t\t AND `table_id` IN (" . implode(',', array_keys($zayav)) . ")\n\t\t\t AND `status`\n\t\t\tORDER BY `id` ASC"; $q = query($sql); while ($r = mysql_fetch_assoc($q)) { $zayav[$r['table_id']]['note'] = $r['txt']; } foreach ($zayav as $id => $r) { $diff = round($r['accrual_sum'] - $r['income_sum'], 2); $send['spisok'] .= '<div class="zayav_unit" id="u' . $id . '"' . _zayavStatus($r['status'], 'bg') . '" val="' . $id . '">' . '<h2' . (isset($r['nomer_find']) ? ' class="finded"' : '') . '>#' . $r['nomer'] . '</h2>' . '<a class="name">' . $r['name'] . '</a>' . '<table class="utab">' . (!$filter['client_id'] ? '<tr><td class="label">Клиент:<td>' . $r['client_go'] : '') . '<tr><td class="label">Дата подачи:' . '<td>' . FullData($r['dtime_add'], 1) . ($r['status'] == 2 ? '<b class="date-ready' . _tooltip('Дата выполнения', -47) . FullData($r['status_dtime'], 1, 1) . '</b>' : '') . (round($r['accrual_sum'], 2) || round($r['income_sum'], 2) ? '<div class="balans' . ($diff ? ' diff' : '') . '">' . '<span class="acc' . _tooltip('Начислено', -39) . round($r['accrual_sum'], 2) . '</span>/' . '<span class="opl' . _tooltip($diff ? ($diff > 0 ? 'Недо' : 'Пере') . 'плата ' . abs($diff) . ' руб.' : 'Оплачено', -17, 'l') . round($r['income_sum'], 2) . '</span>' . '</div>' : '') . '</table>' . '<div class="note">' . @$r['note'] . '</div>' . '</div>'; } $send['spisok'] .= _next($filter + array('type' => 2, 'all' => $all)); return $send; }
function action($d) { global $theA, $theB, $EOF; switch ($d) { case 1: put($theA); case 2: $theA = $theB; if ($theA == ord("\\'") || $theA == ord('"')) { for (;;) { put($theA); $theA = get(); if ($theA == $theB) { break; } if (ord($theA) <= ord("\n")) { printf("Error: JSMIN unterminated string literal: %c\n", $theA); exit(1); } if ($theA == ord("\\")) { put($theA); $theA = get(); } } } case 3: $theB = _next(); if ($theB == ord("/") && ($theA == ord("(") || $theA == ord(",") || $theA == ord("="))) { put($theA); put($theB); for (;;) { $theA = get(); if ($theA == ord("/")) { break; } else { if ($theA == ord("\\")) { put($theA); $theA = get(); } else { if ($theA <= ord("\n")) { printf("Error: JSMIN unterminated Regular Expression literal.\n", $theA); exit(1); } } } put($theA); } $theB = _next(); } } }