/**
* Функция для заполнения суперчека.
*
* @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);
}
