public static function checkStagePayoputForSuperCheck($ids = array(), &$cntIn = 0, &$cntOut = 0) { $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 FROM sbr_stages_payouts sp INNER JOIN sbr_stages ss ON ss.id = sp.stage_id INNER JOIN sbr s ON s.id = ss.sbr_id INNER JOIN pskb_lc pl ON pl.sbr_id = s.id INNER JOIN users u ON u.uid = sp.user_id'; if ($ids) { $sql .= ' WHERE sp.stage_id IN (?l)'; $data = $db->rows($sql, $ids); } else { $sql .= " WHERE s.scheme_type = ?i \n AND sp.state = 'trans' \n AND ( sp.completed IS NULL OR (requested > NOW() - '" . self::PERIOD_BANK_CHECK . "'::interval AND credit_sys = ?i) )"; $data = $db->rows($sql, sbr::SCHEME_LC, exrates::BANK); } if (!$data) { return false; } $cntIn = count($data); $list = array(); foreach ($data as $lsrow) { $list[] = intval($lsrow['lc_id']); } $pskb = new self(); $pskb->_SuperCheck($list); // Супер пупер чек return false; }