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