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;
}
