document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. $oSelect->where("weekno <= ?", $iEndWeekNo);
  2. $oSelect->where("year = ?", $iEndYear);
  3. $oSelect->where("day = ?", $day);
  4.  
  5. //(weekno <= ? and year = ? and day=?)
  6. $oCond1 = $oSelect->getPart(Zend_Db_Select::WHERE);
  7. $oSelect->reset(Zend_Db_Select::WHERE);
  8.    
  9. $oSelect->where("year < ?", $iEndYear);
  10. $oSelect->where("day = ?", $day);
  11.  
  12. //year < ? and day = ?
  13. $oCond2 = $oSelect->getPart(Zend_Db_Select::WHERE);
  14. $oSelect->reset(Zend_Db_Select::WHERE);
  15.  
  16. //(weekno <= ? and year = ? and day=?) or (year < ? and day = ?)
  17. $oSelect->where(implode(" ", $oCond1));
  18. $oSelect->orWhere(implode(" ", $oCond2));
  19.    
  20. $oMixCond = $oSelect->getPart(Zend_Db_Select::WHERE);
  21. $oSelect->reset(Zend_Db_Select::WHERE);
  22.  
  23. groupid=? and ((weekno <= ? and year = ? and day=?) or (year < ? and day = ?))
  24. $oSelect->where("groupid=?", $groupid);
  25. $oSelect->where(implode(" ", $oMixCond));
');