Question about the admin email..

//$jsonItem = json_encode($item->order_product_id); $con = mysqli_connect('localhost', 'janjongerius_mvdmbp', '3F0S3e^tq2Ql', 'janjongerius_JO45BP', 3306); $query_product = mysqli_query($con,"SELECT * FROM pa8ju_hikashop_product_category WHERE product_id = ".$item->product_id." LIMIT 1"); while($run_query_product = mysqli_fetch_array($query_product)){ $product_Category = $run_query_product['category_id']; } $query_category = mysqli_query($con,"SELECT * FROM pa8ju_hikashop_category WHERE category_id = ".$product_Category." LIMIT 1"); while($run_query_category = mysqli_fetch_array($query_category)){ $product_Category_name = $run_query_category['category_name']; asort($product_Category_name); } ?> <?php $unit_category = $item->order_product_category; $cartProduct['PRODUCT_CATEGORY'] = $product_Category_name;

//an array where you'll have the products being sorted $sortingArray = array(); foreach($data->cart->products as $item) { // your code to load the category name // .... $sortingArray[$product_Category_name] = $item; } // sort the whole array based on the category name ksort($sortingArray); // replace the array of products by your sorted array $data->cart->products = $sortingArray; // then, the normal foreach of the preload which uses the data of the products. // ...

//an array where you'll have the products being sorted $sortingArray = array(); foreach($data->cart->products as $item) { $sortingArray[] = array("name"=>"$productCategory->category_name","id"=>"$productCategory->category_id.", "productInCategory"=> $productCategory->product_id); $sortingArray[$product_Category_name] = $item; } // sort the whole array based on the category name ksort($sortingArray); // replace the array of products by your sorted array $data->cart->products = $sortingArray; //End of sortingarray

$categoryArray = array(); $previousCategoryName = ""; $productInCategory = ""; foreach($this->cart->products as $opt_p => $product) { foreach($product->categories as $opt_k => $productCategory) { $categoryArray[] = array("name"=>"$productCategory->category_name","id"=>"$productCategory->category_id.", "productInCategory"=> $productCategory->product_id); } } asort($categoryArray); //print_r($categoryArray); foreach($categoryArray as $index => $data) { //print_r($data); foreach($data as $index2 => $data2) { if($index2 == 'name'){ $categoryName = $data2; } if($index2 == 'id'){ $categoryID = $data2; } if($index2 == 'productInCategory'){ $productInCategory = $data2; } } if ($categoryName != $previousCategoryName) { ?> <tr><td><?php echo $categoryName; ?></td></tr> <?php } $previousCategoryName = $categoryName; foreach($this->cart->products as $k => $product) { if ($product->product_id == $productInCategory) { $cart_product = $this->cart->cart_products[$opt_p];

$sortingArray[] = array("name"=>"$productCategory->category_name","id"=>"$productCategory->category_id.", "productInCategory"=> $productCategory->product_id);

$con = mysqli_connect('localhost', 'janjongerius_mvdmbp', '3F0S3e^tq2Ql', 'janjongerius_JO45BP', 3306); $query_product = mysqli_query($con,"SELECT * FROM pa8ju_hikashop_product_category WHERE product_id = ".$item->product_id." LIMIT 1"); while($run_query_product = mysqli_fetch_array($query_product)){ $product_Category = $run_query_product['category_id']; } $query_category = mysqli_query($con,"SELECT * FROM pa8ju_hikashop_category WHERE category_id = ".$product_Category." LIMIT 1"); while($run_query_category = mysqli_fetch_array($query_category)){ $product_Category_name = $run_query_category['category_name']; }

$con = mysqli_connect('localhost', 'janjongerius_mvdmbp', '3F0S3e^tq2Ql', 'janjongerius_JO45BP', 3306); $query_product = mysqli_query($con,"SELECT * FROM pa8ju_hikashop_product_category WHERE product_id = ".$item->product_id." LIMIT 1"); while($run_query_product = mysqli_fetch_array($query_product)){ $product_Category = $run_query_product['category_id']; } $query_category = mysqli_query($con,"SELECT * FROM pa8ju_hikashop_category WHERE category_id = ".$product_Category." LIMIT 1"); while($run_query_category = mysqli_fetch_array($query_category)){ $product_Category_name = $run_query_category['category_name']; } ?> <?php $cartProduct['PRODUCT_CATEGORY'] = $product_Category_name;

foreach($data->cart->products as $item) {

//an array where you'll have the products being sorted $sortingArray = array(); foreach($data->cart->products as $item) { // your code to load the category name $con = mysqli_connect('localhost', 'janjongerius_mvdmbp', '3F0S3e^tq2Ql', 'janjongerius_JO45BP', 3306); $query_product = mysqli_query($con,"SELECT * FROM pa8ju_hikashop_product_category WHERE product_id = ".$item->product_id." LIMIT 1"); while($run_query_product = mysqli_fetch_array($query_product)){ $product_Category = $run_query_product['category_id']; } $query_category = mysqli_query($con,"SELECT * FROM pa8ju_hikashop_category WHERE category_id = ".$product_Category." LIMIT 1"); while($run_query_category = mysqli_fetch_array($query_category)){ $product_Category_name = $run_query_category['category_name']; $sortingArray[$product_Category_name] = $item; } } // sort the whole array based on the category name ksort($sortingArray); // replace the array of products by your sorted array $data->cart->products = $sortingArray; // then, the normal foreach of the preload which uses the data of the products. foreach($data->cart->products as $item) {

$sortingArray[$product_Category_name] = $item;

$sortingArray[$product_Category_name.'_'.$item->order_product_id] = $item;