/**
* Обновляем старые сделки
*/
public static function checkStagePayoutsCompleted()
{
$db = new DB('master');
$sql = "SELECT sp.*, ss.sbr_id, ss.num, pl.lc_id, u.role, s.emp_id, s.frl_id, pl.state as lc_state \n FROM sbr_stages_payouts sp \n INNER JOIN sbr_stages ss ON ss.id = sp.stage_id\n INNER JOIN sbr s ON s.id = ss.sbr_id\n INNER JOIN pskb_lc pl ON pl.sbr_id = s.id\n INNER JOIN users u ON u.uid = sp.user_id\n WHERE s.scheme_type = ?i AND sp.bank_completed IS NULL AND sp.completed IS NOT NULL";
$data = $db->rows($sql, sbr::SCHEME_LC);
$pskb = new pskb();
foreach ($data as $row) {
$pskb_lc = $pskb->_historyLC($row['lc_id'], sbr_stages::getOuterNum($row['sbr_id'], $row['num']), is_emp($row['role']) ? false : true);
$sbr = new sbr($row['emp_id']);
$stage = $sbr->getStage($row['stage_id']);
$stage->payoutUpdateState($pskb_lc);
}
}
$sbr_data['cost_sys'] = $sbr_data['ps_emp'] ? pskb::$exrates_map[$sbr_data['ps_emp']] : $sbr_data['cost_sys'];
?>
<tr class="<?php
echo ++$i % 2 == 0 ? 'even' : 'odd';
?>
">
<td><?php
echo $sbr_data['first_time'] ? date('d.m.Y H:i', strtotime($sbr_data['first_time'])) : ' — ';
?>
</td>
<td><?php
echo $sbr->getContractNum($sbr_data['sbr_id'], $sbr_data['scheme_type']);
?>
</td>
<td><strong>#<?php
echo sbr_stages::getOuterNum($sbr_data['sbr_id'], $sbr_data['num']);
?>
</strong> <a href="<?php
echo $mode == 'all' ? '/sbr/' : '';
?>
?access=A&site=Stage&id=<?php
echo $sbr_data['id'];
?>
"><?php
echo reformat($sbr_data['name'], 30, 0, 1);
?>
</a></td>
<td class="nr-a-td-sum"><?php
echo sbr_meta::view_cost($sbr_data['cost'], null, false);
?>
</td>
<td class="nr-a-o-date"><?php
echo date('d.m.Y H:i', strtotime($sp['requested']));
?>
</td>
<td><?php
echo $sbr->getContractNum($sp['sbr_id'], $sp['scheme_type']);
?>
</td>
<td class="nr-a-o-num"><?php
echo $sp['is_arbitrage'] == 't' ? '<b>А</b> ' : '';
?>
<a href="/sbr/?access=A&site=Stage&id=<?php
echo $sp['stage_id'];
?>
">#<?php
echo sbr_stages::getOuterNum($sp['sbr_id'], $sp['stage_num']);
?>
</a></td>
<td><a href="/users/<?php
echo $sp['login'];
?>
/" class="nr-a-lnk-<?php
echo is_emp($sp['role']) ? 'emp' : 'frl';
?>
"><?php
echo $sp['uname'] . ' ' . $sp['usurname'] . ' [' . $sp['login'] . ']';
?>
</a></td>
<td class="nr-a-td-sum"><?php
echo sbr_meta::view_cost($sp['credit_sum'], NULL, false);
?>
