Exemplo n.º 1
0
     * $sql = sprintf("DELETE FROM categories WHERE id = %d", $catid);
     * $res = $pdb->query($sql);
     */
    $msg = "The selected category was totally removed.";
    // send back to self with messageness
    header("Location: {$_SERVER['PHP_SELF']}?info=" . base64_encode($msg));
}
if ($SHOWFORM) {
    $fex = new formex('POST');
    $fex->js_src_inline = true;
    $fex->add_element($colmap);
    // all those things in $colmap are in the form now
    $fex->set_element_opts('ship_class_id', $shipTypes);
    $fex->add_element('op', array($ACTION, 'submit'));
    // the button
    $fex->set_element_opts('parent_cat_id', cshopUtils::get_all_parent_categories($pdb));
    if ($ACTION == OP_EDIT) {
        $sql = sprintf("SELECT name, descrip, ship_class_id, is_taxable, level, feature_rank, is_active, parent_cat_id , order_weight\n                               , m.filename AS icon_media_id\n                        FROM cm_categories c LEFT JOIN cm_media_files m ON (m.id = c.icon_media_id)\n                        WHERE c.id = %d", $catid);
        $fex->elem_vals = $pdb->getRow($sql);
        $fex->add_element('id', array('hid id', 'hidden', $catid, null));
        // important
        $cat_name = $fex->elem_vals['name'];
        /** if there are zero products in this category, let them delete it **/
        $sql = sprintf("SELECT COUNT(*) FROM cm_products_categories WHERE cm_categories_id = %d", $catid);
        $product_count = $pdb->getOne($sql);
        if ($product_count) {
            $confirm_msg = "There are {$product_count} products that are in this category. If you delete the category, they may be hidden from customers. Are you sure?";
        } else {
            $confirm_msg = 'This will remove this category from the site permanently. Are you sure?';
        }
        $fex->add_element('op_kill', array(OP_KILL, 'submit', null, null, 'onclick="return confirm(\'' . $confirm_msg . '\')"'));
Exemplo n.º 2
0
            $msg = "Product media file was successfully removed";
        }
    }
}
if ($msg and !count($errs)) {
    /** redir on success **/
    header(sprintf("Location: %s?nid=%d&msg=%s", $_SERVER['PHP_SELF'], $productid, base64_encode($msg)));
    exit;
}
if ($ACTION == OP_ADD or $ACTION == OP_EDIT) {
    $fex = new formex('POST');
    $fex->js_src_inline = true;
    $fex->add_element($colmap);
    $fex->add_element('op', array($ACTION, 'submit', null, null, 1));
    $fex->add_element('nid', array('id', 'hidden', $productid, null));
    $fex->set_element_opts('colorways_id', cshopUtils::get_all_colors($pdb, true));
    if ($ACTION == OP_EDIT) {
        $sql = sprintf("SELECT colorways_id, order_weight, class, filename_large AS upfile\n                        FROM {$tablename} WHERE id = %d", $reqid);
        $row = $pdb->getRow($sql);
        $fex->elem_vals = $row;
        $fex->add_element('reqid', array('reqid', 'hidden', $reqid, null));
        $fex->add_element('op_kill', array(OP_KILL, 'submit', null, null, 'onclick="return confirm(\'Are you sure?\')"'));
    }
} else {
    /** list all cm_categories in one big ass dump using HTML_Table **/
    $table = new fu_HTML_Table(array('width' => '90%', 'align' => 'center'));
    $table->setAutoGrow(true);
    $table->setAutoFill("-");
    $header_row = array('class' => 'Class', 'filename_fmt' => 'File Name', 'colorname' => 'Colorway', 'order_weight' => 'weight');
    $table->addRow(array_values($header_row), null, 'TH');
    $table->addCol(array(' '), 'align="center"', 'th');
Exemplo n.º 3
0
    }
}
/** setup the form that goes at the top */
$pc->set_id($productid);
$onchange = 'onchange="cmSetSkuField()"';
$fex = new formex('POST');
$fex->add_element('sizes', array('Size', 'select', array(), null, $onchange, 1));
$fex->add_element('colors', array('Colors', 'select', array(), null, $onchange, 1));
$fex->add_element('qty', array('Qty', 'text', 1, array('size' => 3, 'maxlength' => 6), 1));
$fex->add_element('sku', array('SKU', 'text', '', array('size' => 16, 'maxlength' => 64), 1));
if ($USE_ADDERS) {
    $fex->add_element('adder', array('Adder', 'text', '0.00', array('size' => 7, 'maxlength' => 10), 'onchange="cmAddPrice(this.value)"', 1));
}
$fex->add_element('nid', array('id', 'hidden', $productid, null));
$fex->set_element_opts('sizes', array('' => '-----') + cshopUtils::get_all_sizes($pdb));
$fex->set_element_opts('colors', array('' => '-----') + cshopUtils::get_all_colors($pdb));
if (isset($invid) and $ACTION == OP_EDIT) {
    $sql = sprintf("SELECT i.sizes_id AS sizes, i.colorways_id AS colors, i.qty, i.sku, adder\n                            , IFNULL((p.price + adder), p.price) AS total_price\n                    FROM {$inventory_table} i, cm_products p WHERE i.id = %d AND p.id = i.product_id", $invid);
    $inv_record = $pdb->getRow($sql);
    $fex->elem_vals = $inv_record;
    $killlink = sprintf('%s?op_kill=%d&nid=%d', $_SERVER['PHP_SELF'], $invid, $productid);
}
/* get the product SKU as a base, for the JS magic in the Size/Color selects */
$sku_base = $pc->get_header('sku');
$base_price = $pc->get_header('price');
$total_price = isset($inv_record) ? $inv_record['total_price'] : $base_price;
/** list all inventory records in one big ass dump using HTML_Table **/
$table = new fu_HTML_Table(array('width' => '90%', 'align' => 'center'));
$table->setAutoGrow(true);
$table->setAutoFill("-");
$header_row = array('sku' => 'SKU', 'size' => 'size', 'color' => 'Color', 'qty' => 'Qty.');
Exemplo n.º 4
0
 */
require_once CONFIG_DIR . 'cshop.config.php';
require_once "fu_HTML_Table.class.php";
require_once "filter_form.class.php";
require_once "res_pager.class.php";
require_once "store.edit.inc.php";
/** **/
$range = 50;
$offset = isset($_GET['page']) ? ($_GET['page'] - 1) * $range : 0;
$filt = new filter_form('GET');
$filt->left_td_style = '';
$filt->field_prefix = '';
$filt->add_element('hdr1', array('Category:', 'heading'));
$filt->add_element('cat', array('', 'select', cshopUtils::get_all_categories($pdb, true)));
$filt->add_element('hdr2', array('Manufacturer', 'heading'));
$filt->add_element('mfr', array('', 'select', cshopUtils::get_all_manufacturers($pdb, true)));
$filt->add_element('hdr3', array('SKU', 'heading'));
$filt->add_element('sku', array('', 'text', '', array('size' => 5)));
$filt->add_element('op_filter', array('GO', 'submit'));
/** if there were things selected in the filter forms then make up some WHERE
 * clauses to narrow the results */
$where = '';
$getvars = '';
if (isset($_GET['mfr']) or isset($_GET['cat'])) {
    $where = 'WHERE 1=1 ';
    if (!empty($_GET['mfr'])) {
        $where .= ' AND cm_manufacturers_id = ' . $pdb->quoteSmart($_GET['mfr']);
        $getvars .= '&mfr=' . urlencode($_GET['mfr']);
    }
    if (!empty($_GET['cat'])) {
        $where .= ' AND pc.cm_categories_id = ' . $pdb->quoteSmart($_GET['cat']);
Exemplo n.º 5
0
}
if ($SHOWFORM) {
    $fex->left_td_style = '';
    if ($ACTION == OP_EDIT) {
        $pc->set_id($productid);
    }
    if (isset($pc->colmap_help) && is_array($pc->colmap_help)) {
        foreach ($pc->colmap_help as $k => $text) {
            $fex->set_elem_helptext($k, $text);
        }
    }
    if (isset($colmap['cm_manufacturers_id'])) {
        $fex->set_element_opts('cm_manufacturers_id', cshopUtils::get_all_manufacturers($pdb));
    }
    if (isset($colmap['cm_ship_class_id'])) {
        $fex->set_element_opts('cm_ship_class_id', cshopUtils::get_all_ship_classes($pdb));
    }
    if ($ACTION == OP_EDIT) {
        $fex->elem_vals = $pc->fetch(null, true);
        $product_name = $fex->elem_vals['title'];
        $fex->add_element('id', array('', 'hidden', $productid, null));
        // important
    }
    $fex->add_element('op', array($ACTION, 'submit'));
    // the button
    if ($ACTION == OP_EDIT) {
        $confirm_msg = 'This will remove this product from the site permanently. Are you sure?';
        $fex->add_element('op_kill', array(OP_KILL, 'submit', null, array('class' => 'killButton'), "onclick=\"return confirm('{$confirm_msg}')\""));
    }
}
/* decide which tab to show based on GET param 'win' */