QuestMigrateController.php

<?php

class QuestMigrateController extends Emw_Controller_Action
{
    
    public function indexAction()
    {
        $db = $migrateJobsTable = Application_Model_DbTable_MigrateJobs::getInstance()->getDefaultAdapter();
        $select = $db->select()
            ->from(array('o' => 'office365jobs'))
            ->join(array('m' => 'migratejobs'), 'o.nuid = m.nuid')
            ->joinLeft(array('n' => 'notes_migration'), 'o.nuid = n.nuid')
            ->where('m.migrate_status IN(?)', array(
                Application_Model_DbTable_MigrateJobs::STATUS_DECRYPTED,
                Application_Model_DbTable_MigrateJobs::STATUS_QST_WIP,
            ))
            ->order('m.bt_migrate_time');
        
        $this->view->records = $db->query($select)->fetchAll();
        $this->view->statusOptions = array(
            Application_Model_DbTable_MigrateJobs::STATUS_DECRYPTED => 'Unassigned',
            Application_Model_DbTable_MigrateJobs::STATUS_QST_WIP   => 'Active',
            Application_Model_DbTable_MigrateJobs::STATUS_MIGRATED  => 'Step Finished',
        );
    }

}