Ejemplo n.º 1
0
 * nbbuild/licenses/CDDL-GPL-2-CP.  Oracle designates this
 * particular file as subject to the "Classpath" exception as provided
 * by Oracle in the GPL Version 2 section of the License file that
 * accompanied this code. If applicable, add the following below the
 * License Header, with the fields enclosed by brackets [] replaced by
 * your own identifying information:
 * "Portions Copyrighted [year] [name of copyright owner]"
 *
 * If you wish your version of this file to be governed by only the CDDL
 * or only the GPL Version 2, indicate your decision by adding
 * "[Contributor] elects to include this software in this distribution
 * under the [CDDL or GPL Version 2] license." If you do not indicate a
 * single choice of license, a recipient has the option to distribute
 * your version of this file under either the CDDL, the GPL Version 2 or
 * to extend the choice of license to its licensees as provided above.
 * However, if you add GPL Version 2 code and therefore, elected the GPL
 * Version 2 license, then the option applies only if the new code is
 * made subject to such option by the copyright holder.
 *
 * Contributor(s):
 *
 * Portions Copyrighted 2011 Sun Microsystems, Inc.
 */
$status = Utils::getUrlParam('status');
TodoValidator::validateStatus($status);
$dao = new TodoDao();
$search = new TodoSearchCriteria();
$search->setStatus($status);
// data for template
$title = Utils::capitalize($status) . ' TODOs';
$todos = $dao->find($search);
Ejemplo n.º 2
0
 private function getFindSql(TodoSearchCriteria $search = null)
 {
     $sql = 'SELECT * FROM todo WHERE deleted = 0 ';
     $orderBy = ' priority, due_on';
     if ($search !== null) {
         if ($search->getStatus() !== null) {
             $sql .= 'AND status = ' . $this->getDb()->quote($search->getStatus());
             switch ($search->getStatus()) {
                 case Todo::STATUS_PENDING:
                     $orderBy = 'due_on, priority';
                     break;
                 case Todo::STATUS_DONE:
                 case Todo::STATUS_VOIDED:
                     $orderBy = 'due_on DESC, priority';
                     break;
                 default:
                     throw new Exception('No order for status: ' . $search->getStatus());
             }
         }
     }
     $sql .= ' ORDER BY ' . $orderBy;
     return $sql;
 }