/** * Function creates a template to display the orders available. * @param array $result * @param integer $paging * @param integer $prev * @param integer $next * @param integer $dropdown * @param array $dropupdatedata * @param array $orderProduct * @return string */ function displayOrders($result, $paging, $prev, $next, $dropdown, $dropupdatedata, $orderProduct) { $obj = new Display_DOrderManagement(); $orderst = array('', 'Pending', 'Processing', 'Delivered', 'AwaitingPayment', 'Cancel'); $orderstatuslist = '<select name="selorderstatus" style="width:70px;"><option value="" >All</option>'; for ($i = 1; $i < 6; $i++) { $orderstatuslist .= $_POST['selorderstatus'] == $i ? '<option value=' . $i . ' selected="selected">' . $orderst[$i] . '</option>' : '<option value="' . $i . '">' . $orderst[$i] . '</option>'; } $orderstatuslist .= '</select>'; if (count($dropupdatedata) > 0) { $mmcat = $_POST["selupdatedropdown"]; $updrop = "<select id='selupdatedropdown' name='selupdatedropdown'>"; foreach ($dropupdatedata as $row) { $orderstatusname = $row['orders_status_name']; $orderstatusid = $row['orders_status_id']; $updrop .= $mmcat == $orderstatusid ? "<option value='{$orderstatusid}' selected='selected'>{$orderstatusname}</option>" : "<option value='{$orderstatusid}'>{$orderstatusname}</option>"; } $updrop .= "</select>"; } $output = ' <form name="frmorders" method="post"><div class="blocks" style="opacity: 1;"> <div class="clsListing clearfix"><table cellspacing="0" cellpadding="0" border="0" class="table table-striped table-bordered table-hover"> <!--<tr > <td colspan=8 align=right valign=top><input type="hidden" name="selection" value="search" /><input type="button" value="Search" class="all_bttn" onclick="document.frmorders.selection.value=\'Update\';/* document.frmorders.action=\'?do=disporders\'; */document.frmorders.submit(); "/></td> </tr> <tr><td colspan="2" align=left valign=top><a href="#" onclick="return selDeSel(\'sel\');">Select</a>/<a href="#" onclick="return selUnDeSel(\'sel\');"> Unselect All</a> </td> <td> </td> <td colspan="2" valign=top> Change order status to</td><td>' . $updrop . '</td> <td colspan=2 align=right valign=top><input type="hidden" name="selection" value="Update" /><input type="button" class="all_bttn" value="Update" onclick="document.frmorders.selection.value=\'Update\'; document.frmorders.action=\'?do=disporders&action=update\'; document.frmorders.submit(); " /></td> </tr>--> <!--' . (isset($_GET['msg']) ? '<div align="center" style="padding:3px;"><font color="green"><b>' . $_GET['msg'] . '</b></font></span>' : "") . '--> <thead class="green_bg"> <tr> <th align="left">Order Id</th> <th align="left">Name</th> <th align="left">Order Date</th> <th align="left" >Bill Name</th> <th align="left">Ship Name</th> <th align="left">Order total</th> <th align="left">Status</th> <th align="left">Options</th> </tr> </thead><tbody> <tr class="list_search_bg"> <td valign=top><input type="text" name="orderid" id="orderid" style="width:50px" value="' . $_POST['orderid'] . '" /></td> <td valign="top" ><input type="text" name="dispname" id="dispname" value="' . $_POST['dispname'] . '" style="width:75px"/></td> <td><table style="margin-top:-5px;"><tr><td style="border:none">From</td><td style="border:none"><input type="text" name="txtfromdate" id="txtfromdate" size=6 value="' . $_POST['txtfromdate'] . '" /> </td></tr><tr><td style="border:none">To</td><td style="border:none"><input type="text" name="txttodate" id="txttodate" size=6 value="' . $_POST['txttodate'] . '" /></td></tr></table> </td> <td valign=top><input type="text" name="billname" id="billname" value="' . $_POST['billname'] . '" style="width:50px"/></td> <td valign=top><input type="text" name="shipname" id="shipname" value="' . $_POST['shipname'] . '" style="width:50px"/></td> <td><table style="margin-top:-5px;"><tr><td style="border:none">From</td><td style="border:none"><input type="text" name="ordertotalfrom" id="ordertotalfrom" size=6 value="' . $_POST['ordertotalfrom'] . '" /></td></tr><tr><td style="border:none">To</td><td style="border:none"><input type="text" name="ordertotalto" id="ordertotalto" size=6 value="' . $_POST['ordertotalto'] . '"/></td></tr></table> </td> <td align="left" class="product_search">' . $orderstatuslist . '</td> <td align="center"><input type="submit" value="Search" class="clsBtn" onclick="document.frmorders.selection.value=\'Update\';/* document.frmorders.action=\'?do=disporders\'; */document.frmorders.submit(); " /></td> </tr>'; $i = 1; $cnt = 0; if (count($result) > 0) { foreach ($result as $row) { $id = $row['orders_id']; $dispname = $row['Name']; $customerid = $row['customers_id']; $bilname = $row['billing_name']; $shipname = $row['shipping_name']; $status = $row['orders_status_name']; $statusid = $row['orders_status_id']; $currency_tocken = $row['currency_tocken']; $amount = $row['order_total']; $dropdowndata = $obj->dropdownOrderStatus($dropdown, $statusid); $purchaseddatetime = $row['date_purchased']; $purchased_date_time = explode(" ", $purchaseddatetime); $purchased_date = explode("-", $purchased_date_time[0]); $purchased_time = explode(":", $purchased_date_time[1]); $purchaseddate = date("l, M d, Y ", mktime(0, 0, 0, $purchased_date[1], $purchased_date[2], $purchased_date[0])); if ($i % 2 == 0) { $output .= '<tr class="content_list_txt2" id="order' . $i . '"><td align="left" class="content_list_txt2"><img src="images/plus.gif" onclick="showOrderDetail(' . $i . ')" id="quick' . $i . '" title="Click to Quick View">' . $id . '</td><td class="content_list_txt2"><a href="?do=customerdetail&action=detail&userid=' . $customerid . '">' . $dispname . '</a></td><td class="content_list_txt2">' . $purchaseddate . '</td><td class="content_list_txt2"">' . $bilname . '</td><td class="content_list_txt2">' . $shipname . '</td><td class="content_list_txt2" align="right"><span class="badge badge-success">' . $currency_tocken . ' ' . '' . $amount . '</span></td><td class="content_list_txt2">' . $dropdowndata . '</td><td class="content_list_txt1"><a href="?do=disporders&action=viewdetail&id=' . $id . '" title="View Order"><i class="icon icon-eye-open"></i></a> <a href="?do=disporders&action=detail&id=' . $id . '"><i class="icon icon-edit"></i></a> <a href="?do=disporders&action=cancel&id=' . $id . '" onclick="return confirm(\'Are you sure you want to Cancel this Order?\')"><i class="icon-trash"></i></a> <a href="javascript:window.open (\'?do=disporders&action=print&id=' . $id . '\',\'mywindow\',\'location=1,status=1,scrollbars=1,width=920,height=700\');void(0);"><i class="icon icon-print"></i> </a> <a href="?do=disporders&action=mail&id=' . $id . '"><i class="icon icon-inbox"></i> </a></td><tr>'; } else { $output .= '<tr class="content_list_txt1" id="order' . $i . '"><td class="content_list_txt1" align="left"><img src="images/plus.gif" onclick="showOrderDetail(' . $i . ')" id="quick' . $i . '" title="Click to Quick View">' . $id . '</td><td class="content_list_txt1"><a href="?do=customerdetail&action=detail&userid=' . $customerid . '">' . $dispname . '</a></td><td class="content_list_txt1">' . $purchaseddate . '</td><td class="content_list_txt1"">' . $bilname . '</td><td class="content_list_txt1">' . $shipname . '</td><td class="content_list_txt1" align="right"><span class="badge badge-success">' . $currency_tocken . ' ' . '' . $amount . '</span></td><td class="content_list_txt1">' . $dropdowndata . '</td><td class="content_list_txt1"><a href="?do=disporders&action=viewdetail&id=' . $id . '"><i class="icon icon-eye-open"></i></a> <a href="?do=disporders&action=detail&id=' . $id . '"><i class="icon icon-edit"></i></a> <a href="?do=disporders&action=cancel&id=' . $id . '" onclick="return confirm(\'Are you sure you want to Cancel this Order?\')"><i class="icon-trash"></i></a> <a href="javascript:window.open (\'?do=disporders&action=print&id=' . $id . '\',\'mywindow\',\'location=1,status=1,scrollbars=1,width=920,height=700\');void(0);"><i class="icon icon-print"></i> </a> <a href="?do=disporders&action=mail&id=' . $id . '"><i class="icon icon-inbox"></i> </a></td><tr>'; } $output .= '<tr class="clshiderow' . $i . ' dlsrow" > <td colspan="8" valign="top" align="center"> <div style="display:none;background-color:#DBF3FF;" id="orderDetail' . $i . '">' . Display_DOrderManagement::getOrderDesc($result[$cnt], $orderProduct) . '</div> </td></tr>'; $i++; $cnt++; } // $output.='<tr><td colspan="8" class="content_list_txt1" valign="top" align=center><!--<input type=submit value="Save">--></td></tr>'; } else { $output .= '<tr><td colspan="9" class="content_list_txt1" valign="top" width="100%"><div class="exc_msgbox" width="100%" style="width:900px"> No Orders Present</div></td></tr>'; } $output .= '<tr> <td colspan="8" class="clsAlignRight"> <div class="dt-row dt-bottom-row"> <div class="row-fluid"> <div class="dataTables_paginate paging_bootstrap pagination"> <ul>' . ' ' . $prev . ' '; for ($i = 1; $i <= count($paging); $i++) { $pagingvalues .= $paging[$i] . " "; } $output .= $pagingvalues . ' ' . $next . '</ul></div> </div> </div> </td> </tr>'; $output .= '</tbody></table></div></div></form>'; return $output; }
function showChangeShipping() { $sql = "SELECT * FROM shipments_master_table WHERE status='1'"; $obj = new Bin_Query(); $obj->executeQuery($sql); $records = $obj->records; $sqlOrder = "SELECT * FROM orders_table WHERE orders_id='" . $_GET['id'] . "' "; $objOrder = new Bin_Query(); $objOrder->executeQuery($sqlOrder); $shipping_method = $objOrder->records[0]['shipping_method']; $shipment_id = $objOrder->records[0]['shipment_id_selected']; $buyer_zipcode = $objOrder->records[0]['shipping_postcode']; $shipment_track_id = $objOrder->records[0]['shipment_track_id']; $order_ship = $objOrder->records[0]['order_ship']; $order_total = $objOrder->records[0]['order_total']; $sqlOrderPro = "SELECT * FROM order_products_table WHERE order_id='" . $_GET['id'] . "' "; $objOrderPro = new Bin_Query(); $objOrderPro->executeQuery($sqlOrderPro); $recordsOrderPro = $objOrderPro->records; if (count($recordsOrderPro) > 0) { $totalweight = 0; $productWeight = ''; $shipping_cost = ''; $totalshipcost = 0; for ($i = 0; $i < count($recordsOrderPro); $i++) { $sqlProduct = "SELECT product_id,weight,shipping_cost FROM products_table WHERE product_id='" . $recordsOrderPro[$i]['product_id'] . "'"; $objProduct = new Bin_Query(); $objProduct->executeQuery($sqlProduct); $productWeight = $objProduct->records[0]['weight']; $shipping_cost = $objProduct->records[0]['shipping_cost']; $weight = $productWeight * $recordsOrderPro[$i]['product_qty']; $shipcost = $shipping_cost * $recordsOrderPro[$i]['product_qty']; $totalweight = $totalweight + $weight; $totalshipcost = $totalshipcost + $shipcost; } } return Display_DOrderManagement::showChangeShipping($records, $shipment_id, $buyer_zipcode, $totalweight, $totalshipcost, $shipping_method, $shipment_track_id, $order_ship, $order_total); }