PHP HTML_Admin_ChronoForms::index 예제들

예제 #1

파일: admin.chronoforms.php 프로젝트: vnishukov/fdo

function index()
{
    $mainframe =& JFactory::getApplication();
    $database =& JFactory::getDBO();
    //prepare the pagination
    $option = 'com_chronoforms';
    $limit = $mainframe->getUserStateFromRequest($option . '.limit', 'limit', $mainframe->getCfg('list_limit'), 'int');
    $limitstart = $mainframe->getUserStateFromRequest($option . '.limitstart', 'limitstart', 0, 'int');
    // count entries
    $database->setQuery("SELECT count(*) FROM #__chronoforms");
    $total = $database->loadResult();
    jimport('joomla.html.pagination');
    $pageNav = new JPagination($total, $limitstart, $limit);
    //load forms data
    $val = __getValStatus();
    $database->setQuery("SELECT * FROM #__chronoforms ORDER BY id LIMIT {$pageNav->limitstart},{$pageNav->limit}");
    $forms = $database->loadObjectList();
    if (!empty($forms)) {
        foreach ($forms as $k => $form) {
            //load actions
            $query = "SELECT * FROM `#__chronoform_actions` WHERE `chronoform_id` = '" . $form->id . "' AND `enabled` = '1' ORDER BY `order`";
            $database->setQuery($query);
            $forms[$k]->form_actions = $database->loadObjectList();
        }
    }
    HTML_Admin_ChronoForms::index($forms, $pageNav, $val);
}

예제 #2

파일: controller.php 프로젝트: acculitx/fleetmatrixsite

 function index()
 {
     $mainframe =& JFactory::getApplication();
     $database =& JFactory::getDBO();
     //prepare the pagination
     $option = 'com_chronoforms';
     $limit = $mainframe->getUserStateFromRequest($option . '.limit', 'limit', $mainframe->getCfg('list_limit'), 'int');
     $limitstart = $mainframe->getUserStateFromRequest($option . '.limitstart', 'limitstart', 0, 'int');
     //get apps
     $app = $mainframe->getUserStateFromRequest($option . '.app', 'select_app', '', 'string');
     $apps = array('' => 'Default');
     $database->setQuery("SELECT DISTINCT app FROM #__chronoforms");
     $all = $database->loadObjectList();
     foreach ($all as $one) {
         if (!in_array($one->app, array_keys($apps))) {
             $apps[$one->app] = $one->app;
         }
     }
     // count entries
     $database->setQuery("SELECT count(*) FROM #__chronoforms WHERE `app` = '" . $app . "'");
     //$database->setQuery("SELECT count(*) FROM #__chronoforms");
     $total = $database->loadResult();
     jimport('joomla.html.pagination');
     $pageNav = new JPagination($total, $limitstart, $limit);
     //load forms data
     $val = ChronoFormsAdminVersion::__getValStatus();
     $database->setQuery("SELECT * FROM #__chronoforms WHERE `app` = '" . $app . "' ORDER BY id LIMIT {$pageNav->limitstart},{$pageNav->limit}");
     //$database->setQuery("SELECT * FROM #__chronoforms ORDER BY id LIMIT $pageNav->limitstart,$pageNav->limit");
     $forms = $database->loadObjectList();
     if (!empty($forms)) {
         foreach ($forms as $k => $form) {
             //load actions
             $query = "SELECT * FROM `#__chronoform_actions` WHERE `chronoform_id` = '" . $form->id . "' AND `enabled` = '1' ORDER BY `order`";
             $database->setQuery($query);
             $forms[$k]->form_actions = $database->loadObjectList();
         }
     }
     HTML_Admin_ChronoForms::index($forms, $pageNav, $apps, $val);
 }