@include('./admin/util/header')

<div class="row">
                        
                        <div class="row">
                            <div class="col-12">
                                <div class="card">
                                    <div class="card-header">
                                        <h4 class="card-title">Orders</h4>
                                    </div>
                                    <div class="card-body">
        
                                        <table id="datatable" class="table table-bordered dt-responsive  nowrap w-100">
                                        <tr class='tableHeading2'>
                                                <td valign='bottom' height='18'>Date #</td>
                                                <td valign='bottom' class='tableHeadingLink'>Invoice / Order</td>
                                                <td class='tableHeadingLink'> 	Group code</td>
                                                <td valign='bottom'> 
                                                    <a href="javascript:sortColumn('itemStock')" class='tableHeadingLink'>First / last name</a>
                                                </td>
                                                <td valign='bottom'><a href="javascript:sortColumn('catID')" class='tableHeadingLink'>Amount</a></td>
                                                <td valign='bottom'>Date paid</td>
                                                <td valign='bottom'>Ship
                                                    date</td>
                                                    <td valign='bottom'>Cancelled 	 </td>
                                            </tr>

                                            </thead>
        
        
                                            <tbody>
                                            
                                            @php
                                                $rowFormat='';
                                                $dateAdded='Need to add';
                                                $orderIDLink ='';
                                                $editOrderLink ='';
                                                $previewLink ='';
                                                $editGroupLink='';
                                                $fullNameLink='';
                                                $invoiceTotalText='';
                                                $datePaidText='';
                                                $shipText='';
                                                $dateCancelledLink='';
                                                $orderID='';
                                                $delLink='';
                                                $itemsWholesaleTotal=0;
                                                $pageSingle='';
                                                $salesTotal = 0;
                                                $receivedTotal = 0;
                                            @endphp
                                        
                                            @foreach($results as $order)
                                                @php
                                                    $ID = $order->ID;
                                                    $orderID = $order->orderID;
                                                    
                                                    $dateAdded = setDateV2($order->dateAdded);

                                                   
                                                    $groupCode = $order->groupCode;
                                                    $editGroupLink = "<a href='groups_display.asp?groupCode=" . $groupCode . "' class='tableLink'>" . $groupCode . "</a>";
                                                    if (is_null($order->groupCode) || $order->groupCode == "") {
                                                        $editGroupLink = "<font color='#990000'><b>N/A</b></font>";
                                                    }
                                                    $invoiceTotal = $order->invoiceTotal;
                                                    if (!is_null($invoiceTotal)) {
                                                        $invoiceTotal = (double) $invoiceTotal;
                                                    }
                                                    if (!is_numeric($invoiceTotal)) {
                                                        $invoiceTotal = 0;
                                                    }
                                                    $invoiceTotalText = currencyTest($invoiceTotal); // ../ssi/functions_extras

                                                    $orderTypeID = $order->orderTypeID;
                                                    if ($orderTypeID == 0) {
                                                        $invoiceTotalText = "<font color='#cc9933'>" . $invoiceTotalText . "</font>";
                                                    }

                                                    $firstName = $order->firstName;
                                                    $lastName = $order->lastName;
                                                    $fullName = $firstName . "&nbsp;" . $lastName;

                                                    $fullNameLink = "<a href='leader-edit?ID=" . $ID . "' class='tableLink'>" . $fullName . "</a>";
                                                    $orderIDLink = "<a href='" . route('admin/order-edit', ['ID' => $ID, 'orderID' => $orderID]) . "' class='tableLink'>" . $orderID . "</a>";
                                                        $editOrderLink = "<a href='" . route('admin/order-edit', ['orderID' => $orderID, 'ID' => $ID]) . "'><img src='../images/system/icon_system_orders_edit.gif' width='18' height='18' border='0' alt='New order'></a>";

                                                    $datePaid = $order->datePaid;
                                                    if ( $datePaid !="0000-00-00" &&isDate($datePaid)) {
                                                        $payMethodID = $order->payMethodID;
                                                        $payMethodText = getPaymentText($payMethodID); // functions_formatting
                                                        $datePaidText = "<font color='#009900'>" . setDateV2($datePaid) . "</font><br>" . $payMethodText;

                                                        if (isNull($order->dateCancelled)) { // RFQ's are never marked as paid
                                                            $receivedTotal += $invoiceTotal;
                                                        }
                                                    } else {
                                                        // $datePaidText = "<a href='javascript:paid(" . $orderID . ")' class='payLink'>Pay</a>";
                                                        $datePaidText = "<a href='javascript:openPopupWindow('orders_pay.asp?orderID=" . $orderID . "',520,320);' class='payLink'>Pay</a>";
                                                    }

                                                    $shipDate = $order->shipDate;
                                                    if ( $shipDate !="0000-00-00" && isDate($shipDate)) {
                                                        $shipMethod = ($order->shipMethod); // ../ssi/functions_record_display - &nbsp;
                                                        $shipText = setDateV2($shipDate) . "&nbsp;<br>" . $shipMethod;
                                                        $colorCode = $order->colorCode;
                                                        if (!isNull($colorCode)) {
                                                            $shipText = "<font color='#" . $colorCode . "'>" . $shipText . "</font>";
                                                        }
                                                    } else {
                                                        $shipText = "<a href='orders_ship.asp?orderID=" . $orderID . "' class='payLink'>Ship</a>";
                                                    }


                                                    $dateCancelledLink = addSpace($order->dateCancelled); // ../ssi/functions_record_display - &nbsp;
                                           
                                                    if ($dateCancelledLink != "&nbsp;") { // order was cancelled
                                                        $dateCancelledLink = "<font color='#990000'>" . setDateV2($order->dateCancelled) . "</font>";
                                                        if (!isDate($datePaid)) {
                                                            $datePaidText = "&nbsp;";
                                                        }
                                                        if (!isDate($shipDate)) {
                                                            $shipText = "&nbsp;";
                                                        }
                                                        $invoiceTotalText = "<strike>" . $invoiceTotalText . "</strike>";
                                                        $itemsWholesaleTotal = "<strike>" . $itemsWholesaleTotal . "</strike>";
                                                        $delLink = "&nbsp;";
                                                        
                                                        
                                                    } else {
                                                        $salesTotal += $invoiceTotal;
                                                        // Are there terms for this order?
                                                        // dd($salesTotal);
                                                        if (!empty($order->termsID) && !isNull($order->termsID) && !isNull($shipDate) && isNull($datePaid)) {
                                                            $termDays = $order->termDays;
                                                            if (isNull($termDays) || $termDays == "") {
                                                                $termDays = 0;
                                                            }
                                                            if (date("Y-m-d") >= date("Y-m-d", strtotime($shipDate . " + $termDays days"))) { // and not isDate(datePaid) then
                                                                $dateCancelledLink = "<font color='#FF3300'><b>Past Due</b></font>";
                                                            }
                                                        }
                                                    }
                                                    
                                                    $previewLink = "<a href='" . route('admin-account-order-display', ['orderID' => $orderID]) . "' class='tableLink'><img src='../images/system/icon_system_orders_display.gif' width='18' height='18' border='0'></a>";

                                                    $delLink = "<a href='javascript:addDel(" . $orderID . ")' onMouseOver='delHov(" . $orderID . ")' onMouseOut='delOut(" . $orderID . ")'><img src='../images/system/icon_delete_hover.gif' name='del" . $orderID . "' width='20' height='20' border='0' alt='Select this " . $pageSingle . " to be cancelled'></a>";
                                                    // if (!session("adminAccess")) {
                                                    //    $delLink = "&nbsp;";
                                                    // }

                                                    if ( $order->dateCancelled !="0000-00-00" && (isDate($shipDate) || isDate($order->dateCancelled))) {
                                                        $delLink = "&nbsp;";
                                                     }

                                     
                                                @endphp
                                                <tr class='{{ $rowFormat }}'>
                                                    <td >&nbsp;</td>
                                                    <td  height='22'>                                                    <!---->  
                                                </td>
                                                   
                                                    <td></td>
                                                    <td></td>
                                                    <td >&nbsp;</td>
                                                    <td></td>
                                                    <td></td>
                                                    <td><input type='hidden' name='box{{ $orderID }}' value='false'></td>
                                                      <!---->
                                                </tr>
                                            @endforeach

                                            </tbody>
                                        </table>
        
                                    </div>
                                </div>
                            </div> <!-- end col -->
                        </div> <!-- end row -->




@include('../util/footer')