/** * getOrderSum function * this funciton is to get total sum or the total quantities of all the orders and also by differenciating by user or confirmed orders. * * @todo by providing order id, get the total sums. * @param int id, product id not implemented, always null * @param sting qty, get the toal quantities of orders by providing qty = 'qty' string. * @param bool confirmed, TRUE or FALSE * @return int * @author Ankit Balyan - sf.ankit@gmail.com **/ function getOrderSum($id = NULL, $qty = NULL, $confirmed = FALSE, $user_id = NULL) { $confirmed = $confirmed ? " and orders.order_confirm_ind = {$confirmed} " : ' '; global $wpdb; if (isBrandUser()) { $user_id = isLogin(); if ($qty != 'qty') { $sql = "SELECT SUM(orders.total_price) as dist_total_price \n\t\t\t\tFROM \n\t\t\t\t\trw_orders AS orders \n\t\t\t\tLEFT OUTER JOIN \n\t\t\t\t\trw_products AS product on orders.product_id = product.product_id\n\t\t\t\tLEFT OUTER JOIN\n \trw_brand_user_map AS user_brand ON user_brand.user_id = {$user_id}\n LEFT OUTER JOIN\n \trw_brands AS brand ON brand.brand_id = user_brand.brand_id\n OR brand.brand_parent_id = user_brand.brand_id\n\t where\n\t product.brand_id = brand.brand_id\n\t or\n\t product.brand_id = brand.brand_parent_id\n\t\t\t\t\t\t{$confirmed}"; } elseif ($qty == 'qty') { $sql = "SELECT SUM(orders.total_qty) as dist_total_qty \n\t\t\t\t\tFROM \n\t\t\t\t\t\trw_orders AS orders \n\t\t\t\t\tLEFT OUTER JOIN \n\t\t\t\t\t\trw_products AS product on orders.product_id = product.product_id\n\t\t\t\t LEFT OUTER JOIN\n \trw_brand_user_map AS user_brand ON user_brand.user_id = {$user_id}\n\t LEFT OUTER JOIN\n\t \trw_brands AS brand ON brand.brand_id = user_brand.brand_id\n\t OR brand.brand_parent_id = user_brand.brand_id\n\t\t where\n\t\t product.brand_id = brand.brand_id\n\t\t or\n\t\t product.brand_id = brand.brand_parent_id {$confirmed}"; } $wpdb->get_var($sql); $wpdb->last_query; return $wpdb->get_var($sql); } elseif (isArvindUser()) { if ($qty != 'qty') { $sql = "SELECT SUM(orders.total_price) as dist_total_price \n\t\t\t\tFROM \n\t\t\t\t\trw_orders AS orders \n\t\t\t \twhere 1 {$confirmed}"; } elseif ($qty == 'qty') { $sql = "SELECT SUM(orders.total_qty) as dist_total_qty \n\t\t\t\t\tFROM \n\t\t\t\t\t\trw_orders AS orders \n\t\t\t\t \twhere 1 {$confirmed}"; } if ($user_id) { $sql .= " and orders.created_by = " . $user_id; } $wpdb->get_var($sql); $wpdb->last_query; return $wpdb->get_var($sql); } elseif (count(isDistributor($user_id)) && $user_id && $qty != 'qty') { $sql = "SELECT SUM(orders.total_price) as dist_total_price \n\t\t\t\tFROM \n\t\t\t\t\trw_orders AS orders \n\t\t\t\t\tLEFT OUTER JOIN rw_users as users\n\t\t\t \ton users.user_parent_id = {$user_id} \n\t\t\t \tor users.user_id = {$user_id}\n\t\t\t \twhere orders.created_by = users.user_id {$confirmed}"; } elseif (count(isDistributor($user_id)) && $user_id && $qty == 'qty') { $sql = "SELECT SUM(orders.total_qty) as dist_total_qty \n\t\t\t\tFROM \n\t\t\t\t\trw_orders AS orders \n\t\t\t\t\tLEFT OUTER JOIN rw_users as users\n\t\t\t \ton users.user_parent_id = {$user_id} \n\t\t\t \tor users.user_id = {$user_id}\n\t\t\t \twhere orders.created_by = users.user_id {$confirmed}"; } elseif ($id && $qty != 'qty') { $sql = "SELECT \n\t\t\t\t SUM(orders.total_price) AS user_total_price\n\t\t\t\tFROM\n\t\t\t\t rw_orders AS orders\n\t\t\t\t where orders.created_by = {$id} {$confirmed}"; } elseif ($id && $qty == 'qty') { $sql = "SELECT \n\t\t\t\t SUM(orders.total_qty) AS user_total_qty\n\t\t\t\tFROM\n\t\t\t\t rw_orders AS orders\n\t\t\t\t where orders.created_by = {$id} {$confirmed}"; } elseif (!$id && $qty == 'qty') { $sql = "SELECT \n\t\t\t\t SUM(orders.total_qty) AS user_total_qty\n\t\t\t\tFROM\n\t\t\t\t rw_orders AS orders\n\t\t\t\t where orders.created_by = " . isLogin() . " {$confirmed}"; } else { $sql = "SELECT \n\t\t\t\t SUM(orders.total_price) AS user_total_price\n\t\t\t\tFROM\n\t\t\t\t rw_orders AS orders\n\t\t\t\t where orders.created_by = " . isLogin() . " {$confirmed}"; } $wpdb->get_var($sql); // /echo $wpdb->last_query; return $wpdb->get_var($sql); }
} ?> <?php } ?> </ul> <?php } else { ?> <p>Sorry! there are no orders have been made.</p> <?php } ?> </div> <?php if ($dist = isDistributor()) { ?> <div id="review_order_tab1"> <?php $dealers = getDealersByDistributor(isLogin()); ?> <?php $dealers = array_merge($dist, $dealers); ?> <?php foreach ($dealers as $key => $dealer) { ?> <?php $ordered_ids = getOrderedIdByUser($dealer->user_id); ?>
<option value="C">C</option> <option value="D">D</option> </select> </div> </div> <div class="text-center"> <a href="#" class="btn btn-default get" onclick="cancelDel()">Cancel</a> <input type="submit" name="action" class="btn btn-default get" value="Delete Selected" id=""> </div> </form> </div> <?php /***************else************************/ } elseif (isDistributor()) { ?> <div class="popupFrom"> <form action="" class="form-horizontal" role = "form" id="massDelete" class="massDelete"> <?php /*<!-- <div class="form-group"> <lable class="control-label col-xs-3">User</lable> <div class="col-xs-9"> <select name="massDel[user]" class="" id=""> <option value="">Null</option> <?php foreach ($dealers as $key => $dealer): ?> <?php //if ($dealer->user_id == isLogin()): ?> <option value="<?php echo $dealer->user_id ?>"> <?php echo $dealer->user_fullname ?></option> <?php //endif ?> <?php endforeach; ?> </select>