PHP orders::retrieveListOverview Examples

Example #1

File: orders-manage.php Project: blasiuscosa/manobo-2008

                    $o['model'] = '<a href="?open=product-detail&amp;products_id=' . $row['products_id'] . '" title="Manage Product Detail">' . $row['products_model'] . '</a>';
                    if ($row['products_orders_status'] == '11') {
                        $product_price = $row['products_quantity'] * $row['final_price'];
                        $o['status'] = number_format($product_price, 2, ',', '.') . ' ' . $row['currency'];
                    } else {
                        $o['status'] = $row['orders_status_name'];
                    }
                    $order_prob[] = $o;
                }
            }
            $result = tep_draw_table('orders', $order_prob);
        } else {
            $result = '<h3 class="red">No Orders</h3>';
        }
    } else {
        $result = $class_o->retrieveListOverview($status);
    }
    echo utf8_encode($result);
    exit;
}
if (isset($_GET['me_action'])) {
    if ($_GET['me_action'] == 'LEADTIMEAVGLOAD') {
        //if (isset($_GET['me_action']) && $_GET['me_action']=='LEADTIMEAVGLOAD') {
        $op_id = tep_db_prepare_input($_GET['orders_products_id']);
        $q = " SELECT * FROM (";
        $q .= " SELECT opsh.orders_products_id, op.leadtime_start_date, opsh.status, opsh.status_date";
        $q .= " FROM orders_products op";
        $q .= " INNER JOIN orders_products_status_history opsh ON opsh.orders_products_id = op.orders_products_id";
        $q .= " WHERE op.status >= 1 AND op.orders_products_id = {$op_id}";
        $q .= " UNION ALL";
        $q .= " SELECT psh.orders_items_id AS orders_products_id, op.leadtime_start_date, CONCAT('4-',SUBSTR(psh.status,1,1)) status, psh.status_date";