Admin Control Panel v2.0

✎ Editing: index.php ← Back

<?php
include('config.php');
include('includes/config.inc.php');

$brand_query = $database->select("SELECT * FROM brands");
$smarty->assign("brands", $brand_query);

if(isset($_POST['search']) && $_POST['search'] != ''){
    setcookie("search", $_POST['search'], time() + (86400 * 30), "/");
    setcookie("category", $_POST['search_cat'], time() + (86400 * 30), "/");
    header("Location: ".ROOT_URL."items");
    exit;
}

$categories = $database->select("SELECT * FROM items_cat");
$cat = array();
while($row = $database->fetch($categories)){
    $subcategories = $database->select("SELECT * FROM items_scat WHERE item_scat_cat = '".$row['item_cat_id']."'");
    $scat = array();
    while($srow = $database->fetch($subcategories)){
        $rcat = array();
        $categories_rel = $database->select("SELECT * FROM items_cat WHERE item_cat_id = '".$srow['item_scat_cat']."'");
        while($rlrow = $database->fetch($categories_rel)){
             $rcat[] = $rlrow;
        }
        $srow['relcat'] = $rcat;
        $scat[] = $srow;
    }
    $row['scat'] = $scat;
    $cat[] = $row;
}

$smarty->assign('categories', $cat);

$pop_categories = $database->select("SELECT *, COUNT(p.item_id) AS product_count
FROM items_cat c
JOIN items p ON c.item_cat_id = p.item_cat
GROUP BY c.item_cat_id
ORDER BY product_count DESC
LIMIT 6;
");
$pcat = array();
while($row = $database->fetch($pop_categories)){
    $subcategories = $database->select("SELECT * FROM items_scat WHERE item_scat_cat = '".$row['item_cat_id']."'");
    $scat = array();
    while($srow = $database->fetch($subcategories)){
        $scat[] = $srow;
    }
    $row['scat'] = $scat;
    $pcat[] = $row;
}

$smarty->assign('pop_categories', $pcat);

$featured = $database->select("SELECT * FROM items LEFT JOIN items_cat ON items_cat.item_cat_id = items.item_cat WHERE items.item_fea = '1' GROUP BY items_cat.item_cat_id ORDER BY rand()");
$fea_result = array();
$newarr_fea = array();
foreach( $featured as $val )
{
    if( !isset( $fea_result[ $val['item_cat'] ] ) )
    {
        $fea_result[ $val['item_cat'] ] = array
        (
            'item_cat' => functionData('items_cat','item_cat_id',$val['item_cat'],'item_cat_name'),
            'item_cat_id' => $val['item_cat'],
            'items' => 0
        );
    }
    $fea_result[ $val['item_cat'] ]['items']++;
}

foreach( $fea_result as $key => $val ){
    $newarr_fea[] = $val;
}

$smarty->assign('fea_cat', $newarr_fea);

$new_arr = $database->select("SELECT * FROM items WHERE items.item_status = '1' ORDER BY items.item_date DESC");
$result = array();
$newarr = array();
foreach( $new_arr as $val )
{
    if( !isset( $result[ $val['item_cat'] ] ) )
    {
        $result[ $val['item_cat'] ] = array
        (
            'item_cat' => functionData('items_cat','item_cat_id',$val['item_cat'],'item_cat_name'),
            'item_cat_id' => $val['item_cat'],
            'items' => 0
        );
    }
    $result[ $val['item_cat'] ]['items']++;
}

foreach( $result as $key => $val ){
    $newarr[] = $val;
}

$smarty->assign('new_arrivals', $newarr);

$best_sell = $database->select("SELECT *, SUM(cart_items.cart_qty) AS total_quantity
FROM cart_items LEFT JOIN tranzactions ON tranzactions.trn_session COLLATE utf8mb4_general_ci = cart_items.cart_session LEFT JOIN item_images ON item_images.img_item COLLATE utf8mb4_general_ci = cart_items.cart_item
LEFT JOIN items ON items.item_id = cart_items.cart_item
WHERE cart_items.cart_status = '1'
GROUP BY cart_items.cart_item
ORDER BY total_quantity DESC
LIMIT 7;");

$bs = array();
while($row = $database->fetch($best_sell)){
    $avg_rate = $database->select("SELECT AVG(reviews.rev_rate) AS rate_avg, COUNT(*) AS total_rev FROM reviews WHERE rev_item = '".$row['item_id']."'");
    $avg = $database->assoc($avg_rate);
    $check_sku = $database->select("SELECT sum(sku_qty) as total_qty FROM sku WHERE sku_item = '".$row['item_id']."' ORDER BY sku_id ASC");
        $sku = $database->assoc($check_sku);
        $row['sku'] = $sku['total_qty'];
    $fea_query = $database->select("SELECT * FROM features WHERE fea_item = '".$row['item_id']."' LIMIT 5");
        $fea = array();
        while($rfea = $database->fetch($fea_query)){
            $fea[] = $rfea;
        }
    $row['features'] = $fea;
    $row['rate'] = number_format($avg['rate_avg'],1);
    $row['total_rev'] = ($avg['total_rev'] ? $avg['total_rev'] : 0);
    $row['is_new'] = (date("Y/m/d", strtotime($row['item_date']. "+1 month")) < date('Y/m/d', time()) ? false : true);
    $row['is_disc'] = ($row['item_old_price'] != 0 ? true : false);
    $bs[] = $row;
}

$smarty->assign('best_sell', $bs);

if(isset($_GET['action']) && $_GET['action'] == 'quickview'){
$item_data = $database->select("SELECT * FROM items WHERE item_id = '".$database->sanitize($_GET['id'])."' AND item_status = '1'");
$item = array();
while($row = $database->fetch($item_data)){
    $avg_rate = $database->select("SELECT AVG(reviews.rev_rate) AS rate_avg, COUNT(*) AS total_rev FROM reviews WHERE rev_item = '".$row['item_id']."'");
        $avg = $database->assoc($avg_rate);
        $row['rate'] = number_format($avg['rate_avg'],1);
        $row['rate_total'] = (int)$avg['total_rev'];
    $images = $database->select("SELECT * FROM item_images WHERE img_item = '".$row['item_id']."' ORDER BY img_def DESC");
    $image = array();
    while($img = $database->fetch($images)){
       $image[] = $img;
    }
    $row['images'] = $image;
    $attributes = $database->select("SELECT * FROM product_attributes
    LEFT JOIN attributes_cat ON attributes_cat.attr_cat_id = product_attributes.prod_attr_cat_id
    WHERE prod_attr_item_id = '".$row['item_id']."'
    GROUP BY prod_attr_cat_id");

$attr = array();
    while($at = $database->fetch($attributes)){
        $attr_query = $database->select("SELECT * FROM product_attributes LEFT JOIN attributes_val ON attributes_val.attr_id = product_attributes.prod_attr_val_id WHERE prod_attr_cat_id = '".$at['prod_attr_cat_id']."' AND prod_attr_item_id = '".$row['item_id']."'");
        $attr_arr = array();
        while($arow = $database->fetch($attr_query)){
            $attr_arr[] = $arow;
        }
        $at['attr'] = $attr_arr;
       $attr[] = $at;
    }
    $row['attributes'] = $attr;
    $related_items = $database->select("SELECT * FROM items LEFT JOIN item_images ON item_images.img_item = items.item_id AND item_images.img_def = '1' WHERE items.item_cat = '".$row['item_cat']."' OR items.item_name LIKE '%".$row['item_name']."%' OR items.item_tags LIKE '%".$row['item_tags']."%' OR items.item_brand = '".$row['item_brand']."' ORDER BY items.item_id ASC LIMIT 5");
    $related = array();
    while($rel = $database->fetch($related_items)){
        $avg_rel_rate = $database->select("SELECT AVG(reviews.rev_rate) AS rate_avg, COUNT(*) AS total_rev FROM reviews WHERE rev_item = '".$rel['item_id']."'");
        $rel_avg = $database->assoc($avg_rel_rate);
        $rel['rate'] = number_format($rel_avg['rate_avg'],1);
        $rel['rate_total'] = (int)$rel_avg['total_rev'];
        $rel['is_new'] = (date("Y/m/d", strtotime($rel['item_date']. "+1 month")) < date('Y/m/d', time()) ? false : true);
        $rel['is_disc'] = ($rel['item_old_price'] != 0 ? true : false);
        $rel['is_fea'] = ($rel['item_fea'] == 1 ? true : false);
       $related[] = $rel;
    }
    $row['related'] = $related;
    $features_cat = $database->select("SELECT fea_cat FROM features WHERE features.fea_item = '".$row['item_id']."' GROUP BY features.fea_cat");
    $fcat = array();
    while($fc = $database->fetch($features_cat)){
        $features = $database->select("SELECT * FROM features WHERE fea_cat = '".$fc['fea_cat']."'");
        $fea = array();
        while($fe = $database->fetch($features)){
           $fea[] = $fe;
        }
        $fc['val'] = $fea;
       $fcat[] = $fc;
    }
    $check_sku = $database->select("SELECT sku_code, sum(sku_qty) as total_qty FROM sku WHERE sku_item = '".$row['item_id']."' AND sku_qty > 0 ORDER BY sku_id ASC");
    $sku = $database->assoc($check_sku);
    $row['is_av'] = ($sku['total_qty'] < 1 ? 0 : $sku['total_qty']);
    $row['item_sku'] = $sku['sku_code'];
    $row['max_sku'] = $sku['total_qty'];
    $row['fea_cat'] = $fcat;
    $item[] = $row;
}
$smarty->assign('item_data', $item);
    $smarty->display(TEMPLATE_PATH."quickview.html");
    if(isset($_COOKIE['cat_array'])){
        foreach($_COOKIE['cat_array'] as $cat){
            setcookie("quick_attr_".$cat, '', time() - (86400 * 30), "/");
        }
        foreach($_COOKIE['cat_array'] as $cat){
            setcookie("quick_val_".$cat, '', time() - (86400 * 30), "/");
        }
        setcookie("cat_array", '', time() - (86400 * 30), "/");
    }
}else{
    $smarty->display(TEMPLATE_PATH."index.html");
}

Cancel