<!DOCTYPE html>
<html>

<head>
    <title>Order List</title>
</head>

<body>
    <div class="heading">
        <div class="logo col-6">
            <img src="images/pdf/logo.png">
        </div>
        <div class="companay_name col-6 text-right">
           <?php
                
                $model_Company = MasCompany::model()->find();
                
                ?>
                
                <h3><?php echo $model_Company->company_name; ?></h3>
                <p><?php echo $model_Company->company_address; ?>
                <?php echo ', '.$model_Company->company_location; ?>
                <?php echo ', '.$model_Company->country->country_name; ?></p>
                <p><?php echo 'Phone : '. $model_Company->company_phone_no; ?></p>
                <p><?php echo 'Email : '.$model_Company->company_email_id; ?></p>
        </div>
    </div>
    <div class="clearfix"></div>
    <div class="title">
        <div class="col-6">
          <div style="height: 10px;"></div>
      </div>
      <div class="col-6 text-right">
        <h1>SALES ORDER LIST</h1>
        <div class="details-box">
        </div>
    </div>
</div>
<div class="clearfix"></div>
<div class="table-body">
    <table id="tbl_enquiry_table" class="table table-fixed table-primary dataTable">
       <thead>
           <tr>
                <th>No</th>               
   		<th>Customer Name</th>
                <th>Order Date</th>
                <th>Delivery Date</th>
   		<th>Currency</th>
                <th>Net Amount</th>
                <th>Final Addition Amount</th>
                <th>Final Deduction Amount</th>
                <th>Net Total</th>
                <th>Grand Total</th> 
                <th>Exchange Rate</th>
                <th>Billing Address</th>
   		<th>Shipping Address</th>
                <th>Sales Group</th>
                <th>Payment Term</th>
                <th>Type of Contract</th>               
                <th>Contact Name</th>
                <th>Mobile</th>
                <th>Email</th>   
           </tr>
       </thead>
       <tbody>
       <?php 
        $condition = '1=1'; ;
            if($order_from_date != ''){   
                $order_from_date = str_replace('/', '-', $order_from_date);
                $order_from_date = date('Y-m-d',strtotime($order_from_date));
                $condition .= ' AND t.order_from_date >="'.$order_from_date.'"';
            }
            if($order_to_date != ''){   
                $order_to_date = str_replace('/', '-', $order_to_date);
                $order_to_date = date('Y-m-d',strtotime($order_to_date));
                $condition .= ' AND t.order_to_date >="'.$order_to_date.'"';
            }
            if($delivery_from_date != ''){    
                $delivery_from_date = str_replace('/', '-', $delivery_from_date);
                $delivery_from_date = date('Y-m-d',strtotime($delivery_from_date));
                $condition .= ' AND t.delivery_from_date <="' . $delivery_from_date.'"';
            }
            if($delivery_to_date != ''){    
                $delivery_to_date = str_replace('/', '-', $delivery_to_date);
                $delivery_to_date = date('Y-m-d',strtotime($delivery_to_date));
                $condition .= ' AND t.delivery_to_date <="' . $delivery_to_date.'"';
            } 
            if($type_of_contract != ''){               
                $condition .= ' AND t.type_of_contract ="' . $type_of_contract.'"';
            }
            if($payment_terms != ''){               
                $condition .= ' AND t.payment_terms ="' . $payment_terms.'"';
            }
            if($sales_group != ''){               
                $condition .= ' AND t.sales_group ="' . $sales_group.'"';
            }            
            if($customer_id != ''){  
              
                $condition .= ' AND t.customer_id ="' . $customer_id.'"';
            }
            $model_order = Order::model()->with('customer','contact')->findAll(array('condition'=>$condition));
        foreach ($model_order as $i => $model) {
            ?>
        <input type="hidden" id="order_from_date" name="order_from_date" value="<?php echo $order_from_date;?>">
        <input type="hidden" id="order_to_date" name="order_to_date" value="<?php echo $order_to_date;?>">
        <input type="hidden" id="delivery_from_date" name="delivery_from_date" value="<?php echo $delivery_from_date;?>">
        <input type="hidden" id="delivery_to_date" name="delivery_to_date" value="<?php echo $delivery_to_date;?>">
        <input type="hidden" id="customer_id" name="customer_id" value="<?php echo $customer_id;?>">
        <input type="hidden" id="type_of_contract" name="type_of_contract" value="<?php echo $type_of_contract;?>">
        <input type="hidden" id="payment_terms" name="payment_terms" value="<?php echo $payment_terms;?>">
         <input type="hidden" id="sales_group" name="sales_group" value="<?php echo $sales_group;?>">
  	 	<tr>
  	 	<td><?php echo $i+1;?></td>
                <td><?php echo $model->customer->customer_name;?></td>
                <?php if($model->order_date!='0000-00-00'){ ?>
                <td><?php echo date("d/m/Y", strtotime($model->order_date));?></td>
                <?php }else{ ?>
                <td>&nbsp;</td>
                <?php } ?>
                <?php if($model->delivery_date!='0000-00-00'){ ?>
                <td><?php echo date("d/m/Y", strtotime($model->delivery_date));?></td>
                <?php }else{ ?>
                <td>&nbsp;</td>
                <?php } ?>
                <td><?php echo $model->currencyname->currency_code;?></td> 
                <td><?php echo $model->net_amount;?></td> 
                <td><?php echo $model->final_addition_amount;?></td> 
                <td><?php echo $model->final_deduction_amount;?></td> 
                <td><?php echo $model->net_total;?></td> 
                <td><?php echo $model->grand_total;?></td> 
                <td><?php echo $model->exchange_rate;?></td> 
                <td><?php echo $model->billing_address;?></td> 
                <td><?php echo $model->shipping_address;?></td> 
                <td><?php echo $model->salesgroup->group_name;?></td> 
                <td><?php echo $model->paymentTerm->payment_term;?></td> 
                <td><?php echo $model->contractdetail->service_group_name;?></td>                 
                <td><?php echo $model->contact->person_name;?></td>
                <td><?php echo $model->mobile;?></td> 
                <td><?php echo $model->email;?></td>                
                <?php } ?>
                </tr>
       </tbody>
   </table>
</div>
<!--    mpdf
        <htmlpagefooter name="myfooter">
            <div style="border-top: 1px dotted #000000; font-size: 12px; text-align: center; padding-top: 10px; ">
                <div style="text-align:center;width:100%">This report is auto generated by Bluesky project on 
                    <?php
                  date_default_timezone_set("Asia/Dubai");
                 echo date('d/m/Y')." ".date("h:i:sa"); ?> </div>
                <div style="text-align:center;width:100%">Page {PAGENO} of {nb} </div>
            </div>
        </htmlpagefooter>
        <sethtmlpagefooter name="myfooter" page="all" value="on" />-->
    
</body>

</html>
