<!DOCTYPE html>
<html>

<head>
    <title>Contract 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>CONTRACT 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>Contract Date</th> 
                <th>Contract Date From</th> 
                <th>Contract Date To</th> 
   		<th>Currency</th>
                <th>Grand Total</th>
                <th>Exchange Rate</th>                
                <th>Payment Term</th>
                <th>Sales Group</th>
                <th>Location</th>
                <th>Status</th>
                <th>Contact Name</th>
                <th>Mobile</th>
                <th>Email</th>
           </tr>
       </thead>
       <tbody>
       <?php 
        $condition = '1=1'; ;
            if($contract_from_date != ''){   
                $contract_from_date = str_replace('/', '-', $contract_from_date);
                $contract_from_date = date('Y-m-d',strtotime($contract_from_date));
                $condition .= ' AND t.contract_date >="'.$contract_from_date.'"';
            }
            if($contract_to_date != ''){   
                $contract_to_date = str_replace('/', '-', $contract_to_date);
                $contract_to_date = date('Y-m-d',strtotime($contract_to_date));
                $condition .= ' AND t.contract_date >="'.$contract_to_date.'"';
            }           
            if($customer_id != ''){  
              
                $condition .= ' AND t.customer_id ="' . $customer_id.'"';
            }
             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_id != ''){               
                $condition .= ' AND t.sales_group_id ="' . $sales_group_id.'"';
            }            
            $model_order = Contract::model()->with('customer','customercontact')->findAll(array('condition'=>$condition));
        foreach ($model_order as $i => $model) {
            ?>
        <input type="hidden" id="contract_from_date" name="contract_from_date" value="<?php echo $contract_from_date;?>">  
        <input type="hidden" id="contract_to_date" name="contract_to_date" value="<?php echo $contract_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_id" name="sales_group_id" value="<?php echo $sales_group_id;?>">
  	 	<tr>
               
  	 	<td><?php echo $i+1;?></td>
                <td><?php echo $model->customer->customer_name;?></td>
                <?php if($model->contract_date!='0000-00-00'){ ?>
                <td><?php echo date("d/m/Y", strtotime($model->contract_date));?></td>
                <?php }else{ ?>
                <td>&nbsp;</td>
                <?php } ?>
                <?php if($model->contract_date_from!='0000-00-00'){ ?>
                <td><?php echo date("d/m/Y", strtotime($model->contract_date_from));?></td>
                <?php }else{ ?>
                <td>&nbsp;</td>
                <?php } ?>
                <?php if($model->contract_date_to!='0000-00-00'){ ?>
                <td><?php echo date("d/m/Y", strtotime($model->contract_date_to));?></td>
                <?php }else{ ?>
                <td>&nbsp;</td>
                <?php } ?>
                <td><?php echo $model->currencyname->currency_code;?></td> 
                <td><?php echo $model->grand_total;?></td> 
                <td><?php echo $model->exchange_rate;?></td>                
                <td><?php echo $model->paymentTerms->payment_term;?></td> 
                <td><?php echo $model->salesgroup->group_name;?></td> 
                <td><?php echo $model->location;?></td>
                <?php 
                if($model->status == 'O')
                    $state = "Open";
                else if($model->status == 'A')
                    $state = "Approved";
                else if($model->status == 'E')
                    $state = "Expired";
                ?>
                <td><?php echo $state;?></td> 
                <td><?php echo $model->customercontact->person_name;?></td>
                <td><?php echo $model->mobile;?></td> 
                <td><?php echo $model->email;?></td> 
                <?php } ?>
       </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>
