<?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 {
