316 lines
15 KiB
PHP
316 lines
15 KiB
PHP
@extends('layouts.app')
|
|
|
|
@section('title', __('accounting::lang.transactions'))
|
|
|
|
@section('content')
|
|
|
|
@include('accounting::layouts.nav')
|
|
|
|
<!-- Content Header (Page header) -->
|
|
<section class="content-header">
|
|
<h1>@lang( 'accounting::lang.transactions' )</h1>
|
|
</section>
|
|
|
|
<!-- Main content -->
|
|
<section class="content">
|
|
<div class="row">
|
|
<div class="col-xs-12">
|
|
|
|
<div class="col-xs-12 pos-tab-container">
|
|
<div class="col-lg-2 col-md-2 col-sm-2 col-xs-2 pos-tab-menu">
|
|
<div class="list-group">
|
|
<a href="#" class="list-group-item text-center active">@lang('sale.sale')</a>
|
|
<a href="#" class="list-group-item text-center">@lang('accounting::lang.sales_payments')</a>
|
|
<a href="#" class="list-group-item text-center">@lang('purchase.purchases')</a>
|
|
<a href="#" class="list-group-item text-center">@lang('accounting::lang.purchase_payments')</a>
|
|
<a href="#" class="list-group-item text-center">@lang('accounting::lang.expenses')</a>
|
|
</div>
|
|
</div>
|
|
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10 pos-tab">
|
|
@include('accounting::transactions.partials.sales')
|
|
</div>
|
|
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10 pos-tab">
|
|
@include('accounting::transactions.partials.payments', ['id' => "sell_payment_table"])
|
|
</div>
|
|
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10 pos-tab">
|
|
@include('accounting::transactions.partials.purchases')
|
|
</div>
|
|
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10 pos-tab">
|
|
@include('accounting::transactions.partials.payments', ['id' => "purchase_payment_table"])
|
|
</div>
|
|
<div class="col-lg-10 col-md-10 col-sm-10 col-xs-10 pos-tab">
|
|
@include('accounting::transactions.partials.expenses')
|
|
</div>
|
|
</div>
|
|
|
|
</div>
|
|
</div>
|
|
|
|
</section>
|
|
<!-- /.content -->
|
|
@stop
|
|
|
|
@section('javascript')
|
|
@include('accounting::accounting.common_js')
|
|
<script type="text/javascript">
|
|
$(document).ready( function(){
|
|
sell_table = $('#sell_table').DataTable({
|
|
processing: true,
|
|
serverSide: true,
|
|
aaSorting: [[1, 'desc']],
|
|
"ajax": {
|
|
"url": "/accounting/transactions/?type=sell&datatable=sell",
|
|
"data": function ( d ) {
|
|
if($('#sell_list_filter_date_range').val()) {
|
|
var start = AcDate.rangeStart('#sell_list_filter_date_range');
|
|
var end = AcDate.rangeEnd('#sell_list_filter_date_range');
|
|
d.start_date = start;
|
|
d.end_date = end;
|
|
}
|
|
d.is_direct_sale = 1;
|
|
|
|
d.location_id = $('#sell_list_filter_location_id').val();
|
|
d.customer_id = $('#sell_list_filter_customer_id').val();
|
|
d.payment_status = $('#sell_list_filter_payment_status').val();
|
|
d.created_by = $('#created_by').val();
|
|
d.sales_cmsn_agnt = $('#sales_cmsn_agnt').val();
|
|
d.service_staffs = $('#service_staffs').val();
|
|
|
|
if($('#shipping_status').length) {
|
|
d.shipping_status = $('#shipping_status').val();
|
|
}
|
|
|
|
if($('#sell_list_filter_source').length) {
|
|
d.source = $('#sell_list_filter_source').val();
|
|
}
|
|
|
|
if($('#only_subscriptions').is(':checked')) {
|
|
d.only_subscriptions = 1;
|
|
}
|
|
|
|
d = __datatable_ajax_callback(d);
|
|
}
|
|
},
|
|
scrollY: "75vh",
|
|
scrollX: true,
|
|
scrollCollapse: true,
|
|
columns: [
|
|
{ data: 'action', name: 'action', orderable: false, "searchable": false},
|
|
{ data: 'transaction_date', name: 'transaction_date' },
|
|
{ data: 'invoice_no', name: 'invoice_no'},
|
|
{ data: 'conatct_name', name: 'conatct_name'},
|
|
{ data: 'mobile', name: 'contacts.mobile'},
|
|
{ data: 'business_location', name: 'bl.name'},
|
|
{ data: 'payment_status', name: 'payment_status'},
|
|
{ data: 'payment_methods', orderable: false, "searchable": false},
|
|
{ data: 'final_total', name: 'final_total'},
|
|
{ data: 'total_paid', name: 'total_paid', "searchable": false},
|
|
{ data: 'added_by', name: 'u.first_name'},
|
|
{ data: 'additional_notes', name: 'additional_notes'},
|
|
{ data: 'staff_note', name: 'staff_note'}
|
|
],
|
|
"fnDrawCallback": function (oSettings) {
|
|
__currency_convert_recursively($('#sell_table'));
|
|
}
|
|
});
|
|
|
|
sell_payment_table = $('#sell_payment_table').DataTable({
|
|
processing: true,
|
|
serverSide: true,
|
|
"ajax": {
|
|
"url": "/accounting/transactions/?transaction_type=sell&datatable=payment",
|
|
"data": function ( d ) {
|
|
// d.account_id = $('#account_id').val();
|
|
// var start_date = '';
|
|
// var endDate = '';
|
|
// if($('#date_filter').val()){
|
|
// var start_date = $('#date_filter').data('daterangepicker').startDate.format('YYYY-MM-DD');
|
|
// var endDate = $('#date_filter').data('daterangepicker').endDate.format('YYYY-MM-DD');
|
|
// }
|
|
// d.start_date = start_date;
|
|
// d.end_date = endDate;
|
|
}
|
|
},
|
|
columnDefs:[{
|
|
"targets": 0,
|
|
"orderable": false,
|
|
"searchable": false
|
|
}],
|
|
columns: [
|
|
{data: 'action', name: 'action'},
|
|
{data: 'paid_on', name: 'paid_on'},
|
|
{data: 'payment_ref_no', name: 'payment_ref_no'},
|
|
{data: 'transaction_number', name: 'transaction_number'},
|
|
{data: 'amount', name: 'amount'},
|
|
{data: 'type', name: 'T.type'},
|
|
{data: 'details', name: 'details', "searchable": false},
|
|
],
|
|
"fnDrawCallback": function (oSettings) {
|
|
__currency_convert_recursively($('#sell_payment_table'));
|
|
}
|
|
});
|
|
purchase_payment_table = $('#purchase_payment_table').DataTable({
|
|
processing: true,
|
|
serverSide: true,
|
|
"ajax": {
|
|
"url": "/accounting/transactions/?transaction_type=purchase&datatable=payment",
|
|
"data": function ( d ) {
|
|
// d.account_id = $('#account_id').val();
|
|
// var start_date = '';
|
|
// var endDate = '';
|
|
// if($('#date_filter').val()){
|
|
// var start_date = $('#date_filter').data('daterangepicker').startDate.format('YYYY-MM-DD');
|
|
// var endDate = $('#date_filter').data('daterangepicker').endDate.format('YYYY-MM-DD');
|
|
// }
|
|
// d.start_date = start_date;
|
|
// d.end_date = endDate;
|
|
}
|
|
},
|
|
columnDefs:[{
|
|
"targets": 0,
|
|
"orderable": false,
|
|
"searchable": false
|
|
}],
|
|
columns: [
|
|
{data: 'action', name: 'action'},
|
|
{data: 'paid_on', name: 'paid_on'},
|
|
{data: 'payment_ref_no', name: 'payment_ref_no'},
|
|
{data: 'transaction_number', name: 'transaction_number'},
|
|
{data: 'amount', name: 'amount'},
|
|
{data: 'type', name: 'T.type'},
|
|
{data: 'details', name: 'details', "searchable": false},
|
|
],
|
|
"fnDrawCallback": function (oSettings) {
|
|
__currency_convert_recursively($('#sell_payment_table'));
|
|
}
|
|
});
|
|
|
|
//Purchase table
|
|
purchase_table = $('#purchase_table').DataTable({
|
|
processing: true,
|
|
serverSide: true,
|
|
ajax: {
|
|
url: '/accounting/transactions/?datatable=purchase',
|
|
data: function(d) {
|
|
if ($('#purchase_list_filter_location_id').length) {
|
|
d.location_id = $('#purchase_list_filter_location_id').val();
|
|
}
|
|
if ($('#purchase_list_filter_supplier_id').length) {
|
|
d.supplier_id = $('#purchase_list_filter_supplier_id').val();
|
|
}
|
|
if ($('#purchase_list_filter_payment_status').length) {
|
|
d.payment_status = $('#purchase_list_filter_payment_status').val();
|
|
}
|
|
if ($('#purchase_list_filter_status').length) {
|
|
d.status = $('#purchase_list_filter_status').val();
|
|
}
|
|
|
|
var start = '';
|
|
var end = '';
|
|
if ($('#purchase_list_filter_date_range').val()) {
|
|
start = AcDate.rangeStart('#purchase_list_filter_date_range');
|
|
end = AcDate.rangeEnd('#purchase_list_filter_date_range');
|
|
}
|
|
d.start_date = start;
|
|
d.end_date = end;
|
|
|
|
d = __datatable_ajax_callback(d);
|
|
},
|
|
},
|
|
aaSorting: [[1, 'desc']],
|
|
columns: [
|
|
{ data: 'action', name: 'action', orderable: false, searchable: false },
|
|
{ data: 'transaction_date', name: 'transaction_date' },
|
|
{ data: 'ref_no', name: 'ref_no' },
|
|
{ data: 'location_name', name: 'BS.name' },
|
|
{ data: 'name', name: 'contacts.name' },
|
|
{ data: 'status', name: 'status' },
|
|
{ data: 'payment_status', name: 'payment_status' },
|
|
{ data: 'final_total', name: 'final_total' },
|
|
{ data: 'payment_due', name: 'payment_due', orderable: false, searchable: false },
|
|
{ data: 'added_by', name: 'u.first_name' },
|
|
],
|
|
fnDrawCallback: function(oSettings) {
|
|
__currency_convert_recursively($('#purchase_table'));
|
|
}
|
|
});
|
|
|
|
AcDate.initDaterangepicker('#purchase_list_filter_date_range', dateRangeSettings, function () {
|
|
purchase_table.ajax.reload();
|
|
});
|
|
$('#purchase_list_filter_date_range').on('cancel.daterangepicker', function() {
|
|
$('#purchase_list_filter_date_range').val('');
|
|
purchase_table.ajax.reload();
|
|
});
|
|
|
|
$(document).on('submit', "form#save_accounting_map", function(e){
|
|
e.preventDefault();
|
|
var form = $(this);
|
|
var data = form.serialize();
|
|
transaction_type = $('#transaction_type').val();
|
|
|
|
$.ajax({
|
|
method: 'POST',
|
|
url: $(this).attr('action'),
|
|
dataType: 'json',
|
|
data: data,
|
|
success: function(result) {
|
|
if (result.success == true) {
|
|
$('div.view_modal').modal('hide');
|
|
toastr.success(result.msg);
|
|
if(transaction_type == 'sell'){
|
|
sell_table.ajax.reload();
|
|
} else if(transaction_type == 'sell_payment'){
|
|
sell_payment_table.ajax.reload();
|
|
} else if(transaction_type == 'purchase'){
|
|
purchase_table.ajax.reload();
|
|
} else if(transaction_type == 'purchase_payment'){
|
|
purchase_payment_table.ajax.reload();
|
|
} else if(transaction_type == 'expense'){
|
|
transaction_expense_table.ajax.reload();
|
|
}
|
|
} else {
|
|
toastr.error(result.msg);
|
|
}
|
|
},
|
|
});
|
|
|
|
|
|
});
|
|
|
|
// expense_table
|
|
transaction_expense_table = $('#transaction_expense_table').DataTable({
|
|
processing: true,
|
|
serverSide: true,
|
|
ajax: {
|
|
url: '/accounting/transactions/?type=expense&datatable=expense',
|
|
data: function(d) {
|
|
},
|
|
},
|
|
scrollY: "75vh",
|
|
scrollX: true,
|
|
scrollCollapse: true,
|
|
columns: [
|
|
{ data: 'action', name: 'action', orderable: false, searchable: false },
|
|
{ data: 'transaction_date', name: 'transaction_date' },
|
|
{ data: 'ref_no', name: 'ref_no' },
|
|
{ data: 'recur_details', name: 'recur_details', orderable: false, searchable: false },
|
|
{ data: 'category', name: 'ec.name' },
|
|
{ data: 'sub_category', name: 'esc.name' },
|
|
{ data: 'location_name', name: 'bl.name' },
|
|
{ data: 'payment_status', name: 'payment_status', orderable: false },
|
|
{ data: 'tax', name: 'tr.name' },
|
|
{ data: 'final_total', name: 'final_total' },
|
|
{ data: 'payment_due', name: 'payment_due' },
|
|
{ data: 'expense_for', name: 'expense_for' },
|
|
{ data: 'contact_name', name: 'c.name' },
|
|
{ data: 'additional_notes', name: 'additional_notes' },
|
|
{ data: 'added_by', name: 'usr.first_name'}
|
|
],
|
|
fnDrawCallback: function(oSettings) {
|
|
__currency_convert_recursively($('#transaction_expense_table'));
|
|
}
|
|
});
|
|
});
|
|
</script>
|
|
@stop |