PHP Model_Users::fetchAll方法代碼示例

 /**
  * fetch all admin users
  * 
  * @return array
  */
 public function fetchAll()
 {
     $select = $this->select();
     $select->order('CONCAT(firstName, " ", lastName) ASC');
     $select->where('userId IN (SELECT userId from users_admins)');
     $users = parent::fetchAll($select);
     foreach ($users as $user) {
         $user = $this->makePublic($user);
     }
     return $users;
 }

 public function indexAction()
 {
     parent::init();
     $view = Zend_Registry::get('view');
     $view->headTitle($this->t->_('Dashboard'));
     $modelUsers = new Model_Users();
     $modelExercises = new Model_Exercises();
     $modelWorkouts = new Model_Workouts();
     $this->view->users = count($modelUsers->fetchAll());
     $this->view->exercises = count($modelExercises->fetchAll());
     $this->view->workouts = count($modelWorkouts->fetchAll());
 }

 public function editAction()
 {
     parent::ajaxEnabled();
     $modelMeals = new Model_Meals();
     $modelUsers = new Model_Users();
     $form = self::getMealsEditForm();
     $form->setUsers($modelUsers->fetchAll()->toArray());
     $mealId = $this->_getParam('mealId');
     $mealId = (int) $mealId;
     if ($mealId) {
         $populateData = array();
         $meal = $modelMeals->fetch($mealId);
         if (count($meal) > 0) {
             $populateData = $meal->toArray();
         }
         $form->populate($populateData);
         $form->setHidden($mealId);
     }
     $request = $this->getRequest();
     if ($request->isPost()) {
         $post = $request->getPost();
         if ($form->isValid($post)) {
             $values = $form->getValues();
             $mode = null;
             if ($mealId) {
                 $modelMeals->update($mealId, $values);
                 $insertId = $mealId;
                 $mode = 'edit';
             } else {
                 $insertId = $modelMeals->insert($values);
                 $mode = 'add';
             }
             $mealInfo = $modelMeals->fetch($insertId);
             $dateFormat = new vkNgine_View_Helper_Dateformat();
             $newRow = array('mode' => $mode, 'itemId' => $insertId, 'titlee' => $mealInfo->title, 'rowId' => 'meal-', 'templateName' => 'mealsTemplate', 'Save' => $this->t->_('Save'), 'Cancel' => $this->t->_('Cancel'), 'Yes' => $this->t->_('Yes'), 'No' => $this->t->_('No'), 'Never' => $this->t->_('Never'), 'href' => $this->_helper->url('edit', 'meals'), 'href2' => $this->_helper->url('add-food', 'meals'), 'title' => $this->t->_('Meal is being edited'), 'tagTitleFood' => $this->t->_('Add Food to this Meal'), 'tagTitle' => $this->t->_('Edit this meal'), 'tagTitleDelete' => $this->t->_('Delete this meal'));
             echo Zend_Json::encode(array('success' => 1, 'newRow' => $newRow, 'dialog' => 'btn-editmeal-dialog', 'row' => true, 'title' => $this->t->_('Success Message'), 'message' => sprintf($this->t->_('%s was successfully added'), $values['title']), 'icon' => 'success'));
             exit;
         } else {
             $error = $form->getErrors();
             echo Zend_Json::encode(array('title' => $this->t->_('Error Message'), 'message' => $this->t->_('Please fill out all required fields'), 'icon' => 'error'));
             exit;
         }
     }
     $this->view->form = $form;
 }

 public function editAction()
 {
     parent::ajaxEnabled();
     $modelWorkouts = new Model_Workouts();
     $modelUsers = new Model_Users();
     $form = self::getWorkoutsEditForm();
     $form->setUsers($modelUsers->fetchAll()->toArray());
     $workoutId = $this->_getParam('workoutId');
     $workoutId = (int) $workoutId;
     if ($workoutId) {
         $populateData = array();
         $workout = $modelWorkouts->fetch($workoutId);
         if (count($workout) > 0) {
             $populateData = $workout->toArray();
         }
         $form->populate($populateData);
         $form->setHidden($workoutId);
     }
     $request = $this->getRequest();
     if ($request->isPost()) {
         $post = $request->getPost();
         if ($form->isValid($post)) {
             $values = $form->getValues();
             $mode = null;
             if ($workoutId) {
                 $modelWorkouts->update($workoutId, $values);
                 $insertId = $workoutId;
                 $mode = 'edit';
             } else {
                 $insertId = $modelWorkouts->insert($values);
                 $mode = 'add';
             }
             $workoutInfo = $modelWorkouts->fetch($insertId);
             $dateFormat = new vkNgine_View_Helper_Dateformat();
             $newRow = array('mode' => $mode, 'itemId' => $insertId, 'name' => $workoutInfo->name, 'startDate' => $workoutInfo->startDate, 'startDateFormatted' => $dateFormat->dateFormat($workoutInfo->startDate, Zend_Date::DATE_FULL), 'endDate' => $workoutInfo->endDate, 'endDateFormatted' => $dateFormat->dateFormat($workoutInfo->endDate, Zend_Date::DATE_FULL), 'rowId' => 'workout-', 'templateName' => 'workoutsTemplate', 'Save' => $this->t->_('Save'), 'Cancel' => $this->t->_('Cancel'), 'Yes' => $this->t->_('Yes'), 'No' => $this->t->_('No'), 'Never' => $this->t->_('Never'), 'href' => $this->_helper->url('edit', 'workouts'), 'title' => $this->t->_('Workout is being edited'), 'tagTitle' => $this->t->_('Edit this workout'), 'tagTitleDelete' => $this->t->_('Delete this workout'), 'tagTitleAddExercise' => $this->t->_('Add Exercise to this Workout'));
             echo Zend_Json::encode(array('success' => 1, 'newRow' => $newRow, 'dialog' => 'btn-editworkout-dialog', 'row' => true, 'title' => $this->t->_('Success Message'), 'message' => sprintf($this->t->_('%s was successfully added'), $values['name']), 'icon' => 'success'));
             exit;
         } else {
             $error = $form->getErrors();
             echo Zend_Json::encode(array('title' => $this->t->_('Error Message'), 'message' => $this->t->_('Please fill out all required fields'), 'icon' => 'error'));
             exit;
         }
     }
     $this->view->form = $form;
 }

<?php

/**
 * This file is intended to run on the shell
 */
require_once 'cronMaster.php';
$modelUsers = new Model_Users();
foreach ($modelUsers->fetchAll("notifications != 'disable'")->toArray() as $users) {
    $db = Zend_Db::factory($config->resources->db->adapter, $config->resources->db->params);
    $db->getConnection();
    if ($users['notifications'] == 'senddailyifnolog') {
        $sql = "SELECT * FROM daily_exercises WHERE date = '" . date('Y-m-d') . "' and userId = " . $users['userId'];
        if (count($db->fetchAll($sql, 2)) == 0) {
            $user = $modelUsers->fetch($users['userId']);
            $params = array('subject' => 'Did you add your exercise log for today?', 'firstName' => $users['firstName'], 'version' => vkNgine_Version::VERSION);
            $email = new vkNgine_Email();
            $email->sendWithTemplate('FORGOT_ADD_EXERCISE', $params, $user->getFullName(), array($users['email']));
        }
    } else {
        $sql = "SELECT * FROM daily_exercises WHERE date = '" . date('Y-m-d') . "' and userId = " . $users['userId'];
        $user = $modelUsers->fetch($users['userId']);
        $params = array('subject' => 'Did you add your exercise log for today?', 'firstName' => $users['firstName'], 'version' => vkNgine_Version::VERSION);
        $email = new vkNgine_Email();
        $email->sendWithTemplate('FORGOT_ADD_EXERCISE', $params, $user->getFullName(), array($users['email']));
    }
}