PHP listFactory Examples

Example #1

File: product.specialprod.php Project: noikiy/owaspbwa

} else {
    $list = "SELECT * FROM #__{vm}_product ";
    $count = "SELECT count(*) as num_rows FROM #__{vm}_product ";
    $q = "WHERE 1=1 ";
    $q .= $qfilter;
    $q .= "ORDER BY product_name ";
    $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($VM_LANG->_('PHPSHOP_FEATURED_PRODUCTS_LIST_LBL'), IMAGEURL . "ps_image/product_code.png", $modulename, "specialprod");
echo '<strong>' . $VM_LANG->_('PHPSHOP_FILTER') . ':</strong>&nbsp;&nbsp;';
if ($filter != "all") {
    echo '<a href="' . $sess->url($_SERVER['PHP_SELF'] . "?page={$page}&filter=all") . '" title="' . $VM_LANG->_('PHPSHOP_LIST_ALL_PRODUCTS') . '">';
}
echo $VM_LANG->_('PHPSHOP_LIST_ALL_PRODUCTS');
if ($filter != 'all') {
    echo '</a>';
}
echo '&nbsp;&nbsp;|&nbsp;&nbsp;';
if ($filter != 'featured_and_discounted') {
    echo '<a href="' . $sess->url($_SERVER['PHP_SELF'] . "?page={$page}&filter=featured_and_discounted") . '" title="' . $VM_LANG->_('PHPSHOP_SHOW_FEATURED_AND_DISCOUNTED') . '">';
}
echo $VM_LANG->_('PHPSHOP_SHOW_FEATURED_AND_DISCOUNTED');

Example #2

File: product.product_type_list.php Project: BackupTheBerlios/kmit-svn

require_once CLASSPATH . "htmlTools.class.php";
global $ps_product_type;
$q = "SELECT * FROM #__{vm}_product_type ";
/*    $q .= "WHERE #__{vm}_category_xref.category_parent_id='";
$q .= $category_id . "' AND ";
$q .= "#__{vm}_category.category_id=#__{vm}_category_xref.category_child_id ";
$q .= "AND #__{vm}_category.vendor_id = $ps_vendor_id ";*/
$q .= "ORDER BY product_type_list_order asc ";
$db->query($q);
$num_rows = $db->num_rows();
// Create the Page Navigation
$pageNav = new vmPageNav($num_rows, $limitstart, $limit);
$q .= "LIMIT {$pageNav->limitstart}, {$pageNav->limit}";
$db->query($q);
// Create the List Object with page navigation
$listObj = new listFactory($pageNav);
// print out the search field and a list heading
$listObj->writeSearchHeader($VM_LANG->_('PHPSHOP_PRODUCT_TYPE_LIST_LBL'), IMAGEURL . "ps_image/categories.gif", $modulename, "product_type_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $num_rows . ")\" />" => "width=\"20\"", $VM_LANG->_('PHPSHOP_PRODUCT_TYPE_FORM_NAME') => 'width="25%"', $VM_LANG->_('PHPSHOP_PRODUCT_TYPE_FORM_DESCRIPTION') => 'width="30%"', $VM_LANG->_('PHPSHOP_PRODUCT_TYPE_FORM_PARAMETERS') => 'width="15%"', $VM_LANG->_('PHPSHOP_PRODUCTS_LBL') => 'width="15%"', $VM_LANG->_('PHPSHOP_PRODUCT_LIST_PUBLISH') => 'width="5%"', $VM_LANG->_('PHPSHOP_MODULE_LIST_ORDER') => 'width="5%"', $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
$i = 0;
while ($db->next_record()) {
    $product_count = $ps_product_type->product_count($db->f("product_type_id"));
    $parameter_count = $ps_product_type->parameter_count($db->f("product_type_id"));
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    // The Checkbox

Example #3

File: order.order_status_list.php Project: noikiy/owaspbwa

} else {
    $q = "";
    $list = "SELECT * FROM #__{vm}_order_status WHERE ";
    $count = "SELECT count(*) as num_rows FROM #__{vm}_order_status WHERE ";
    $q .= "vendor_id='{$ps_vendor_id}' ";
    $q .= "ORDER BY list_order ASC";
    $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($VM_LANG->_('PHPSHOP_ORDER_STATUS_LIST_MNU'), "", $modulename, "order_status_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $num_rows . ")\" />" => "width=\"20\"", $VM_LANG->_('PHPSHOP_ORDER_STATUS_LIST_NAME') => '', $VM_LANG->_('PHPSHOP_ORDER_STATUS_LIST_CODE') => '', $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
$db->query($list);
$i = 0;
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    // The Checkbox
    $listObj->addCell(vmCommonHTML::idBox($i, $db->f("order_status_id"), false, "order_status_id"));

Example #4

File: store.creditcard_list.php Project: BackupTheBerlios/kmit-svn

    $q .= "ORDER BY creditcard_name ";
    $list .= $q . " LIMIT {$limitstart}, " . $limit;
    $count .= $q;
} else {
    $list = "SELECT * FROM #__{vm}_creditcard ";
    $list .= "ORDER BY creditcard_name ";
    $list .= "LIMIT {$limitstart}, " . $limit;
    $count = "SELECT count(*) as num_rows FROM #__{vm}_creditcard ";
}
$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($VM_LANG->_('PHPSHOP_CREDITCARD_LIST_LBL'), VM_THEMEURL . 'images/administration/dashboard/credit.png', $modulename, "creditcard_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $num_rows . ")\" />" => "width=\"20\"", $VM_LANG->_('PHPSHOP_CREDITCARD_NAME') => '', $VM_LANG->_('PHPSHOP_CREDITCARD_CODE') => '', $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
$db->query($list);
$i = 0;
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    // The Checkbox
    $listObj->addCell(vmCommonHTML::idBox($i, $db->f("creditcard_id"), false, "creditcard_id"));

Example #5

File: product.file_list.php Project: albertobraschi/Hab

while ($db->next_record()) {
    // Reorder the whole recordset and put pay-download files at the top
    $filename = $mosConfig_absolute_path . str_replace($mosConfig_absolute_path, '', $db->f("file_name"));
    $isProductDownload = in_array(basename($filename), $downloadFiles) ? true : false;
    if ($isProductDownload) {
        $arr[] = $db->getCurrentRow();
    } else {
        $arr2[] = $db->getCurrentRow();
    }
}
$db->record = array_merge($arr, $arr2);
$num_rows = $db->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($VM_LANG->_('PHPSHOP_FILES_LIST') . " " . $product_name, $mosConfig_live_site . "/administrator/images/mediamanager.png", $modulename, "file_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => 'width="20"', "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll({$num_rows})\" />" => 'width="20"', $VM_LANG->_('PHPSHOP_FILES_LIST_FILENAME') => '', $VM_LANG->_('VM_FILES_LIST_ROLE') => '', $VM_LANG->_('PHPSHOP_VIEW') => '', $VM_LANG->_('PHPSHOP_FILES_LIST_FILETITLE') => '', $VM_LANG->_('PHPSHOP_FILES_LIST_FILETYPE') => '', $VM_LANG->_('PHPSHOP_FILEMANAGER_PUBLISHED') => '', $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
$roles = array('isDownlodable' => IMAGEURL . 'ps_image/downloadable.gif', 'isImage' => IMAGEURL . 'ps_image/image.gif', 'isProductImage' => IMAGEURL . 'ps_image/image.png', 'isFile' => IMAGEURL . 'ps_image/attachment.gif', 'isRemoteFile' => IMAGEURL . 'ps_image/url.gif');
// Reset Result pointer
$db->reset();
$i = 0;
while ($db->next_record()) {
    $filename = $mosConfig_absolute_path . str_replace($mosConfig_absolute_path, '', $db->f("file_name"));
    $listObj->newRow();
    // The row number

Example #6

File: product.product_inventory.php Project: BackupTheBerlios/kmit-svn

    $count = "SELECT count(*) as num_rows FROM #__{vm}_product WHERE ";
    $q = "#__{vm}_product.vendor_id = '{$ps_vendor_id}' ";
    if ($allproducts != 1) {
        $q .= "AND product_in_stock > 0 ";
    }
    $q .= "ORDER BY product_name ";
    $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($VM_LANG->_('PHPSHOP_PRODUCT_INVENTORY_LBL'), IMAGEURL . "ps_image/inventory.gif", $modulename, "product_inventory");
echo '  ';
if ($allproducts != 1) {
    echo '<a href="' . $sess->url($_SERVER['PHP_SELF'] . "?pshop_mode=admin&page={$page}&allproducts=1") . '" title="' . $VM_LANG->_('PHPSHOP_LIST_ALL_PRODUCTS') . '">';
}
echo $VM_LANG->_('PHPSHOP_LIST_ALL_PRODUCTS');
if ($allproducts != 1) {
    echo '</a>';
}
echo '&nbsp;&nbsp;|&nbsp;&nbsp;';
if ($allproducts == 1) {
    echo '<a href="' . $sess->url($_SERVER['PHP_SELF'] . "?pshop_mode=admin&page={$page}&allproducts=0") . '" title="' . $VM_LANG->_('PHPSHOP_HIDE_OUT_OF_STOCK') . '">';
}
echo $VM_LANG->_('PHPSHOP_HIDE_OUT_OF_STOCK');

Example #7

File: product.review_list.php Project: noikiy/owaspbwa

$where[] = "p.product_id = r.product_id";
if (!empty($keyword)) {
    $where[] = "( comment LIKE '%{$keyword}%' OR username LIKE '%{$keyword}%' )";
}
if (!empty($where)) {
    $q .= ' WHERE ' . implode(' AND ', $where);
}
$q .= ' ORDER BY time DESC';
$list .= $q . " LIMIT {$limitstart}, {$limit}";
$count .= $q;
$db->query($count);
$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);
$title = $VM_LANG->_('PHPSHOP_REVIEWS');
// print out the search field and a list heading
$listObj->writeSearchHeader($title, VM_THEMEURL . 'images/administration/dashboard/reviews.png', $modulename, "review_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $num_rows . ")\" />" => "width=\"20\"", $VM_LANG->_('PHPSHOP_PRODUCT_NAME_TITLE') => 'width="20%"', $VM_LANG->_('VM_REVIEW_LIST_NAMEDATE') => 'width="15%"', $VM_LANG->_('PHPSHOP_REVIEWS') => 'width="35%"', $VM_LANG->_('PHPSHOP_RATE_NOM') => 'width="15%"', $VM_LANG->_('PHPSHOP_PRODUCT_LIST_PUBLISH') => 'width="5%"', $VM_LANG->_('E_REMOVE') => 'width="10%"');
$listObj->writeTableHeader($columns);
$db->query($list);
$i = 0;
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    // The Checkbox

Example #8

File: manufacturer.manufacturer_list.php Project: noikiy/owaspbwa

    $count .= $q;
} else {
    $q = "";
    $list = "SELECT * FROM #__{vm}_manufacturer ";
    $count = "SELECT count(*) as num_rows FROM #__{vm}_manufacturer ";
    $q .= "ORDER BY mf_name ASC ";
    $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($VM_LANG->_('PHPSHOP_MANUFACTURER_LIST_LBL'), VM_THEMEURL . 'images/administration/dashboard/manufacturer.png', $modulename, "manufacturer_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $num_rows . ")\" />" => "width=\"20\"", 'ID' => 'width="5%"', $VM_LANG->_('PHPSHOP_MANUFACTURER_LIST_MANUFACTURER_NAME') => 'width="45%"', $VM_LANG->_('PHPSHOP_MANUFACTURER_LIST_ADMIN') => 'width="45%"', $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
$db->query($list);
$i = 0;
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    // The Checkbox
    $listObj->addCell(vmCommonHTML::idBox($i, $db->f("manufacturer_id"), false, "manufacturer_id"));

Example #9

File: product.product_price_list.php Project: BackupTheBerlios/kmit-svn

$list = "SELECT shopper_group_name,product_price_id,product_price,product_currency,price_quantity_start,price_quantity_end ";
$q = "FROM #__{vm}_shopper_group,#__{vm}_product_price ";
$q .= "WHERE product_id = '{$product_id}' ";
if (!$perm->check("admin")) {
    $q .= "AND #__{vm}_shopper_group.vendor_id = '{$ps_vendor_id}' ";
}
$q .= "AND #__{vm}_shopper_group.shopper_group_id = #__{vm}_product_price.shopper_group_id ";
$q .= "ORDER BY shopper_group_name,price_quantity_start, product_price ";
$count .= $q;
$db->query($count);
$num_rows = $db->num_rows();
// Create the Page Navigation
$pageNav = new vmPageNav($num_rows, $limitstart, $limit);
$list .= $q . 'LIMIT ' . $pageNav->limitstart . ', ' . $pageNav->limit;
// Create the List Object with page navigation
$listObj = new listFactory($pageNav);
// print out the search field and a list heading
$listObj->writeSearchHeader($title, IMAGEURL . "ps_image/product_code.png", $modulename, "product_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $num_rows . ")\" />" => "width=\"20\"", $VM_LANG->_('PHPSHOP_PRICE_LIST_GROUP_NAME') => '', $VM_LANG->_('PHPSHOP_PRICE_LIST_PRICE') => '', $VM_LANG->_('PHPSHOP_PRODUCT_LIST_CURRENCY') => '', $VM_LANG->_('PHPSHOP_PRODUCT_LIST_QUANTITY_START') => 'width="50"', $VM_LANG->_('PHPSHOP_PRODUCT_LIST_QUANTITY_END') => 'width="50"', $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
$db->query($list);
$i = 0;
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    // The Checkbox
    $listObj->addCell(vmCommonHTML::idBox($i, $db->f("product_price_id"), false, "product_price_id"));

Example #10

File: admin.function_list.php Project: noikiy/owaspbwa

    $count .= $q;
} else {
    $list = "SELECT * FROM #__{vm}_function WHERE module_id='{$module_id}' ";
    $list .= "ORDER BY function_name ";
    $list .= "LIMIT {$limitstart}, " . $limit;
    $count = "SELECT count(*) as num_rows FROM #__{vm}_function ";
    $count .= "WHERE module_id='{$module_id}' ";
}
$db->query($count);
$db->next_record();
$num_rows = $db->f("num_rows");
$db->query($list);
// 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($title, VM_THEMEURL . "images/administration/dashboard/functions.png", "admin", "function_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . count($db->record) . ")\" />" => "width=\"20\"", $VM_LANG->_('PHPSHOP_FUNCTION_LIST_NAME') => "", $VM_LANG->_('PHPSHOP_FUNCTION_LIST_CLASS') => "", $VM_LANG->_('PHPSHOP_FUNCTION_LIST_METHOD') => "");
$usergroups = $vmUserGroup->get_groups();
while ($usergroups->next_record()) {
    $columns[$usergroups->f('group_name')] = 'width="5%"';
    $groupArray[] = $usergroups->f('group_name');
}
$columns['none'] = 'width="5%"';
$usergroups->reset();
$columns['<a href="javascript: document.adminForm.func.value = \'setFunctionPermissions\'; saveorder( ' . (count($db->record) - 1) . ' );"><img src="' . $mosConfig_live_site . '/administrator/images/filesave.png" border="0" width="16" height="16" alt="' . $VM_LANG->_('SAVE_PERMISSIONS') . '" align="left"/>' . $VM_LANG->_('SAVE_PERMISSIONS') . '</a>'] = '';
$columns[$VM_LANG->_('E_REMOVE')] = "width=\"5%\"";

Example #11

File: zone.assign_zones.php Project: BackupTheBerlios/kmit-svn

    $list .= $q . " LIMIT {$limitstart}, " . $limit;
    $count .= $q;
} else {
    $q = "";
    $list = "SELECT * FROM #__{vm}_country ORDER BY country_id ASC ";
    $count = "SELECT count(*) as num_rows FROM #__{vm}_country";
    $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($VM_LANG->_('PHPSHOP_ASSIGN_ZONE_PG_LBL'), '', $modulename, "assign_zones");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", $VM_LANG->_('PHPSHOP_ZONE_ASSIGN_COUNTRY_LBL') => '', $VM_LANG->_('PHPSHOP_ZONE_ASSIGN_CURRENT_LBL') => '', $VM_LANG->_('PHPSHOP_ZONE_ASSIGN_ASSIGN_LBL') => '');
$listObj->writeTableHeader($columns);
$db->query($list);
$i = 0;
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    $tmp_cell = '<input type="hidden" name="country_id[]" value="' . $db->f("country_id") . '" />';
    $tmp_cell .= $db->f("country_name");

Example #12

File: product.product_list.php Project: noikiy/owaspbwa

    $count .= $q;
    $q .= " ORDER BY product_publish DESC,product_name ";
}
$db->query($count);
$db->next_record();
$num_rows = $db->f("num_rows");
// Create the Page Navigation
$pageNav = new vmPageNav($num_rows, $limitstart, $limit);
$limitstart = $pageNav->limitstart;
$list .= $q . " LIMIT {$limitstart}, " . $limit;
if ($num_rows > 0) {
    $db->query($list);
    $num_rows = $db->num_rows();
}
// Create the List Object with page navigation
$listObj = new listFactory($pageNav);
// print out the search field and a list heading
$listObj->writeSearchHeader($VM_LANG->_('PHPSHOP_PRODUCT_LIST_LBL'), VM_THEMEURL . 'images/administration/dashboard/product_code.png', "product", "product_list");
echo $VM_LANG->_('PHPSHOP_FILTER');
?>
:
 <select class="inputbox" id="category_id" name="category_id" onchange="window.location='<?php 
echo $_SERVER['PHP_SELF'];
?>
?option=com_virtuemart&page=product.product_list&category_id='+document.getElementById('category_id').options[selectedIndex].value;">
	<option value=""><?php 
echo $VM_LANG->_('SEL_CATEGORY');
?>
</option>
	<?php 
$ps_product_category->list_tree($category_id);

Example #13

File: admin.module_list.php Project: noikiy/owaspbwa

    $count .= $q;
} else {
    $q = "";
    $list = "SELECT * FROM #__{vm}_module ORDER BY list_order ASC ";
    $count = "SELECT count(*) as num_rows FROM #__{vm}_module ORDER BY list_order ";
    $list .= $q . " LIMIT {$limitstart}, " . $limit;
    $count .= $q;
}
$db->query($count);
$db->next_record();
$num_rows = $db->f("num_rows");
$db->query($list);
// 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($VM_LANG->_('PHPSHOP_MODULE_LIST_LBL'), VM_THEMEURL . 'images/administration/dashboard/modules.png', "admin", "module_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => 'width="3%"', '<input type="checkbox" name="toggle" value="" onclick="checkAll(' . count($db->record) . ')" />' => 'width="3%"', $VM_LANG->_('PHPSHOP_MODULE_LIST_NAME') => 'width="20%"');
$usergroups = $vmUserGroup->get_groups();
while ($usergroups->next_record()) {
    $columns[$usergroups->f('group_name')] = 'width="5%"';
    $groupArray[] = $usergroups->f('group_name');
}
$columns['none'] = 'width="5%"';
$usergroups->reset();
$columns['<a href="javascript: document.adminForm.func.value = \'setModulePermissions\'; saveorder( ' . (count($db->record) - 1) . ' );"><img src="' . $mosConfig_live_site . '/administrator/images/filesave.png" border="0" width="16" height="16" alt="' . $VM_LANG->_('SAVE_PERMISSIONS') . '" align="left"/>' . $VM_LANG->_('SAVE_PERMISSIONS') . '</a>'] = '';
$columns[$VM_LANG->_('PHPSHOP_MODULE_LIST_FUNCTIONS')] = 'width="10%"';

Example #14

File: shopper.shopper_group_list.php Project: BackupTheBerlios/kmit-svn

    $list = "SELECT * FROM #__{vm}_shopper_group ";
    $count = "SELECT count(*) as num_rows FROM #__{vm}_shopper_group ";
    if (!$perm->check("admin")) {
        $q = "WHERE vendor_id='{$ps_vendor_id}' ";
    }
    $q .= " ORDER BY vendor_id, shopper_group_name ";
    $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($VM_LANG->_('PHPSHOP_SHOPPER_GROUP_LIST_LBL'), VM_THEMEURL . "images/administration/dashboard/shop_users.png", $modulename, "shopper_group_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $num_rows . ")\" />" => "width=\"20\"", $VM_LANG->_('PHPSHOP_SHOPPER_GROUP_LIST_NAME') => 'width="30%"', $VM_LANG->_('PHPSHOP_PRODUCT_FORM_VENDOR') => '', $VM_LANG->_('PHPSHOP_SHOPPER_GROUP_LIST_DESCRIPTION') => '', $VM_LANG->_('PHPSHOP_DEFAULT') => '', $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
$db->query($list);
$i = 0;
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    // The Checkbox
    $listObj->addCell(vmCommonHTML::idBox($i, $db->f("shopper_group_id"), false, "shopper_group_id"));

Example #15

File: tax.tax_list.php Project: albertobraschi/Hab

    $list .= $q . " LIMIT {$limitstart}, " . $limit;
    $count .= $q;
} else {
    $q = "";
    $list = "SELECT * FROM #__{vm}_tax_rate ORDER BY tax_country, tax_state ASC ";
    $count = "SELECT count(*) as num_rows FROM #__{vm}_tax_rate";
    $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($VM_LANG->_('PHPSHOP_TAX_LIST_LBL'), VM_THEMEURL . "images/administration/dashboard/tax.png", $modulename, "tax_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $num_rows . ")\" />" => "width=\"20\"", $VM_LANG->_('PHPSHOP_TAX_LIST_COUNTRY') => 'width="44%"', $VM_LANG->_('PHPSHOP_TAX_LIST_STATE') => 'width="38%"', $VM_LANG->_('PHPSHOP_TAX_LIST_RATE') => 'width="18%"', $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
$db->query($list);
$i = 0;
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    // The Checkbox
    $listObj->addCell(vmCommonHTML::idBox($i, $db->f("tax_rate_id"), false, "tax_rate_id"));

Example #16

File: affiliate.affiliate_orders_list.php Project: rafarubert/megafiltros

require_once CLASSPATH . "htmlTools.class.php";
$start_date = mktime(0, 0, 0, date("n"), 1, date("Y"));
$end_date = mktime(24, 0, 0, date("n") + 1, 0, date("Y"));
$ps_affiliate = new ps_affiliate();
$affiliate = $ps_affiliate->get_affiliate_details($auth["user_id"]);
$q = "select * from #__{vm}_orders,#__{vm}_affiliate_sale";
$q .= " where #__{vm}_orders.order_id = #__{vm}_affiliate_sale.order_id";
$q .= " and #__{vm}_affiliate_sale.affiliate_id = '" . $affiliate["id"] . "'";
$q .= " AND cdate BETWEEN {$start_date} AND {$end_date} ";
$q .= " LIMIT {$limitstart}, {$limit}";
$db->query($q);
$num_rows = $db->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($VM_LANG->_('VM_AFFILIATE_ORDERSUMMARY_LBL') . ' ' . strftime('%b %Y', $date), "", "affiliate", "affiliate_orders_list");
echo $affiliate["company"];
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $num_rows . ")\" />" => "width=\"20\"", $VM_LANG->_('VM_AFFILIATE_ORDERLIST_ORDERREF') => "", $VM_LANG->_('VM_AFFILIATE_ORDERLIST_DATEORDERED') => "", $VM_LANG->_('VM_AFFILIATE_ORDERLIST_ORDERTOTAL') => "", $VM_LANG->_('VM_AFFILIATE_ORDERLIST_COMMISSION') => "", $VM_LANG->_('VM_AFFILIATE_ORDERLIST_ORDERSTATUS') => "", $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    // The Checkbox
    $listObj->addCell(vmCommonHTML::idBox($i, $db->f("order_id"), false, "order_id"));
    $listObj->addCell(sprintf("%08d", $db->f("order_id")));

Example #17

File: zone.zone_list.php Project: BackupTheBerlios/kmit-svn

    $list .= $q . " LIMIT {$limitstart}, " . $limit;
    $count .= $q;
} else {
    $q = "";
    $list = "SELECT * FROM #__{vm}_zone_shipping ORDER BY zone_name ASC ";
    $count = "SELECT count(*) as num_rows FROM #__{vm}_zone_shipping";
    $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($VM_LANG->_('PHPSHOP_ZONE_LIST_LBL'), "", $modulename, "zone_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $num_rows . ")\" />" => "width=\"20\"", $VM_LANG->_('PHPSHOP_ZONE_LIST_NAME_LBL') => '', $VM_LANG->_('PHPSHOP_ZONE_LIST_DESC_LBL') => '', $VM_LANG->_('PHPSHOP_ZONE_LIST_COST_PER_LBL') => '', $VM_LANG->_('PHPSHOP_ZONE_LIST_COST_LIMIT_LBL') => '', $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
$db->query($list);
$i = 0;
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    // The Checkbox
    $listObj->addCell(vmCommonHTML::idBox($i, $db->f("product_id"), false, "product_id"));

Example #18

File: vendor.vendor_category_list.php Project: noikiy/owaspbwa

    $list .= $q . " LIMIT {$limitstart}, " . $limit;
    $count .= $q;
} else {
    $q = "";
    $list = "SELECT * FROM #__{vm}_vendor_category ORDER BY vendor_category_name ASC ";
    $count = "SELECT count(*) as num_rows FROM #__{vm}_vendor_category";
    $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($VM_LANG->_('PHPSHOP_VENDOR_CAT_LIST_LBL'), "", $modulename, "vendor_category_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $num_rows . ")\" />" => "width=\"20\"", $VM_LANG->_('PHPSHOP_VENDOR_CAT_NAME') => 'width="21%"', $VM_LANG->_('PHPSHOP_VENDOR_CAT_DESCRIPTION') => 'width="66%"', $VM_LANG->_('PHPSHOP_VENDOR_CAT_VENDORS') => 'width="13%"', $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
$db->query($list);
$i = 0;
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    // The Checkbox
    $listObj->addCell(vmCommonHTML::idBox($i, $db->f("vendor_category_id"), false, "vendor_category_id"));

Example #19

File: shipping.rate_list.php Project: noikiy/owaspbwa

    $list .= $q . " LIMIT {$limitstart}, " . $limit;
    $count .= $q;
} else {
    $q = "";
    $list = "SELECT * FROM #__{vm}_shipping_rate ";
    $count = "SELECT count(*) as num_rows FROM #__{vm}_shipping_rate";
    $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($VM_LANG->_('PHPSHOP_RATE_LIST_LBL'), VM_THEMEURL . "images/administration/dashboard/shipping.gif", $modulename, "rate_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $num_rows . ")\" />" => "width=\"20\"", $VM_LANG->_('PHPSHOP_SHIPPING_RATE_LIST_CARRIER_LBL') => '', $VM_LANG->_('PHPSHOP_SHIPPING_RATE_LIST_RATE_NAME') => '', $VM_LANG->_('PHPSHOP_SHIPPING_RATE_LIST_RATE_WSTART') => '', $VM_LANG->_('PHPSHOP_SHIPPING_RATE_LIST_RATE_WEND') => '', $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
$db->query($list);
$i = 0;
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    // The Checkbox
    $listObj->addCell(vmCommonHTML::idBox($i, $db->f("shipping_rate_id"), false, "shipping_rate_id"));

Example #20

File: product.product_discount_list.php Project: BackupTheBerlios/kmit-svn

    $q .= "ORDER BY amount ";
    $list .= $q . " LIMIT {$limitstart}, " . $limit;
    $count .= $q;
} else {
    $list = "SELECT * FROM #__{vm}_product_discount ";
    $list .= "ORDER BY amount ";
    $list .= "LIMIT {$limitstart}, " . $limit;
    $count = "SELECT count(*) as num_rows FROM #__{vm}_product_discount ";
}
$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($VM_LANG->_('PHPSHOP_PRODUCT_DISCOUNT_LIST_LBL'), IMAGEURL . "ps_image/percentage.png", $modulename, "product_discount_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $num_rows . ")\" />" => "width=\"20\"", $VM_LANG->_('PHPSHOP_PRODUCT_DISCOUNT_AMOUNT') => '', $VM_LANG->_('PHPSHOP_PRODUCT_DISCOUNT_AMOUNTTYPE') => '', $VM_LANG->_('PHPSHOP_PRODUCT_DISCOUNT_STARTDATE') => '', $VM_LANG->_('PHPSHOP_PRODUCT_DISCOUNT_ENDDATE') => '', $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
$db->query($list);
$i = 0;
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    // The Checkbox
    $listObj->addCell(vmCommonHTML::idBox($i, $db->f("discount_id"), false, "discount_id"));

Example #21

File: order.order_list.php Project: noikiy/owaspbwa

}
if (!empty($show)) {
    $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'] . "' ";
$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($VM_LANG->_('PHPSHOP_ORDER_LIST_LBL'), VM_THEMEURL . 'images/administration/dashboard/orders.png', $modulename, "order_list");
?>
<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}.order_list&show=" . $navi_db->f("order_status_code"));
    ?>

Example #22

File: product.product_type_parameter_list.php Project: BackupTheBerlios/kmit-svn

if ($product_type_id && $db->f("product_type_name")) {
    $title .= $db->f("product_type_name");
}
$title .= '<a href="' . $_SERVER['PHP_SELF'] . '?option=com_virtuemart&page=product.product_type_list">[' . $VM_LANG->_('PHPSHOP_PRODUCT_TYPE_LIST_LBL') . ']</a>';
$q = "SELECT * FROM #__{vm}_product_type_parameter ";
$q .= "WHERE product_type_id={$product_type_id} ";
$q .= "ORDER BY parameter_list_order asc ";
$q .= "LIMIT {$limitstart}, {$limit}";
$count = "SELECT count(*) as num_rows FROM #__{vm}_product_type_parameter WHERE product_type_id={$product_type_id} ";
$db->query($count);
$num_rows = $db->f("num_rows");
$db->query($q);
// 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($title, IMAGEURL . "ps_image/categories.gif", $modulename, "product_type_parameter_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $num_rows . ")\" />" => "width=\"20\"", $VM_LANG->_('PHPSHOP_PRODUCT_TYPE_PARAMETER_FORM_LABEL') => 'width="25%"', $VM_LANG->_('PHPSHOP_PRODUCT_TYPE_PARAMETER_FORM_NAME') => 'width="20%"', $VM_LANG->_('PHPSHOP_PRODUCT_TYPE_FORM_DESCRIPTION') => 'width="40%"', $VM_LANG->_('PHPSHOP_MODULE_LIST_ORDER') => 'width="5%"', $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
$i = 0;
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    // The Checkbox
    $listObj->addCell(vmCommonHTML::idBox($i, $db->f("parameter_name"), false, "parameter_name"));
    $tmp_cell = "<a href=\"" . $_SERVER['PHP_SELF'] . "?option=com_virtuemart&page=product.product_type_parameter_form&product_type_id=" . $db->f("product_type_id") . "&parameter_name=" . $db->f("parameter_name") . "&task=edit\">" . $db->f("parameter_label") . "</a>";

Example #23

File: admin.user_list.php Project: noikiy/owaspbwa

    $q .= "CONCAT( `ui`.`first_name`, ' ', `ui`.`last_name`) LIKE '%{$keyword}%' OR ";
    $q .= "ui.phone_1 LIKE '%{$keyword}%' ";
    $q .= ") AND ";
}
$q .= "(ui.address_type='BT' OR ui.address_type IS NULL) ";
$q .= "AND gid <= " . $my->gid;
$q .= " ORDER BY username ";
$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($VM_LANG->_('PHPSHOP_USER_LIST_LBL'), VM_THEMEURL . 'images/administration/header/icon-48-user.png', $modulename, "user_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => 'width="20"', '<input type="checkbox" name="toggle" value="" onclick="checkAll(' . $num_rows . ')" />' => 'width="20"', $VM_LANG->_('PHPSHOP_USER_LIST_USERNAME') => "", $VM_LANG->_('PHPSHOP_USER_LIST_FULL_NAME') => "", $VM_LANG->_('PHPSHOP_USER_LIST_GROUP') => "", $VM_LANG->_('PHPSHOP_SHOPPER_FORM_GROUP') => "", $VM_LANG->_('E_REMOVE') => 'width="5%"');
$listObj->writeTableHeader($columns);
$db->query($list);
$dbs = new ps_DB();
$i = 0;
while ($db->next_record()) {
    $user_id = $db->f('id') ? intval($db->f('id')) : intval($db->f('user_id'));
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));

Example #24

File: ps_order.php Project: noikiy/owaspbwa

 /**
  * Shows the list of the orders of a user in the account mainenance section
  *
  * @param string $order_status Filter by order status (A=all, C=confirmed, P=pending,...)
  * @param int $secure Restrict the order list to a specific user id (=1) or not (=0)?
  */
 function list_order($order_status = 'A', $secure = 0)
 {
     global $VM_LANG, $CURRENCY_DISPLAY, $sess, $limit, $limitstart, $keyword, $mm_action_url;
     $ps_vendor_id = $_SESSION["ps_vendor_id"];
     $auth = $_SESSION['auth'];
     require_once CLASSPATH . 'ps_order_status.php';
     require_once CLASSPATH . 'htmlTools.class.php';
     require_once CLASSPATH . 'pageNavigation.class.php';
     $db = new ps_DB();
     $dbs = new ps_DB();
     $listfields = 'o.order_id,o.cdate,order_total,o.order_status,order_currency';
     $countfields = 'count(*) as num_rows';
     $count = "SELECT {$countfields} FROM #__{vm}_orders o ";
     $list = "SELECT DISTINCT {$listfields} FROM #__{vm}_orders o ";
     $q = "WHERE o.vendor_id='{$ps_vendor_id}' ";
     if ($order_status != "A") {
         $q .= "AND order_status='{$order_status}' ";
     }
     if ($secure) {
         $q .= "AND user_id='" . $auth["user_id"] . "' ";
     }
     if (!empty($keyword)) {
         $count .= ', #__{vm}_order_item oi ';
         $list .= ', #__{vm}_order_item oi ';
         $q .= "AND (order_item_sku LIKE '%" . $keyword . "%' ";
         $q .= "OR order_number LIKE '%" . $keyword . "%' ";
         $q .= "OR o.order_id=" . (int) $keyword . ' ';
         $q .= "OR order_item_name LIKE '%" . $keyword . "%') ";
         $q .= "AND oi.order_id=o.order_id ";
     }
     $q .= "ORDER BY o.cdate DESC";
     $count .= $q;
     $db->query($count);
     $db->next_record();
     $num_rows = $db->f('num_rows');
     if ($num_rows == 0) {
         echo "<span style=\"font-style:italic;\">" . $VM_LANG->_('PHPSHOP_ACC_NO_ORDERS') . "</span>\n";
         return;
     }
     $pageNav = new vmPageNav($num_rows, $limitstart, $limit);
     $list .= $q .= " LIMIT " . $pageNav->limitstart . ", {$limit} ";
     $db->query($list);
     $listObj = new listFactory($pageNav);
     if ($num_rows > 0) {
         // print out the search field and a list heading
         $listObj->writeSearchHeader('', '', 'account', 'index');
     }
     // start the list table
     $listObj->startTable();
     $listObj->writeTableHeader(3);
     while ($db->next_record()) {
         $order_status = ps_order_status::getOrderStatusName($db->f("order_status"));
         $listObj->newRow();
         $tmp_cell = "<a href=\"" . $sess->url($mm_action_url . "index.php?page=account.order_details&order_id=" . $db->f("order_id")) . "\">\n";
         $tmp_cell .= "<img src=\"" . IMAGEURL . "ps_image/goto.png\" height=\"32\" width=\"32\" align=\"middle\" border=\"0\" alt=\"" . $VM_LANG->_('PHPSHOP_ORDER_LINK') . "\" />&nbsp;" . $VM_LANG->_('PHPSHOP_VIEW') . "</a><br />";
         $listObj->addCell($tmp_cell);
         $tmp_cell = "<strong>" . $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_DATE') . ":</strong> " . vmFormatDate($db->f("cdate"), "%d. %B %Y");
         $tmp_cell .= "<br /><strong>" . $VM_LANG->_('PHPSHOP_ORDER_PRINT_TOTAL') . ":</strong> " . $CURRENCY_DISPLAY->getFullValue($db->f("order_total"), '', $db->f('order_currency'));
         $listObj->addCell($tmp_cell);
         $tmp_cell = "<strong>" . $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_STATUS') . ":</strong> " . $order_status;
         $tmp_cell .= "<br /><strong>" . $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_NUMBER') . ":</strong> " . sprintf("%08d", $db->f("order_id"));
         $listObj->addCell($tmp_cell);
     }
     $listObj->writeTable();
     $listObj->endTable();
     if ($num_rows > 0) {
         $listObj->writeFooter($keyword, '&Itemid=' . $sess->getShopItemid());
     }
 }

Example #25

File: admin.country_state_list.php Project: BackupTheBerlios/kmit-svn

    $search .= "AND ( state_name LIKE '%{$keyword}%' OR ";
    $search .= "state_2_code LIKE '%{$keyword}%' OR ";
    $search .= "state_3_code LIKE '%{$keyword}%' ";
    $search .= ") ";
}
$q .= "WHERE country_id='{$country_id}' ";
$q .= $search;
$q .= "ORDER BY state_name ";
$q .= " LIMIT {$limitstart}, " . $limit;
$db->query($q);
$database->setQuery("SELECT FOUND_ROWS() as num_rows");
$num_rows = $database->loadResult();
// 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($title, VM_THEMEURL . "/images/administration/dashboard/countries.png", "admin", "country_state_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $num_rows . ")\" />" => "", $VM_LANG->_('PHPSHOP_STATE_LIST_NAME') => "", $VM_LANG->_('PHPSHOP_STATE_LIST_3_CODE') => "", $VM_LANG->_('PHPSHOP_STATE_LIST_2_CODE') => "", $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
$i = 0;
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    // The Checkbox
    $listObj->addCell(vmCommonHTML::idBox($i, $db->f("state_id"), false, "state_id"));
    $tmp_cell = "<a href=\"" . $sess->url($_SERVER['PHP_SELF'] . "?page=admin.country_state_form&limitstart={$limitstart}&keyword=" . urlencode($keyword) . "&state_id=" . $db->f("state_id") . "&country_id=" . $country_id) . "\">";

Example #26

File: product.product_product_type_list.php Project: albertobraschi/Hab

*
* http://virtuemart.net
*/
$product_id = vmGet($_REQUEST, 'product_id', 0);
$product_parent_id = vmGet($_REQUEST, 'product_parent_id', 0);
global $ps_product_type;
require_once CLASSPATH . "pageNavigation.class.php";
require_once CLASSPATH . "htmlTools.class.php";
$q = "SELECT * FROM #__{vm}_product_type,#__{vm}_product_product_type_xref ";
$q .= "WHERE #__{vm}_product_type.product_type_id=#__{vm}_product_product_type_xref.product_type_id ";
$q .= "AND product_id='" . $product_id . "' ";
$q .= "ORDER BY product_type_list_order asc ";
$db->setQuery($q);
$db->query();
// Create the List Object with page navigation
$listObj = new listFactory();
$title = $VM_LANG->_('PHPSHOP_PRODUCT_PRODUCT_TYPE_LIST_LBL');
if (!empty($product_parent_id)) {
    $title .= " " . $VM_LANG->_('PHPSHOP_ITEM') . ": ";
} else {
    $title .= " " . $VM_LANG->_('PHPSHOP_PRODUCT') . ": ";
}
$url = $_SERVER['PHP_SELF'] . "?page={$modulename}.product_form&product_id={$product_id}&product_parent_id={$product_parent_id}";
$title .= "<a href=\"" . $sess->url($url) . "\">" . $ps_product->get_field($product_id, "product_name") . "</a>";
// print out the search field and a list heading
$listObj->writeSearchHeader($title, IMAGEURL . "ps_image/product_code.png", $modulename, "product_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $db->num_rows() . ")\" />" => "width=\"20\"", $VM_LANG->_('PHPSHOP_PRODUCT_TYPE_FORM_NAME') => 'width="25%"', $VM_LANG->_('PHPSHOP_PRODUCT_TYPE_FORM_DESCRIPTION') => 'width="30%"', $VM_LANG->_('PHPSHOP_PRODUCT_TYPE_FORM_PARAMETERS') => 'width="15%"', $VM_LANG->_('PHPSHOP_PRODUCTS_LBL') => 'width="15%"', $VM_LANG->_('E_REMOVE') => "width=\"10%\"");
$listObj->writeTableHeader($columns);

Example #27

File: admin.user_form.php Project: noikiy/owaspbwa

$db->next_record();
$num_rows = $db->f("num_rows");
if ($num_rows) {
    $tabs->startTab($VM_LANG->_('PHPSHOP_ORDER_LIST_LBL') . ' (' . $num_rows . ')', "order-list");
    ?>
	        
	<h3><?php 
    echo $VM_LANG->_('PHPSHOP_ORDER_LIST_LBL');
    ?>
 </h3>
	
	<?php 
    // Create the Page Navigation
    $pageNav = new vmPageNav($num_rows, $limitstart, $limit);
    // Create the List Object with page navigation
    $listObj = new listFactory($pageNav);
    $listObj->startTable();
    // these are the columns in the table
    $columns = array("#" => "width=\"20\"", $VM_LANG->_('PHPSHOP_ORDER_LIST_ID') => '', $VM_LANG->_('PHPSHOP_CHECK_OUT_THANK_YOU_PRINT_VIEW') => '', $VM_LANG->_('PHPSHOP_ORDER_LIST_CDATE') => '', $VM_LANG->_('PHPSHOP_ORDER_LIST_MDATE') => '', $VM_LANG->_('PHPSHOP_ORDER_LIST_STATUS') => '', $VM_LANG->_('PHPSHOP_ORDER_LIST_TOTAL') => '', $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
    $listObj->writeTableHeader($columns);
    $db->query($list);
    $i = 0;
    while ($db->next_record()) {
        $listObj->newRow();
        // The row number
        $listObj->addCell($pageNav->rowNumber($i));
        $url = $_SERVER['PHP_SELF'] . "?page=order.order_print&limitstart={$limitstart}&keyword=" . urlencode($keyword) . "&order_id=" . $db->f("order_id");
        $tmp_cell = "<a href=\"" . $sess->url($url) . "\">" . sprintf("%08d", $db->f("order_id")) . "</a><br />";
        $listObj->addCell($tmp_cell);
        $details_url = $sess->url($_SERVER['PHP_SELF'] . "?page=order.order_printdetails&amp;order_id=" . $db->f("order_id") . "&amp;no_menu=1");
        $details_url = stristr($_SERVER['PHP_SELF'], "index2.php") ? str_replace("index2.php", "index3.php", $details_url) : str_replace("index.php", "index2.php", $details_url);

Example #28

File: coupon.coupon_list.php Project: noikiy/owaspbwa

    $q .= "ORDER BY coupon_id ";
    $list .= $q . " LIMIT {$limitstart}, " . $limit;
    $count .= $q;
} else {
    $list = "SELECT * FROM #__{vm}_coupons ";
    $list .= "ORDER BY coupon_id ";
    $list .= "LIMIT {$limitstart}, " . $limit;
    $count = "SELECT count(*) as num_rows FROM #__{vm}_coupons ";
}
$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($VM_LANG->_('PHPSHOP_COUPON_LIST'), IMAGEURL . "ps_image/percentage.png", $modulename, "coupon_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "width=\"20\"", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $num_rows . ")\" />" => "width=\"20\"", $VM_LANG->_('PHPSHOP_COUPON_CODE_HEADER') => '', $VM_LANG->_('PHPSHOP_COUPON_PERCENT_TOTAL') => '', $VM_LANG->_('PHPSHOP_COUPON_TYPE') => '', $VM_LANG->_('PHPSHOP_COUPON_VALUE_HEADER') => '', $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
$db->query($list);
$i = 0;
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    // The Checkbox
    $listObj->addCell(vmCommonHTML::idBox($i, $db->f("coupon_id"), false, "coupon_id"));

Example #29

File: admin.usergroup_list.php Project: BackupTheBerlios/kmit-svn

    $where[] = "(group_name LIKE '%{$keyword}%' )";
}
if (!empty($where)) {
    $q = ' WHERE ' . implode(' AND ', $where);
}
$count = "SELECT count(*) as num_rows FROM " . $usergroup->_table_name . $q;
$list = "SELECT * FROM " . $usergroup->_table_name . $q;
$list .= "\nORDER BY group_level, group_name";
$list .= "\nLIMIT {$limitstart}, " . $limit;
$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($VM_LANG->_('VM_USERGROUP_LIST_LBL'), VM_THEMEURL . 'images/administration/dashboard/shoppers.png', "admin", "usergroup_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $num_rows . ")\" />" => "", $VM_LANG->_('VM_USERGROUP_NAME') => "width=\"40%\"", $VM_LANG->_('VM_USERGROUP_LEVEL') => "width=\"20%\"", $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
$db->query($list);
$i = 0;
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));
    // The Checkbox
    $listObj->addCell(vmCommonHTML::idBox($i, $db->f("group_id"), false, "group_id"));

Example #30

File: admin.user_field_list.php Project: BackupTheBerlios/kmit-svn

*
* http://virtuemart.net
*/
mm_showMyFileName(__FILE__);
require_once CLASSPATH . "pageNavigation.class.php";
require_once CLASSPATH . "htmlTools.class.php";
$where = array();
if ($keyword != "") {
    $where[] = "(f.name LIKE '%{$keyword}%' OR f.type LIKE '%{$keyword}%')";
}
$db->setQuery("SELECT COUNT(*)" . "\nFROM #__{vm}_userfield AS f " . (count($where) ? "\nWHERE " . implode(' AND ', $where) : ""));
$total = $db->loadResult();
echo $db->getErrorMsg();
$pageNav = new vmPageNav($total, $limitstart, $limit);
// Create the List Object with page navigation
$listObj = new listFactory($pageNav);
// print out the search field and a list heading
$listObj->writeSearchHeader($VM_LANG->_('VM_MANAGE_USER_FIELDS'), $mosConfig_live_site . "/administrator/images/addusers.png", "admin", "user_field_list");
// start the list table
$listObj->startTable();
// these are the columns in the table
$columns = array("#" => "", "<input type=\"checkbox\" name=\"toggle\" value=\"\" onclick=\"checkAll(" . $pageNav->limit . ")\" />" => "", $VM_LANG->_('VM_FIELDMANAGER_NAME') => "width=\"20%\"", $VM_LANG->_('VM_FIELDMANAGER_TITLE') => "width=\"20%\"", $VM_LANG->_('VM_FIELDMANAGER_TYPE') => "width=\"10%\"", $VM_LANG->_('VM_FIELDMANAGER_REQUIRED') => "width=\"5%\"", $VM_LANG->_('VM_FIELDMANAGER_PUBLISHED') => "width=\"5%\"", $VM_LANG->_('VM_FIELDMANAGER_SHOW_ON_REGISTRATION') => "width=\"5%\"", $VM_LANG->_('VM_FIELDMANAGER_SHOW_ON_SHIPPING') => "width=\"5%\"", $VM_LANG->_('VM_FIELDMANAGER_SHOW_ON_ACCOUNT') => "width=\"5%\"", $VM_LANG->_('VM_FIELDMANAGER_REORDER') => "width=\"5%\"", vmCommonHTML::getSaveOrderButton(min($total - $pageNav->limitstart, $pageNav->limit), 'changeordering') => 'width="8%"', $VM_LANG->_('E_REMOVE') => "width=\"5%\"");
$listObj->writeTableHeader($columns);
$db->query("SELECT f.fieldid, f.sys, f.title, f.name, f.description, f.type, f.required, f.published, f.account, f.ordering, f.registration, f.shipping" . "\nFROM #__{vm}_userfield AS f" . (count($where) ? "\nWHERE " . implode(' AND ', $where) : "") . "\n ORDER BY f.ordering" . "\nLIMIT {$pageNav->limitstart}, {$pageNav->limit}");
// The list of fields which CAN'T BE UNPUBLISHED OR UNREQUIRED
$coreFields = array('username', 'email', 'password', 'password2');
$i = 0;
while ($db->next_record()) {
    $listObj->newRow();
    // The row number
    $listObj->addCell($pageNav->rowNumber($i));