Example #1
0
 /**
  * Обновляем старые сделки.
  */
 public static function checkStagePayoutsCompleted()
 {
     $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
             WHERE s.scheme_type = ?i AND sp.bank_completed IS NULL AND sp.completed IS NOT NULL';
     $data = $db->rows($sql, sbr::SCHEME_LC);
     $pskb = new self();
     foreach ($data as $row) {
         $pskb_lc = $pskb->_historyLC($row['lc_id'], sbr_stages::getOuterNum($row['sbr_id'], $row['num']), is_emp($row['role']) ? false : true);
         $sbr = new sbr($row['emp_id']);
         $stage = $sbr->getStage($row['stage_id']);
         $stage->payoutUpdateState($pskb_lc);
     }
 }