/** * Функция для заполнения суперчека. * * @global type $DB * * @return type */ public static function fillingSuperCheck() { global $DB; if (!is_release()) { return true; } $sql = "SELECT lc_id, ( ss.sbr_id || '-' || (ss.num + 1) )::text as uid, (CASE WHEN s.emp_id = ssp.user_id THEN false ELSE true END ) as target\n FROM sbr_stages_payouts ssp\n INNER JOIN sbr_stages ss ON ss.id = ssp.stage_id\n INNER JOIN sbr s ON s.id = ss.sbr_id\n INNER JOIN pskb_lc p ON p.sbr_id = ss.sbr_id\n WHERE requested::date >= '2012-11-01' AND requested::date <= '2012-12-19'\n EXCEPT\n SELECT lc_id, uid, target FROM pskb_lc_supercheck\n ORDER BY uid\n LIMIT 200;"; $lc_ids = $DB->col($sql); $pskb = new self(); return $pskb->getSuperCheck($lc_ids); }