$q .= "order_status = '{$show}' AND "; } $q .= "(#__{vm}_orders.order_id=#__{vm}_order_user_info.order_id) "; $q .= "AND #__{vm}_orders.vendor_id='" . $_SESSION['ps_vendor_id'] . "' AND ship_method_id LIKE '%Zasilkovna%' "; $q .= "ORDER BY #__{vm}_orders.cdate DESC "; $list .= $q . " LIMIT {$limitstart}, " . $limit; $count .= $q; $db->query($count); $db->next_record(); $num_rows = $db->f("num_rows"); // Create the Page Navigation $pageNav = new vmPageNav($num_rows, $limitstart, $limit); // Create the List Object with page navigation $listObj = new listFactory($pageNav); // print out the search field and a list heading $listObj->writeSearchHeader($zas_modul->lang('zas_order_title'), VM_THEMEURL . 'images/administration/dashboard/orders.png', $modulename, "zasilkovna"); ?> <div align="center"> <?php $navi_db = new ps_DB(); $q = "SELECT order_status_code, order_status_name "; $q .= "FROM #__{vm}_order_status WHERE vendor_id = '{$ps_vendor_id}'"; $navi_db->query($q); while ($navi_db->next_record()) { ?> <a href="<?php $sess->purl($_SERVER['PHP_SELF'] . "?page={$modulename}.zasilkovna&show=" . $navi_db->f("order_status_code")); ?> "> <b><?php