Manager Tools Logging Zend DB Table

<?php
/**
 * @author Nathan Daly <[email protected]>
 */
class Application_Model_DbTable_Logging extends Zend_Db_Table_Abstract
{
    protected $_name = 'pay_administrator_actions';
    protected $_primary = 'action_id';
    protected $_sequence = true;

    /**
     *
     * @param int $adminId
     * @param int $page
     * @param int $rowCount
     * @return Zend_Db_Table_Rowset
     */
    public function findActionsById($adminId, $pageNo, $rowCount)
    {
        $select = $this->select();
        $select->setIntegrityCheck(false);
        $select->where('pay_administrator_actions.admin_uid = ?', $adminId);
        $select->join('pay_administrator', 'pay_administrator.admin_uid = pay_administrator_actions.admin_uid');
        $select->limitPage($pageNo, $rowCount);
        return $this->fetchAll($select);
    }

    /**
     *
     * @param int $loanId
     * @param int $page
     * @param int $rowCount
     * @return Zend_Db_Table_Rowset
     */
    public function findActionsByLoanId($loanId, $pageNo = 1, $rowCount = 1000)
    {
        $select = $this->select();
        $select->setIntegrityCheck(false);
        $select->from('pay_administrator_actions', 'pay_administrator.*');
        $select->join('pay_administrator', 'pay_administrator.admin_uid = pay_administrator_actions.admin_uid', 'pay_administrator_actions.*');
        $select->where('pay_administrator_actions.loc_id = ?', $loanId);
        $select->order(array('create_timestamp DESC'));
        $select->limitPage($pageNo, $rowCount);
        return $this->fetchAll($select);
    }

    /**
     *
     * @param string $name
     * @param int $page
     * @param int $rowCount
     * @return Zend_Db_Table_Rowset
     */
    public function findActionsByName($name, $pageNo, $rowCount)
    {
        $name = '%' . $name . '%';
        $select = $this->select();
        $select->setIntegrityCheck(false);
        $select->from('pay_administrator_actions', 'pay_administrator.*');
        $select->join('pay_administrator', 'pay_administrator.admin_uid = pay_administrator_actions.admin_uid', 'pay_administrator_actions.*');
        $select->where('CONCAT(pay_administrator.admin_vfname, pay_administrator.admin_vlname) LIKE  ?', $name);
        $select->limitPage($pageNo, $rowCount);
        return $this->fetchAll($select);
    }

    /**
     *
     * @param date $date1
     * @param date $date2
     * @return Zend_Db_Table_Rowset
     */
    public function actionsBetweenDates($date1, $date2)
    {
        $select = $this->select();
        $select->setIntegrityCheck(false);
        $select->where('pay_administrator_actions.create_timestamp between ? AND ?', $date1, $date2);
        $select->order('pay_administrator_actions.create_timestamp DESC');
        $select->join('pay_administrator', 'pay_administrator.admin_uid = pay_administrator_actions.admin_uid');
        return $this->fetchAll($select);
    }

    /**
     *
     * @param int $page
     * @param int $rowCount
     * @return Zend_Db_Table_Rowset
     */
    public function allActions($pageNo, $rowCount)
    {
        $select = $this->select(array('pay_administrator.admin_vfname', 'pay_administrator.admin_vlname'));
        $select->setIntegrityCheck(false);
        //$select->where('pay_administrator_actions.admin_uid = ?', $adminId);
        $select->join('pay_administrator', 'pay_administrator.admin_uid = pay_administrator_actions.admin_uid');
        $select->order('pay_administrator_actions.create_timestamp DESC');
        $select->limitPage($pageNo, $rowCount);
        //echo $select;
        return $this->fetchAll($select);
    }

    public function rowCount($_GET)
    {
        $order = (!isset($_GET['order']) || empty($_GET['order'])) ? 'DESC' : strtoupper($_GET['order']);
        $orderby = (!isset($_GET['orderby']) || empty($_GET['orderby'])) ? 'create_timestamp' : strtoupper($_GET['orderby']);
        $d1 = (!isset($_GET['from']) && !empty($_GET['from'])) ? trim($_GET['from']) :  date('d/m/Y', strtotime("now -30 days"));
        $d2 = (!isset($_GET['to']) && !empty($_GET['to'])) ? trim($_GET['to']) : date('d/m/Y');

        //Reverse date string
        $arr1 = explode("/", $d1);
        $arr2 = explode("/", $d2);
        $arrV1 = array_reverse($arr1);
        $arrV2 = array_reverse($arr2);
        $dateFrom = implode($arrV1, "/");
        $dateTo = implode($arrV2, "/");
        //Build Query
        $select = $this->select();
        $select->setIntegrityCheck(false);
        $select->from('pay_administrator_actions', 'pay_administrator.*');
        $select->join('pay_administrator', 'pay_administrator.admin_uid = pay_administrator_actions.admin_uid', 'pay_administrator_actions.*');
        if (!empty($_GET['loanId'])) {
            $select->where('pay_administrator_actions.loc_id = ?', trim($_GET['loanId']));
        }
        if (!empty($_GET['userId'])) {
            $select->where('pay_administrator_actions.admin_uid = ?', trim($_GET['userId']));
        }
        if (!empty($_GET['csr'])) {
            $name = '%' . trim($_GET['csr']) . '%';
            $select->where('CONCAT(pay_administrator.admin_vfname, pay_administrator.admin_vlname) LIKE  ?', $name);
        }
        $select->where('pay_administrator_actions.create_timestamp between \'' . str_replace('/', '-', $dateFrom) . '\' AND DATE_ADD(\'' . str_replace('/', '-', $dateTo) . '\', INTERVAL 1 DAY)');
        $select->order('pay_administrator_actions.' . $orderby . ' ' . $order);
        return sizeof($this->fetchAll($select));
    }

    /**
     *
     * @param int $adminId
     * @param int $locId
     * @param string $action
     * @return Zend_Db_Table
     */
    public function logThisAction($adminId, $locId, $action)
    {
        $data = array(
            'admin_uid' => $adminId,
            'loc_id' => $locId,
            'create_timestamp' => new Zend_Db_Expr('now()'),
            'action' => $action
        );
        return $this->insert($data);
    }

    /**
     *
     * @param array $_GET
     * @param int $page
     * @param int $rowCount
     * @return Zend_Db_Table
     */
    public function buildQuery($_GET, $pageNo, $rowCount)
    {
        $order = (!isset($_GET['order']) || empty($_GET['order'])) ? 'DESC' : strtoupper($_GET['order']);
        $orderby = (!isset($_GET['orderby']) || empty($_GET['orderby'])) ? 'create_timestamp' : strtoupper($_GET['orderby']);
        $d1 = (!isset($_GET['from']) && !empty($_GET['from'])) ? trim($_GET['from']) :  date('d/m/Y', strtotime("now -30 days"));
        $d2 = (!isset($_GET['to']) && !empty($_GET['to'])) ? trim($_GET['to']) : date('d/m/Y');

        //Reverse date string
        $arr1 = explode("/", $d1);
        $arr2 = explode("/", $d2);
        $arrV1 = array_reverse($arr1);
        $arrV2 = array_reverse($arr2);
        $dateFrom = implode($arrV1, "/");
        $dateTo = implode($arrV2, "/");
        //Build Query
        $select = $this->select();
        $select->setIntegrityCheck(false);
        $select->from('pay_administrator_actions', 'pay_administrator.*');
        $select->join('pay_administrator', 'pay_administrator.admin_uid = pay_administrator_actions.admin_uid', 'pay_administrator_actions.*');
        if (!empty($_GET['loanId'])) {
            $select->where('pay_administrator_actions.loc_id = ?', trim($_GET['loanId']));
        }
        if (!empty($_GET['userId'])) {
            $select->where('pay_administrator_actions.admin_uid = ?', trim($_GET['userId']));
        }
        if (!empty($_GET['csr'])) {
            $name = '%' . trim($_GET['csr']) . '%';
            $select->where('CONCAT(pay_administrator.admin_vfname, pay_administrator.admin_vlname) LIKE  ?', $name);
        }
        $select->where('pay_administrator_actions.create_timestamp between \'' . str_replace('/', '-', $dateFrom) . '\' AND DATE_ADD(\'' . str_replace('/', '-', $dateTo) . '\', INTERVAL 1 DAY)');
        $select->order('pay_administrator_actions.' . $orderby . ' ' . $order);
        $select->limitPage($pageNo, $rowCount);
        return $this->fetchAll($select);
    }
}