<?php //cid.php v5.0.0 setlocale(LC_ALL, 'ru_RU'); require_once 'config.php'; require_once OLIB_PATH . '/class.ad.php'; require_once OLIB_PATH . '/class.session.php'; require_once 'lib5.php'; $tpl =& initFastTemplate(); $tpl->define(array('pc_table' => 'body.pc.table_head.tpl')); $ses = new Session(TRUE); $tpl->assign('MESSAGE', $ses->msg()); if (isset($_GET['sort'])) { $sort = $_GET['sort']; } else { $sort = 'cn'; } $tpl->parse('TABLE_TEXT', 'pc_table'); $users = new Request5(); $users->findBy(); $users->findBy('pid = 0'); $users->range(mktime(0, 0, 0, 2, 1, 2014), 86400 * 31); //$users->findBy('saprname="Korzhov_OV"'); $users->_execute(); echo $users->count; $tpl->parse('BODY', 'table'); $tpl->parse('PAGE', 'page'); $tpl->FastPrint();
$reqData->rowCount(ROWS_PER_PAGE); $login = $ses->valueOf('filter.user') ? $ses->valueOf('filter.user') : $ses->login(); // $login = $ses->login(); // $q_user = "******"; $q_user = "******"; $q_sapr = " SELECT pid as rid FROM {$reqtable} \n\t\t\t WHERE NOT(pid IS NULL OR pid=0) AND \n\t\t\t\t (saprname='{$login}' OR username='******' OR username2='{$login}')\n\t\t\t UNION\n\t\t\t SELECT rid as rid FROM {$reqtable}\n\t\t\t WHERE (pid IS NULL OR pid=0) \n\t\t\t\tAND username='******' OR targetname='{$login}' OR curator='{$login}'"; $done = OREQ_DONE; $timeout = OREQ_TIMEOUT; $q_done = " SELECT rid FROM {$reqtable}\n\t\t\t WHERE \n\t\t\t !(rid IN (SELECT pid FROM {$reqtable} WHERE NOT(pid IS NULL OR pid=0) AND (result<>{$done} AND result<>{$timeout}))) AND \n\t\t\t (pid IS NULL OR pid=0) AND \n\t\t\t result <> {$done}"; $q_fulltext = " SELECT id FROM {$fts} WHERE MATCH (text) AGAINST ('" . $ses->valueOf('filter.fulltext') . "' IN BOOLEAN MODE)"; if ($groupWebSAPR->isMember($ses->login())) { if (!$myreq) { if ($donereq) { $reqData->where("rid in ({$q_done})"); $reqData->_execute(); } else { if ($ses->valueOf('filter.fulltext')) { $reqData->where("rid in ({$q_fulltext})"); $reqData->_execute(); } else { $reqData->retrive(false); } } } else { // $reqData->where("rid in ($q_sapr)"); $reqData->_from("({$q_sapr}) as t"); $reqData->where("{$reqtable}.rid=t.rid"); $reqData->_execute(); } } else {