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 \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"; 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 pskb(); $pskb->_SuperCheck($list); // Супер пупер чек return false; }