| Server IP : 108.163.255.210 / Your IP : 3.144.252.243 Web Server : Apache System : Linux blossom.urlnameserver.com 3.10.0-1160.80.1.el7.x86_64 #1 SMP Tue Nov 8 15:48:59 UTC 2022 x86_64 User : ( 1172) PHP Version : 7.2.34 Disable Function : eval,escapeshellarg,proc_close,proc_get_status,proc_nice,proc_open,symlink,system,pcntl_exec,getrusage,chown,chgp,closelog,openlog,syslog,define_syslog_variables,php_ini_loaded_file,getservbyname,getservbyport,posix_getgid,posix_getgrgid,proc_terminate,pfsockopen,apache_child_terminate,posix_mkfifo,posix_setpgid,posix_setuid,hypot,pg_host,pos,posix_access,posix_getcwd,posix_getservbyname,myshellexec,getpid,posix_getsid,posix_isatty,posix_kill,posix_mknod,posix_setgid,posix_setsid,posix_setuid,posix_times,posix_uname,ps_fill,posix_getpwuid,global,ini_restore,zip_open,zip_read,rar_open,bzopen,bzread,bzwrite,apache_get_modules,apache_get_version,phpversionphpinfo,php_ini_scanned_files,get_current_user,disk_total_space,diskfreespace,leak,imap_list,hypo,filedump,safe_mode,getmygid,apache_getenv,apache_setenv,bzread,bzwrite,bzopen,phpini,higlight_file,dos_conv,get_cwd,er_log,cmd,e_name,vdir,get_dir,only_read,ftok,ftpexec,posix_getpwnam,mysql_list_dbs,disk_free_space,session_save_path,confirm_phpdoc_compiled,zip_entry_rea,php_u,psockopen,crack_opendict,crack_getlastmessage,crack_closedict,crack_check,fpassthru,posix_get_last_error,posix_getlogin,posix_getgroups,posix_strerror,posix_getrlimit,posix_getpgrp,posix_getgrnam,pos,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/unilinki/public_html/AlpaiAWS/resources/views/admin_old/ |
Upload File : |
@extends('admin.layout')
<style>
.wrapper.wrapper2{
display: block;
}
.wrapper{
display: none;
}
table.table-bordered > thead > tr > th{
border:1px solid #000;
}
table.table-bordered > tbody > tr > td{
border:1px solid #000;
}
</style>
<?php
$settings = DB::table('settings')->get();
$en = json_decode(json_encode($settings),true);
//dd($en[79]['value']);
?>
<body onload="window.print();">
<div class="wrapper wrapper2">
<!-- Main content -->
<section class="invoice">
<!-- title row -->
<div class="col-xs-12">
<div class="row">
@if(session()->has('message'))
<div class="alert alert-success alert-dismissible">
<button aria-hidden="true" data-dismiss="alert" class="close" type="button">×</button>
<h4><i class="icon fa fa-check"></i> {{ trans('labels.Successlabel') }}</h4>
{{ session()->get('message') }}
</div>
@endif
@if(session()->has('error'))
<div class="alert alert-warning alert-dismissible">
<button aria-hidden="true" data-dismiss="alert" class="close" type="button">×</button>
<h4><i class="icon fa fa-warning"></i> {{ trans('labels.WarningLabel') }}</h4>
{{ session()->get('error') }}
</div>
@endif
</div>
</div>
<div class="row">
<div class="col-xs-6">
<h2 class="page-header" style="padding-bottom: 25px">
<img src="{{asset('').$en[15]['value']}}" alt="">
</h2>
</div>
<div class="col-xs-6">
<h2 class="page-header pull-right" style="padding-bottom: 25px">
Tax Invoice/Bill of Supply/Cash Memo <br>
<small class="pull-right">(Triplicate for Supplier)</small>
</h2>
</div>
<!-- /.col -->
</div>
<div class="row">
<div class="col-xs-6">
<h2 class="page-header" style="padding-bottom: 25px">
{{ $en[49]['value'] }}
<small>
{{ $en[4]['value'] }}
</small>
<small>
{{ $en[5]['value'] }}, {{ $en[6]['value'] }} {{ $en[7]['value'] }}, {{ $en[8]['value'] }}
</small>
<small>
Phone : {{ $en[11]['value'] }}
</small>
<small>
Email : {{ $en[3]['value'] }}
</small>
<small>
Pan No : {{ $en[98]['value'] }}
</small>
<small>
GST Registration No : {{ $en[99]['value'] }}
</small>
</h2>
</div>
<!--<div class="col-xs-6">-->
<!-- <h2 class="page-header pull-right" style="padding-bottom: 25px">-->
<!-- <i class="fa fa-globe"></i> {{ trans('labels.OrderID') }}# {{ $data['orders_data'][0]->orders_id }} -->
<!-- <small>{{ trans('labels.OrderedDate') }}: {{ date('d/m/Y', strtotime($data['orders_data'][0]->date_purchased)) }}</small>-->
<!-- </h2>-->
<!--</div> -->
<!-- /.col -->
</div>
<!-- info row -->
<div class="row invoice-info">
<div class="col-sm-4 invoice-col">
{{ trans('labels.CustomerInfo') }}:
<address>
<strong>{{ $data['orders_data'][0]->customers_name }}</strong><br>
{{ $data['orders_data'][0]->customers_street_address }} <br>
{{ $data['orders_data'][0]->customers_city }}, {{ $data['orders_data'][0]->customers_state }} {{ $data['orders_data'][0]->customers_postcode }}, {{ $data['orders_data'][0]->customers_country }}<br>
{{ trans('labels.Phone') }}: {{ $data['orders_data'][0]->customers_telephone }}<br>
{{ trans('labels.Email') }}: {{ $data['orders_data'][0]->email }}
</address>
</div>
<!-- /.col -->
<div class="col-sm-4 invoice-col">
{{ trans('labels.ShippingInfo') }}
<address>
<strong>{{ $data['orders_data'][0]->delivery_name }}</strong><br>
{{ trans('labels.Phone') }}: {{ $data['orders_data'][0]->delivery_phone }}<br>
{{ $data['orders_data'][0]->delivery_street_address }} <br>
{{ $data['orders_data'][0]->delivery_city }}, {{ $data['orders_data'][0]->delivery_state }} {{ $data['orders_data'][0]->delivery_postcode }}, {{ $data['orders_data'][0]->delivery_country }}<br>
<strong> {{ trans('labels.ShippingMethod') }}:</strong> {{ $data['orders_data'][0]->shipping_method }} <br>
<strong> {{ trans('labels.ShippingCost') }}:</strong> @if(!empty($data['orders_data'][0]->shipping_cost)) {{ $data['currency'][19]->value }}{{ $data['orders_data'][0]->shipping_cost }} @else --- @endif <br>
</address>
</div>
<!-- /.col -->
<div class="col-sm-4 invoice-col">
{{ trans('labels.BillingInfo') }}
<address>
<strong>{{ $data['orders_data'][0]->billing_name }}</strong><br>
{{ trans('labels.Phone') }}: {{ $data['orders_data'][0]->billing_phone }}<br>
{{ $data['orders_data'][0]->billing_street_address }} <br>
{{ $data['orders_data'][0]->billing_city }}, {{ $data['orders_data'][0]->billing_state }} {{ $data['orders_data'][0]->billing_postcode }}, {{ $data['orders_data'][0]->billing_country }}<br>
</address>
</div>
<!-- /.col -->
</div>
<?php
$customers = DB::table('customers')->where('customers_id', $data['orders_data'][0]->customers_id)->first();
$det_orders = DB::table('orders')->where('orders_id', $data['orders_data'][0]->orders_id)->first();
//dd($det_orders->order_number);
?>
<div class="row">
<div class="col-xs-6">
<h2 class="page-header" style="padding-bottom: 25px">
<small><strong>Order Number:</strong> {{ $det_orders->order_number }} </small><br>
<small><strong>{{ trans('labels.OrderedDate') }}:</strong> {{ date('d/m/Y', strtotime($data['orders_data'][0]->date_purchased)) }} </small><br>
</h2>
</div>
<div class="col-xs-6">
<h2 class="page-header pull-right" style="padding-bottom: 25px">
<small class="pull-right"><strong>GST Registration No:</strong>
@if(!empty($customers->gst_number))
{{ $customers->gst_number }}
@else
N/A
@endif
</small><br>
<small class="pull-right"><strong>Place of supply:</strong> {{ $data['orders_data'][0]->delivery_state }}</small><br>
<small class="pull-right"><strong>Place of delivery:</strong> {{ $data['orders_data'][0]->delivery_state }}</small><br>
<small class="pull-right"><strong>Invoice Number :</strong> {{ $det_orders->invoice_number }}</small><br>
<small class="pull-right"><strong>Invoice Details :</strong> {{ $det_orders->invoice_detail }}</small><br>
<small class="pull-right"><strong>Invoice Date :</strong> {{ date('d/m/Y', strtotime($data['orders_data'][0]->date_purchased)) }}</small><br>
</h2>
</div>
<!-- /.col -->
</div>
<!-- /.row -->
<!-- Table row -->
<div class="row">
<div class="col-xs-12 table-responsive">
<table class="table table-bordered" style="border-color: #000; margin-bottom: 0px;">
<thead>
<tr style="background: #ccc">
<th>{{ trans('SI No.') }}</th>
<th>{{ trans('Description') }}</th>
<th>{{ trans('Unit Price') }}</th>
<th>{{ trans('labels.Qty') }}</th>
<th>{{ trans('Net Amount') }}</th>
<th>{{ trans('Tax Rate') }}</th>
<th>{{ trans('Tax Type') }}</th>
<th>{{ trans('Tax Amount') }}</th>
<th>{{ trans('Total Amount') }}</th>
</tr>
</thead>
<tbody>
@foreach($data['orders_data'][0]->data as $p => $products)
<?php
$new_product = DB::table('products')->where('products_id', $products->products_id)->first();
$tax_class = DB::table('tax_class')->where('tax_class_id', $new_product->products_tax_class_id)->first();
$tax_rates = DB::table('tax_rates')->where('tax_class_id', $tax_class->tax_class_id)->first();
$net_rate = $tax_rates->tax_rate;
$half_rate = $net_rate/2;
//dd($tax_rates->tax_rate);
if($net_rate == 18){
$new_rate = 1.18;
}elseif($net_rate == 12){
$new_rate = 1.12;
}elseif($net_rate == 9){
$new_rate = 1.09;
}elseif($net_rate == 6){
$new_rate = 1.06;
}else{
$new_rate = 1;
}
$net_amount = ($products->final_price/$new_rate);
$new_net_amount = ($products->final_price - $net_amount);
$half_net_amount = $net_amount/2;
$half_new_net_amount = $new_net_amount/2;
$unit_price = ($tax_rates->tax_rate * $products->final_price)/100;
$half_price = $unit_price/2;
$new_orders = DB::table('orders')->where('orders_id', $products->orders_id)->first();
//dd($new_orders->delivery_state);
?>
<tr>
<td>{{ ++$p }}</td>
<td>{{ $products->products_name }}</td>
<td>{{ $data['currency'][19]->value }}{{ round($net_amount, 2) }}</td>
<td>{{ $products->products_quantity }}</td>
<td>{{ $data['currency'][19]->value }}{{ round($net_amount*$products->products_quantity, 2) }}</td>
<td>
@if($new_orders->delivery_state == 'Delhi')
{{ $half_rate }}% <br>
{{ $half_rate }}%
@else
{{ $net_rate }}%
@endif
</td>
<td>
@if($new_orders->delivery_state == 'Delhi')
CGST <br>
SGST
@else
IGST
@endif
</td>
<td>
@if($new_orders->delivery_state == 'Delhi')
{{ $data['currency'][19]->value }}{{ round($half_new_net_amount, 2) }} <br>
{{ $data['currency'][19]->value }}{{ round($half_new_net_amount, 2) }}
@else
{{ $data['currency'][19]->value }}{{ round($new_net_amount, 2) }}
@endif
</td>
<td>{{ $data['currency'][19]->value }}{{ $products->final_price }}</td>
</tr>
@endforeach
<?php
$order_product_ship = DB::table('orders_products')->where('orders_id', $data['orders_data'][0]->orders_id)->first();
//dd($order_product->products_id);
$new_product_ship = DB::table('products')->where('products_id', $order_product_ship->products_id)->first();
$tax_class_ship = DB::table('tax_class')->where('tax_class_id', $new_product_ship->products_tax_class_id)->first();
$tax_rates_ship = DB::table('tax_rates')->where('tax_class_id', $tax_class_ship->tax_class_id)->first();
$net_rate_ship = $tax_rates_ship->tax_rate;
$half_rate_ship = $net_rate_ship/2;
//dd($net_rate_ship);
if($net_rate_ship == 18){
$new_rate_ship = 1.18;
}elseif($net_rate_ship == 12){
$new_rate_ship = 1.12;
}elseif($net_rate_ship == 9){
$new_rate_ship = 1.09;
}elseif($net_rate_ship == 6){
$new_rate_ship = 1.06;
}else{
$new_rate_ship = 1;
}
$net_amount_ship = ($data['orders_data'][0]->shipping_cost/$new_rate_ship);
$new_net_amount_ship = ($data['orders_data'][0]->shipping_cost - $net_amount_ship);
$half_net_amount_ship = $net_amount_ship/2;
$half_new_net_amount_ship = $new_net_amount_ship/2;
$unit_price_ship = ($tax_rates_ship->tax_rate * $data['orders_data'][0]->shipping_cost)/100;
$half_price_ship = $unit_price_ship/2;
$new_orders_ship = DB::table('orders')->where('orders_id', $products->orders_id)->first();
//dd($new_orders->delivery_state);
?>
<tr>
<td></td>
<td>{{ trans('labels.ShippingCost') }}</td>
<td>{{ $data['currency'][19]->value }}{{ round($net_amount_ship, 2) }}</td>
<td></td>
<td>{{ $data['currency'][19]->value }}{{ round($net_amount_ship, 2) }}</td>
<td>
@if($new_orders_ship->delivery_state == 'Delhi')
{{ $half_rate_ship }}% <br>
{{ $half_rate_ship }}%
@else
{{ $net_rate_ship }}%
@endif
</td>
<td>
@if($new_orders_ship->delivery_state == 'Delhi')
CGST <br>
SGST
@else
IGST
@endif
</td>
<td>
@if($new_orders_ship->delivery_state == 'Delhi')
{{ $data['currency'][19]->value }}{{ round($half_new_net_amount_ship, 2) }} <br>
{{ $data['currency'][19]->value }}{{ round($half_new_net_amount_ship, 2) }}
@else
{{ $data['currency'][19]->value }}{{ round($new_net_amount_ship, 2) }}
@endif
</td>
<td>{{ $data['currency'][19]->value }}{{ $data['orders_data'][0]->shipping_cost }}</td>
</tr>
<tr>
<td colspan='7'><strong>{{ trans('labels.Total') }}:</strong></td>
<td style="background: #ccc;"><strong>{{ $data['currency'][19]->value }}{{ round($new_net_amount + $new_net_amount_ship, 2) }}</strong></td>
<td style="background: #ccc;"><strong>{{ $data['currency'][19]->value }}{{ $data['orders_data'][0]->order_price }}</strong></td>
</tr>
<tr>
<td colspan='9'><strong>
Amount in Words: <br>
<?php
$digit = new NumberFormatter("en", NumberFormatter::SPELLOUT);
echo $digit->format($data['orders_data'][0]->order_price)." only";
?>
</strong></td>
</tr>
<tr>
<td colspan='9' class="text-right">
<strong>
For {{ $en[49]['value'] }}: <br><br>
<img src="{{asset('').$en[100]['value']}}" alt="" style="height: 70px; width: 170px;">
<br><br>
Authorized Signatory
</strong>
</td>
</tr>
</tbody>
</table>
<p><strong>Whether tax is payable under reverse charge - No</strong></p>
</div>
<!-- /.col -->
</div>
<!-- /.row -->
<div class="row">
<!-- /.col -->
<!-- /.col -->
</div>
<!-- /.row -->
</section>
<!-- /.content -->
</div>
<!-- ./wrapper -->
</body>