<?php
$current_date = date('Y-m-d');
$condition = 'salary.salary_occurence="2" AND employee_id="' . $model->employee_id . '" and t.isActive="Y" AND valid_from <="' . $current_date . '" AND valid_to ="0000-00-00"';
$model_salary = EmployeeSalary::model()->with('salary')->find(array('select' => 'sum(amount) as amount,valid_from', 'condition' => $condition));
$total_salary = 0.00;
$salary_date = "";
$salary_month = "";
if ($model_salary->amount > 0) {
    $total_salary = $model_salary->amount;
    $salary_date = date("d/m/Y", strtotime($model_salary->valid_from));
    $salary_month = date("m/Y", strtotime($model_salary->valid_from));
}
$month_name=HrGenerelSettings::getMonthName($model->month);
?>
<style>

    @page {

        /*margin-top: 1.9cm;*/
        margin-bottom: 0cm !important;
        margin-left: 0cm;
        margin-right: 0cm;
        header: html_myHeader;
        footer: html_myfooter;
        font-family: 'Oswald', sans-serif;


    }
    @import url('https://fonts.googleapis.com/css?family=Open+Sans:400,600,700,800');

    table, tr, td{
        border:solid 1px #333333;
        border-collapse: collapse;
        padding: 10px;

    }
</style>
<!DOCTYPE html>
<html>
    <head>
        <title>Salary Transfer Certificate</title>

    </head>
    <?php
    $effective_date = '';
    if ($model->visit_from != '0000-00-00' && $model->visit_from != '') {
        $effective_date = date("d/m/Y", strtotime($model->visit_from));
    }
    ?>
    <body style="width: 960px; margin: 0 auto; font-family: open sans; font-size: 15px !important;">
        <div class="">
            <div class="col-6">
                <br>
                    <div class="h3" style="margin-top: 0;margin-bottom: 0;">
                        <?php echo " "; ?>
                    </div>
            </div>
            <div style="text-align: right;margin-right: 50px;">
                <div>
                    <img src="uploads/logo/<?php echo $model->employeedetail->branch_sponsor->branch_or_sponsor_logo; ?>" style="height: 70px">
                </div>
                
            </div>
        </div>
        <br>
        
        <div class="page" style="width: 80%; margin: 0 auto; font-family: open sans;">
            <div class="">
                <div style="text-align: left">
                    <p><?php echo $model->employeedetail->branch_sponsor->branch_or_sponsor_code.'/'.$model->mascertificate->code;?>/<?php echo $ref_no; ?>/<?php echo date('y');?></p>
                    <p>Date: <?php echo date("d/m/Y"); ?></p>
                    <p>To,<br><?php echo $model->addresses_to; ?></p>
                    
                </div>

                <br>

                <div style="text-align: left;">
                    <h4>Re: Salary Transfer Letter </h4>
                </div>
                <div style="text-align: left;">
                    Dear Sir/Madam,
                </div>
                <div style="text-align: justify;">
                    <p>
                        This is to certify that <?php echo $sign . '' . $model->employeedetail->employeefullname; ?> holder of <?php echo $model->employeedetail->employeenationality->nationality; ?> passport <?php echo $model_document->document_number ?> is working with us since <?php echo date_format(date_create($model->employeedetail->date_join), "d/m/Y") ?>  as <?php echo $model->employeedetail->designationdetail->designation_name; ?> and drawing a monthly salary of <?php echo $model->employeedetail->currencydetails->currency_code . ' ' . $total_salary; ?>/- (<?php echo $model->employeedetail->currencydetails->currency_code . " " . ucfirst($this->widget('ext.NumtoWord.NumtoWord', array('num' => floatval($total_salary)))->result) . ' Only'; ?>)all inclusive.</p>
                    <p>We confirm that his monthly salary will be transferred with yourselves from <?php echo $month_name;?> <?php echo $model->salary_year;?> month onwards for the credit of his <?php echo $model->employeedetail->employee_iban_no; ?>. We further undertake not to transfer the salary to any other bank unless the employee above produces a clearance letter from you.</p>
                    <p>In case of his resignation/termination, we will inform you accordingly and will transfer his gratuity and final settlement of his dues for his account with your bank.</p>
                    <p>Please note that this letter is only issued upon the request of the above-mentioned employee and does not, in no way and under no circumstances, constitute any financial responsibility, guarantee and/or liability towards the repayment of any loan amount to you from our part.</p>

                </div>
                <p>Kind Regards,</p><br><br>
                <br>
                <div>                    
                    <?php
                    foreach ($signature as $value) {
                        echo '<h4>' . $value . '</h4>';
                    }
                    ?> 

                </div>
            </div>
        </div>
        <br>

<?php
if($model->employeedetail->branch_sponsor->footer_logo!=''){
?>
    <htmlpagefooter name="myfooter" style="">
        <div style="width:100%; border-top: 1px solid black;">
            <img src="<?php echo Yii::app()->baseUrl; ?>/uploads/logo/<?php echo $model->employeedetail->branch_sponsor->footer_logo; ?>" style="width:100%;margin-bottom:-40px !important;">
        </div>
    </htmlpagefooter>
    <?php } ?>
</body>

</html>