/** * Обновляем старые сделки */ 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); ?>