function get_form_html($form_id, $id)
{
ob_start();
?>
<div id="head_div" style="padding: 5px 0; background-color: #ECECEC; color: #21ACD7;
border-radius: 5px;margin-left: auto; text-align: center; ">
<?php
$user = new user();
$user->id = $_SESSION['user_id'];
$user->getUser();
$company = new company();
$company->id = $user->company_id;
$company->getCompany();
echo "STOCK REPORT OF {$company->company_name} - {$company->company_code}";
?>
</div>
<div style="margin-top: 10px; background-color:transparent;padding-bottom: 30px;">
<style>
div#purchace_items td,div#purchace_items th{
border: 1px solid #21ACD7;
}
div#purchace_items tbody td{
padding: 5px 0 5px 5px;
}
div#purchace_items tbody td input,div#purchace_items tbody td select{
padding: 0;
border: 0;
margin: 0;
height: 100%;
width: 100%;
background-color: transparent;
}
</style>
<input type="text" id="search" placeholder="Enter Search Key here..." style="width: 100%; margin-left: 0px;" onkeyup="search()" />
<style>
img#search{
position: relative;
height: 20px;
width: 20px;
float: right;
top: -29px;
right: 10px;
}
</style>
<img id="search" src="../ui/images/search.png" onclick="search()" />
<div id="purchace_items" style="width: 100%; padding: 10px 0; color: #21ACD7;">
<table id="items_table" style="border-collapse: collapse; width: 100%;
background-color: #fff; border-radius: 10px; color: #21ACD7;">
<thead style="text-align: center;">
<tr status="not_selected">
<th>
#
</th>
<th>
ITEM
</th>
<th>
STOCK COUNT
</th>
<th style="">
SELLING PRIZE
</th>
<th style="">
TAX
</th>
</tr>
</thead>
<tbody style="padding-left: 3px; text-align: center; ">
<?php
$inventry = new inventry();
$inventries = $inventry->getInventryForSpecificCompany($user->company_id);
$i = 0;
if ($inventries == NULL || sizeof($inventries) == 0) {
echo '<tr><td colspan="8"> No Stock Found </td></tr>';
} else {
foreach ($inventries as $inventry) {
?>
<tr id="<?php
echo $inventry->id;
?>
" onclick="select_row(this)" status="not_selected">
<td style="text-align: center;">
<?php
echo ++$i;
?>
</td>
<td id="item_name"><?php
$item = new item();
$item->id = $inventry->item_id;
$item->getItem();
echo $item->item_name . ' (' . $item->item_code . ')';
?>
</td>
<td id="in_stock_count"><?php
echo number_format($inventry->in_stock_count, 3, '.', '');
?>
</td>
<td id="mrp"><?php
echo number_format($inventry->selling_prize, 2, '.', '');
?>
</td>
<td id="tax_category" tax_category_id="<?php
echo $inventry->tax_category_id;
?>
"><?php
$tax = new tax_category();
$tax->id = $inventry->tax_category_id;
$tax->getTaxCategory();
echo $tax->tax_category_name;
?>
</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
</div>
<script type="text/javascript">
function select_row(row) {
var j_row = $(row);
if(j_row.attr('status') == 'selected'){
$('table#items_table tr').attr('status', 'not_selected');
$('table#items_table tr').css('background-color', '#FFF');
$('img#edit').css('display', 'none');
$('img#edit_fade').css('display', 'block');
$('img#delete').css('display', 'none');
$('img#delete_fade').css('display', 'block');
}else{
$('table#items_table tr').attr('status', 'not_selected');
$('table#items_table tr').css('background-color', '#FFF');
j_row.attr('status', 'selected');
j_row.css('background-color', '#C0EFFD');
$('img#edit').css('display', 'block');
$('img#edit_fade').css('display', 'none');
$('img#delete').css('display', 'block');
$('img#delete_fade').css('display', 'none');
}
}
function on_edit_clicked(){
var selected_row = $('tr[status="selected"]');
var item_name = selected_row.find('td#item_name').html();
var id = selected_row.attr('id');
var instock_count = selected_row.find('td#in_stock_count').html();
var mrp = selected_row.find('td#mrp').html();
var tax_category_id = selected_row.find('td#tax_category').attr('tax_category_id');
get_form(25, ///inventry edit form
function (html, tools){
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
var form = $('div#form-body').find('form.action_form');
form.attr('operation', 'update');
form.attr('inventry_id', id);
form.find('input#item_name').val(item_name);
form.find('input#in_stock_count').val(instock_count);
form.find('input#in_stock_count').prop('disabled', null);
form.find('input#mrp').val(mrp);
form.find('input#mrp').prop('disabled', null);
form.find('select#tax_category').find('option#'+tax_category_id).prop('selected', true);
form.find('select#tax_category').prop('disabled', null);
form.find('input[type=submit]').val('UPDATE');
form.find('input[type=submit]').prop('disabled', null);
form.find('input[type=reset]').prop('disabled', null);
$('div#head_div').html('ID : INVENTRY-'+id);
$('div#head_div').css('display', 'block');
},
function (message){
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
}
);
}
function on_delete_clicked(){
var selected_row = $('tr[status="selected"]');
var id = selected_row.attr('id');
if(confirm('Are you sure you want to delete INVENTRY-'+id+' ?' )){
var data = {
form_id : 20,
inventry_id : id
}
delete_form_data(data, function(message) {
get_form(20,
function(html, tools) {
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
}, function(message) {
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
});
alert(message);
}, function(message) {
alert(message);
});
}
}
function on_print_clicked() {
//var date = $('input#date_field').val();
var d = new Date();
var date = d.getDate()+"/"+(parseInt(d.getMonth())+parseInt(1))+"/"+d.getFullYear();
$('div#print_container_header')
.html('<font style="color:#21ACD7; font-size:20px; ">STOCK REPORT OF '+date+'</font>');
var html = $('div#purchace_items').html();
$('div#print_container_body').html(html);
print();
$('div#print_container_header').empty();
$('div#print_container_body').empty();
$('div#print_container_footer').empty();
}
function search(){
var search_key = $('input#search').val();
if(search_key !== ''){
console.log("search key "+ search_key);
searchTable(search_key);
}else{
$('#items_table tr').show();
}
}
function searchTable(inputVal)
{
var table = $('#items_table');
table.find('tr').each(function(index, row)
{
var allCells = $(row).find('td');
if(allCells.length > 0)
{
var found = false;
allCells.each(function(index, td)
{
var regExp = new RegExp(inputVal, 'i');
if(regExp.test($(td).text()))
{
found = true;
return false;
}
});
if(found == true)$(row).show();else $(row).hide();
}
});
}
</script>
<?php
$form = ob_get_clean();
return $form;
}
function get_form_html($form_id, $id)
{
ob_start();
?>
<div id="head_div" style="height: 150px;
width: 320px; background-color: #ECECEC;
border-radius: 5px;margin-left: auto;display: none; ">
</div>
<div style="margin-top: 10px; background-color:transparent;padding-bottom: 30px;">
<style>
div#purchace_items td, div#purchace_items th{
border: 1px solid #21ACD7;
}
div#purchace_items tbody td{
padding: 5px 0 5px 5px;
}
div#purchace_items tbody td input,div#purchace_items tbody td select{
padding: 0;
border: 0;
margin: 0;
height: 100%;
width: 100%;
background-color: transparent;
}
</style>
<input type="text" id="search" placeholder="Enter Search Key here..." style="width: 100%; margin-left: 0px;" onkeyup="search()" />
<style>
img#search{
position: relative;
height: 20px;
width: 20px;
float: right;
top: -29px;
right: 10px;
}
</style>
<img id="search" src="../ui/images/search.png" onclick="search()" />
<div id="purchace_items" style="width: 100%; padding: 10px 0; color: #21ACD7;">
<table id="items_table" style="border-collapse: collapse; width: 100%;
background-color: #fff; border-radius: 10px; color: #21ACD7;">
<thead style="text-align: center;">
<tr status="not_selected">
<th>
#
</th>
<th>
ID
</th>
<th>
ITEM NAME
</th>
<th>
ITEM CODE
</th>
<th style="">
MRP
</th>
<th style="">
UNIT
</th>
<th style="">
PURCHACE RATE
</th>
<th style="">
TAX
</th>
<th style="">
DISCOUNT(%)
</th>
</tr>
</thead>
<tbody style="padding-left: 3px; text-align: center; ">
<?php
$item = new item();
$items = $item->getItems();
$i = 0;
if ($items == NULL || sizeof($items) == 0) {
echo '<tr><td colspan="8"> No Item Found </td></tr>';
} else {
foreach ($items as $item) {
?>
<tr id="<?php
echo $item->id;
?>
" onclick="select_row(this)">
<td style="text-align: center;"><?php
echo ++$i;
?>
</td>
<td id="item_id"><?php
echo 'ITEM-' . $item->id;
?>
</td>
<td id="item_name"><?php
echo $item->item_name;
?>
</td>
<td id="item_code"><?php
echo $item->item_code;
?>
</td>
<td id="mrp"><?php
echo $item->mrp;
?>
</td>
<td id="unit" unit="<?php
echo $item->unit;
?>
"><?php
if ($item->unit == 2) {
echo 'PCS';
} else {
echo 'KGM';
}
?>
</td>
<td id="purchace_rate"><?php
echo $item->purchace_rate;
?>
</td>
<?php
$tax_category = new tax_category();
$tax_category->id = $item->tax_category_id;
$tax_category->getTaxCategory();
?>
<td id="tax_category" tax_category_id="<?php
echo $tax_category->id;
?>
" ><?php
echo $tax_category->tax_category_name;
?>
</td>
<td id="discount_percent"><?php
echo $item->discount_percent;
?>
</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
</div>
<script type="text/javascript">
function select_row(row) {
var j_row = $(row);
if(j_row.attr('status') == 'selected'){
$('table#items_table tr').attr('status', 'not_selected');
$('table#items_table tr').css('background-color', '#FFF');
$('img#edit').css('display', 'none');
$('img#edit_fade').css('display', 'block');
$('img#delete').css('display', 'none');
$('img#delete_fade').css('display', 'block');
}else{
$('table#items_table tr').attr('status', 'not_selected');
$('table#items_table tr').css('background-color', '#FFF');
j_row.attr('status', 'selected');
j_row.css('background-color', '#C0EFFD');
$('img#edit').css('display', 'block');
$('img#edit_fade').css('display', 'none');
$('img#delete').css('display', 'block');
$('img#delete_fade').css('display', 'none');
}
}
function on_edit_clicked(){
var selected_row = $('tr[status="selected"]');
var item_name = selected_row.find('td#item_name').html();
var id = selected_row.attr('id');
var item_code = selected_row.find('td#item_code').html();
var mrp = selected_row.find('td#mrp').html();
var purchace_rate = selected_row.find('td#purchace_rate').html();
var discount_percent = selected_row.find('td#discount_percent').html();
var tax_category_id = selected_row.find('td#tax_category').attr('tax_category_id');
var unit = selected_row.find('td#unit').attr('unit');
get_form(11, ///item create form
function (html, tools){
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
var form = $('div#form-body').find('form.action_form');
form.attr('operation', 'update');
form.attr('item_id', id);
form.find('input#item_name').val(item_name);
form.find('input#item_code').val(item_code);
form.find('input#mrp').val(mrp);
form.find('input#purchace_rate').val(purchace_rate);
form.find('input#discount_percent').val(discount_percent);
form.find('select#tax_category').find('option#'+tax_category_id).prop('selected', true);
form.find('select#unit').find('option#'+unit).prop('selected', true);
form.find('input[type=submit]').val('UPDATE');
$('div#head_div').html('ID : ITEM-'+id);
$('div#head_div').css('display', 'block');
},
function (message){
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
}
);
}
function on_delete_clicked(){
var selected_row = $('tr[status="selected"]');
var id = selected_row.attr('id');
if(confirm('Are you sure you want to delete ITEM-'+id+' ?' )){
var data = {
form_id : 17,
item_id : id
}
delete_form_data(data, function(message) {
get_form(17,
function(html, tools) {
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
}, function(message) {
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
});
alert(message);
}, function(message) {
alert(message);
});
}
}
function on_add_clicked(){
get_form(11, ///item create form
function (html, tools){
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
},
function (message){
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
}
);
}
function search(){
var search_key = $('input#search').val();
if(search_key !== ''){
console.log("search key "+ search_key);
searchTable(search_key);
}else{
$('#items_table tr').show();
}
}
function searchTable(inputVal)
{
var table = $('#items_table');
table.find('tr').each(function(index, row)
{
var allCells = $(row).find('td');
if(allCells.length > 0)
{
var found = false;
allCells.each(function(index, td)
{
var regExp = new RegExp(inputVal, 'i');
if(regExp.test($(td).text()))
{
found = true;
return false;
}
});
if(found == true)$(row).show();else $(row).hide();
}
});
}
</script>
<?php
$form = ob_get_clean();
return $form;
}
function get_form_html($form_id, $id)
{
ob_start();
?>
<style>
.field_name{
width: 20%;
}
.field{
width: 50%;
}
.field input{
width: 100%;
margin-left: 0px;
}
.field .parent{
padding: 0px 0px;
}
.field select{
width: 100%;
}
</style>
<div id="head_div" style="padding: 5px 0; background-color: #ECECEC; color: #21ACD7;
border-radius: 5px;margin-left: auto; text-align: center; ">
ID : SALE - <input style="padding: 0 0 0 5px;" onchange="load_sale()" type="number" id="sale_id" />
</div>
<div style="margin-top: 10px; background-color:transparent;padding-bottom: 30px;">
<form action="#" method="post" onsubmit="return false" class="action_form" operation="update" style="width:100%;">
<table style="width:100%;">
<tr>
<td class="field_name">
<font>CUSTOMER</font>
</td>
<td class="field">
<div class="parent">
<input id="customer_id" onfocus="$(this).css('border', '0px')" list="customers" autocomplete="off" style="border: 0;" disabled/>
</div>
</td>
</tr>
<tr>
<td class="field_name">
<font>DATE & TIME</font>
</td>
<td class="field">
<div class="parent">
<input id="date_and_time" disabled autocomplete="off" style="border: 0;"/>
</div>
</td>
</tr>
<tr>
<td colspan="2">
<style>
div#purchace_items td{
border: 1px solid #21ACD7;
}
div#purchace_items tbody td{
padding: 5px 0 5px 5px;
}
div#purchace_items tbody td input,div#purchace_items tbody td select{
padding: 0;
border: 0;
margin: 0;
height: 100%;
width: 100%;
background-color: transparent;
}
</style>
<div id="purchace_items" style="width: 100%; padding: 10px 0; color: #21ACD7;">
<table id="items_table" style="border-collapse: collapse; width: 100%;
background-color: #fff; border-radius: 10px; color: #21ACD7;">
<thead style="text-align: center;">
<tr>
<td>
#
</td>
<td>
ITEM
</td>
<td style="width: 10%;">
QUANTITY
</td>
<td style="width: 10%;">
RATE
</td>
<td style="width: 10%;">
DISCOUNT(%)
</td>
<td style="width: 10%;">
DISCOUNT
</td>
<td style="width: 10%;">
TOTAL
</td>
<td style="width: 8%;">
DELETE
</td>
</tr>
</thead>
<tbody style="padding-left: 3px;">
<datalist id="items">
<?php
$user = new user();
$user->id = $_SESSION['user_id'];
$user->getUser();
$inv = new inventry();
$invs = array();
$invs = $inv->getInventryForSpecificCompany($user->company_id);
if ($invs != NULL and sizeof($invs) != 0) {
foreach ($invs as $inv) {
if ($inv->in_stock_count > 0) {
$item = new item();
$item->id = $inv->item_id;
$item->getItem();
$tax_category = new tax_category();
$tax_category->id = $inv->tax_category_id;
$tax_category->getTaxCategory();
echo $tax_category->to_string();
echo '<option id="' . $item->id . '"' . ' stock_count="' . $inv->in_stock_count . '"' . ' selling_pize="' . $inv->selling_prize . '"' . ' tax="' . $tax_category->tax_percentage . '"' . ' discount_percent="' . $item->discount_percent . '"' . ' item_name="' . $item->item_name . '"' . ' value="' . $item->item_name . ' - ' . $item->item_code . '" >' . $item->item_name . ' - ' . $item->item_code . '</option>';
}
}
}
?>
</datalist>
<tr status="active" slno="1">
<td style="text-align: center;">1</td><td>
<input type="text" onchange="update_item_details(this)" oninput="update_item_details(this)" onfocus="$(this).css('border', '0px')" autocomplete="off" list="items" id="item" required />
</td>
<td>
<input type="number" min="0" step="any" required onchange="calculate_total(this)" oninput="calculate_total(this)" id="quantity"/>
</td>
<td>
<input type="text" value="0" min="0" required disabled onchange="calculate_total(this)" oninput="calculate_total(this)" id="rate"/>
</td>
<td>
<input type="number" step="0.01" value="0" min="0" max="100" onchange="calculate_total(this)" oninput="calculate_total(this)" id="discount_percent"/>
</td>
<td>
<input type="text" value="0" min="0" required disabled id="discount"/>
</td>
<td>
<input type="text" min="0" required id="total" disabled/>
</td>
<td style="width: 20px; text-align: center; padding-right: 5px;">
<img id="delete_button" onclick="delete_this_row(this)" style="color: #f00; cursor: pointer; height: 20px; width: 20px; margin-right: auto; margin-left: auto;" src="../ui/images/cross_button.png"/>
<img id="activate_button" onclick="enable_this_row(this)" style="color: #f00; cursor: pointer; height: 20px; width: 20px; margin-right: auto; margin-left: auto; display: none;" src="../ui/images/tick_button.png" />
</td>
</tr>
<tr status="active" slno="2">
<td style="text-align: center;">2</td><td>
<input type="text" onchange="update_item_details(this)" oninput="update_item_details(this)" onfocus="$(this).css('border', '0px')" autocomplete="off" list="items" id="item" required />
</td>
<td>
<input type="number" min="0" step="any" required onchange="calculate_total(this)" onkeyup="calculate_total(this)" id="quantity"/>
</td>
<td>
<input type="text" value="0" min="0" required disabled onchange="calculate_total(this)" onkeyup="calculate_total(this)" id="rate"/>
</td>
<td>
<input type="number" step="0.01" value="0" min="0" max="100" onchange="calculate_total(this)" oninput="calculate_total(this)" id="discount_percent"/>
</td>
<td>
<input type="text" value="0" min="0" required disabled id="discount"/>
</td>
<td>
<input type="text" min="0" required id="total" disabled/>
</td>
<td style="width: 20px; text-align: center; padding-right: 5px;">
<img id="delete_button" onclick="delete_this_row(this)" style="color: #f00; cursor: pointer; height: 20px; width: 20px; margin-right: auto; margin-left: auto;" src="../ui/images/cross_button.png"/>
<img id="activate_button" onclick="enable_this_row(this)" style="color: #f00; cursor: pointer; height: 20px; width: 20px; margin-right: auto; margin-left: auto; display: none;" src="../ui/images/tick_button.png" />
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
<tr style="height: 5px;"></tr>
<tr>
<td></td>
<td>
<div style="background-color: #21ACD7; color: #fff; text-align: right; padding-right: 20px;">
<span style="margin-right: 20px;">TOTAL </span>
<span id="total">0.00</span>
</div>
</td>
</tr>
<tr style="display: none;">
<td></td>
<td>
<div style="background-color: #21ACD7; color: #fff; text-align: right; padding-right: 20px;">
<span style="margin-right: 20px;">DISCOUNT </span>
<span id="discount">0.00</span>
</div>
</td>
</tr>
<tr>
<td></td>
<td>
<div style="background-color: #21ACD7; color: #fff; text-align: right; padding-right: 20px;">
<span style="margin-right: 20px;">PAID </span>
<span id="total_paid">0.00</span>
</div>
</td>
</tr>
<tr>
<td></td>
<td>
<div style="background-color: #21ACD7; color: #fff; text-align: right; padding-right: 20px;">
<span style="margin-right: 20px;">BALANCE</span>
<span id="balance">0.00</span>
</div>
</td>
</tr>
<tr style="height: 5px;"></tr>
<tr>
<td></td>
<td>
<div style="padding: 0px 12px;">
<div style="width: 100%; margin-left: -12px; padding: 12px;
background-color: #0d92bb; border-radius: 5px; float: left;">
<div style="width: 33.33%; float: right; ">
<input style="width: 100%;" type="submit" value="UPDATE" />
</div>
<div style="width: 33.33%; float: right; ">
<input style="width: 100%;" type="reset" value="CANCEL" />
</div>
<div style="width: 33.33%;">
<input style="width: 100%;" onclick="add_sale_item()" type="button" value="ADD ITEM" />
</div>
</div>
</div>
</td>
</tr>
</table>
</form>
</div>
<script type="text/javascript">
function update_item_details(item) {
var item_input = $(item);
var item_name = item_input.val();
var item_option_obj = $('datalist#items').find("option[value='" + item_name + "']");
if (item_option_obj.length == "0") {
return;
} else {
var selling_prize = item_option_obj.attr('selling_pize');
var stock_count = item_option_obj.attr('stock_count');
var tax = item_option_obj.attr('tax');
var discount_percent = item_option_obj.attr('discount_percent');
if($.isNumeric(discount_percent)){
discount_percent = parseFloat(discount_percent).toFixed(2);
}else{
discount_percent = 0;
}
var row = item_input.parent('td').parent('tr');
row.find('input#rate').val(selling_prize);
row.find('input#rate').attr('tax', tax);
row.find('input#discount_percent').val(discount_percent);
row.find('input#quantity').prop('max', stock_count);
calculate_total(row.find('input#rate').get(0));
}
}
function calculate_total(field) {
var $parent = $(field).closest('tr');
var $quantity = parseFloat($parent.find('input#quantity').val());
var $rate = parseFloat($parent.find('input#rate').val());
var $total = $quantity * $rate;
$total = $total.toFixed(2);
if ($.isNumeric($total)) {
var discount_percent = parseFloat($parent.find('input#discount_percent').val());
var discount = ($total * discount_percent) / 100;
if($.isNumeric(discount)){
//$parent.find('input#total').attr('discount', discount);
$parent.find('input#discount').val(discount);
$total = $total - discount;
}else{
//$parent.find('input#total').attr('discount', 0);
$parent.find('input#discount').val(0);
}
$parent.find('input#total').val($total);
var $tax_percentage = parseFloat($parent.find('input#rate').attr('tax'));
var $tax = ($total * $tax_percentage) / (100 + $tax_percentage);
//$tax = $tax.toFixed(2);
if($.isNumeric($tax)){
$parent.find('input#total').attr('tax', $tax);
}else{
$parent.find('input#total').attr('tax', 0);
}
} else {
$parent.find('input#total').val(0);
$parent.find('input#total').attr('tax', 0);
$parent.find('input#total').attr('discount', 0);
//$parent.find('input#discount').val(0);
}
calculate_purchace_total();
}
function calculate_purchace_total() {
var items_table = $('#items_table').find('tbody').children();
var total = 0;
var total_tax = 0;
var total_discount = 0;
items_table.each(function() {
var item_total_input = $(this).find('input#total');
var row_status = $(this).attr('status');
var item_total = item_total_input.val();
var item_tax = item_total_input.attr('tax');
var item_discount = $(this).find('input#discount').val();
if ($.isNumeric(item_total) && row_status == 'active') {
total = parseFloat(total) + parseFloat(item_total);
if($.isNumeric(item_tax)){
total_tax = parseFloat(total_tax) + parseFloat(item_tax);
}
if($.isNumeric(item_discount)){
total_discount = parseFloat(total_discount) + parseFloat(item_discount);
}
}
});
total = total.toFixed(2);
total_tax = total_tax.toFixed(2);
$('span#total').html(total);
$('span#total').attr('tax', total_tax);
var paid = $('span#total_paid').html();
paid = parseFloat(paid);
var balance = total - paid;
balance = balance.toFixed(2);
$('span#balance').html(balance);
total_discount = total_discount.toFixed(2);
$('span#total').attr('discount', total_discount);
$('span#discount').val(total_discount);
}
function delete_this_row(delete_btn) {
var row = $(delete_btn).closest('tr');
row.attr('status', 'deativated');
row.css('background-color', '#c0effd');
row.find('input').prop('required', null);
row.find('input').css('border', "0px");
$(delete_btn).css('display', 'none');
$(delete_btn).siblings().first().css('display', 'block');
$(delete_btn).parent('td').css('text-align', 'centre');
calculate_purchace_total();
}
function enable_this_row(enable_btn) {
var row = $(enable_btn).closest('tr');
row.attr('status', 'active');
row.css('background-color', '#fff');
row.find('input').prop('required', 'required');
$(enable_btn).siblings().first().css('display', 'block');
$(enable_btn).css('display', 'none');
$(enable_btn).parent('td').css('text-align', 'centre');
calculate_purchace_total();
}
function add_sale_item() {
var row = '<tr status="active" slno="" previous="false"><td style="text-align: center;"></td><td>'
+ '<input type="text" onchange="update_item_details(this)" oninput="update_item_details(this)" onfocus="$(this).css(\'border\', \'0px\')" autocomplete="off" list="items" id="item" required />'
+ '</td><td><input type="number" min="0" step="any" required onchange="calculate_total(this)" onkeyup="calculate_total(this)" id="quantity"/>'
+ '</td><td><input type="text" value="0" min="0" required disabled onchange="calculate_total(this)" onkeyup="calculate_total(this)" id="rate"/>'
+ '</td><td><input type="number" step="0.01" value="0" min="0" max="100" onchange="calculate_total(this)" oninput="calculate_total(this)" id="discount_percent"/>'
+ '</td><td><input type="text" value="0" min="0" required disabled id="discount"/>'
+ '</td><td><input type="text" min="0" required id="total" disabled/></td><td style="width: 20px; text-align: center; padding-right: 5px;">'
+ '<img id="delete_button" onclick="delete_this_row(this)" style="color: #f00; cursor: pointer; height: 20px; width: 20px; margin-right: auto; margin-left: auto;" src="../ui/images/cross_button.png"/>'
+ '<img id="activate_button" onclick="enable_this_row(this)" style="color: #f00; cursor: pointer; height: 20px; width: 20px; margin-right: auto; margin-left: auto; display: none;" src="../ui/images/tick_button.png" />'
+ '</td></tr>';
var lastcount = $('table#items_table tbody tr:last-child').attr('slno');
if(!($.isNumeric(lastcount))){
lastcount = 0;
}
$('table#items_table tbody').append(row);
lastcount = parseInt(lastcount) + 1;
$('table#items_table tbody tr:last-child').attr('slno', lastcount);
$('table#items_table tbody tr:last-child td:first-child').html(lastcount);
}
function load_sale(){
var sale_id = $('input#sale_id').val();
var data = {
form_id: 2,
sale_id: sale_id
}
get_form_data(data,
function(message, sale) {
//alert(message);
var form = $('form.action_form');
form.find('input#customer_id').val(sale.customer);
form.find('input#date_and_time').val(sale.date + ' - ' + sale.time);
form.find('input#date_and_time').attr('date', sale.date);
form.find('input#date_and_time').attr('time', sale.time);
form.find('input#customer_id').attr('disabled', 'true');
$('table#items_table tbody').empty();
var items = sale.items;
for(var i = 0; i<items.length; i++){
add_sale_item();
var row = $('table#items_table tbody tr:last-child');
var item = items[i];
row.find('input#item').attr('disabled', 'disabled');
row.find('input#item').val(item.item_name);
row.find('input#item').attr('item_id', item.item_id);
row.find('input#quantity').val(item.quantity);
row.find('input#quantity').attr('max', item.quantity);
row.find('input#rate').val(item.rate);
row.find('input#rate').attr('tax', item.tax_rate);
row.find('input#discount_percent').val(item.discount_percent);
row.find('input#total').val(item.total);
row.find('input#total').attr('tax', item.tax);
row.find('input#total').attr('discount', item.discount);
row.find('input#discount').val(item.discount);
row.attr('previous', true);
}
form.find('span#total').html(sale.amount);
form.find('span#total').attr('tax', sale.tax);
form.find('span#total').attr('discount', sale.discount);
form.find('span#discount').html(sale.discount);
form.find('span#total_paid').html(sale.amount);
form.find('span#balance').html('0.00');
form.attr('sale_id', sale.id);
form.attr('customer_name', sale.c_name);
form.attr('customer_id', sale.c_id);
form.find('input[type="button"]').prop('disabled', null);
form.find('input[type="submit"]').prop('disabled', null);
form.find('input[type="reset"]').prop('disabled', null);
form.find('input[type="number"]').prop('disabled', null);
}, function(message) {
var form = $('form.action_form');
form.find('input').prop('disabled', 'disabled');
alert(message);
});
}
$(document).ready(function(e) {
$('form.action_form').on('submit', function(e) {
e.preventDefault();
var items = new Array();
var i = 0;
var items_table = $('#items_table').find('tbody').children();
var invalid_item_precent = false;
items_table.each(function() {
if ($(this).attr('status') == 'active') {
var item_input = $(this).find('input#item');
var item_name = item_input.val();
var item_option_obj = $('datalist#items').find("option[value='" + item_name + "']");
if (item_option_obj.length == "0" && !$(this).attr('previous')) {
item_input.css('border', '1px solid #f00');
invalid_item_precent = true;
return;
} else {
var id;
if($(this).attr('previous') == 'true'){
id = item_input.attr('item_id');
}else{
id = item_option_obj.attr('id');
//var item_name = item_option_obj.attr('item_name');
}
var quantity = $(this).find('input#quantity').val();
quantity = parseFloat(quantity).toFixed(3);
var rate = $(this).find('input#rate').val();
var tax_rate = $(this).find('input#rate').attr('tax');
rate = parseFloat(rate).toFixed(2);
var tax = $(this).find('input#total').attr('tax');
var discount = $(this).find('input#discount').val();
var total = $(this).find('input#total').val();
var item = {
id: id,
quantity: quantity,
rate: rate,
item_name: item_name,
total: total,
tax: tax,
discount: discount,
tax_rate:tax_rate
}
items[i++] = item;
}
}
});
if (invalid_item_precent) {
//alert("Invalid Item Precent");
return;
}
var form_id = 2;
var operation = $(this).attr('operation');
var total = $('span#total').html();
var total_tax = $('span#total').attr('tax');
var total_discount = $('span#total').attr('discount');
var net_total = parseFloat(total) - parseFloat(total_tax);
net_total = net_total.toFixed(2);
var total_paid = $('span#total_paid').html();
total_paid = parseFloat(total_paid);
total_paid = total_paid.toFixed(2);
var balance = $('span#balance').html();
balance = parseFloat(balance);
balance = balance.toFixed(2);
var sale_id = $(this).attr('sale_id');
var customer_name = $(this).attr('customer_name');
var customer_id = $(this).attr('customer_id');
var date = $(this).find('input#date_and_time').attr('date');
var time = $(this).find('input#date_and_time').attr('time');
if(items.length == 0){
items = 'no_items';
}
if (operation == 'update') {
var data = {
form_id: form_id,
sale_id: sale_id,
total: total,
net_amount: net_total,
tax_amount: total_tax,
discount:total_discount,
items: items
}
update_form_data(data, function(message, sale_id) {
//$('form.action_form').get(0).reset();
//alert(message);
print_bill(data, customer_name, customer_id, sale_id, total_paid, balance, date, time);
get_form(2,
function(html) {
$('div#form-body').html(html);
}, function(message) {
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
});
}, function(message) {
alert(message);
});
} else {
alert("Invalid Operation " + form_id + ' - ' + operation);
}
});
function print_bill(data, customer_name, customer_id, sale_id, total_paid, balance, date, time) {
var html = '';
html ='<img id="logo_bill" src="images/nutiez.png"/><br/><font id="print_container_header_company_adderss">Royal Piknik Traders LLP, 29/861</font>'
+'<br/><font id="print_container_header_company_adderss">Parayancheri, Calicut</font><br/><font id="print_container_header_company_adderss">'
+'Phone : 0495 2741095,+91 9388627725</font><br/><font id="print_container_header_company_adderss">The kerala value added tax rules 2005/ form no. 8</font>'
+'<br/><font id="print_container_header_company_adderss">Tin : 32110844692</font>'
+'<br/><font id="print_container_header_company_adderss">True Copy</font>';
$('div#print_container_header').html(html);
html = "<div<!-- style=\"padding:10px 0;\"><table style=\"float:right; font-size: 12px;\">"
+"<tr><td>Date</td><td>:</td><td style=\"text-align:right;\">" + date + "</td></tr>"
+"<tr><td>Time</td><td>:</td><td style=\"text-align:right;\">" + time + "</td></tr></table>";
html = html + "<table style=\"font-size: 12px;\">"
+"<tr><td>Bill No.</td><td>:</td><td>" + sale_id + "</td></tr>"
+"<tr><td>Cust. ID</td><td>:</td><td>" + customer_id + "</td></tr>"
+"<tr><td>Cust. Name</td><td>:</td><td>" + customer_name + "</td></tr></table></div>";
html = html + "<div style=\"border-top:1px dashed #000; margin:10px auto 0 auto;padding:0 0 10px 0;\">"
+ "<table style=\"width:100%;font-size: 12px;\"><tr style=\"border-bottom: 1px solid #000; border-top: 1px solid #000;\">"
+ "<td style=\"width:44%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px;\">Description</td>"
+ "<td style=\"width:14%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:right;\">Qty</td>"
+ "<td style=\"width:14%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:right;\">Rate</td>"
// + "<td style=\"width:15%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:right;\">Amount</td>"
// + "<td style=\"width:10%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:right;\">Tax</td>"
+ "<td style=\"width:14%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:right;\">Tax(%)</td>"
+ "<td style=\"width:14%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:right;\">Total</td></tr>";
var i = 0;
if(data.items == 'no_items'){
html = html + "<tr><td> No item</td></tr>";
}else{
for (var key in data.items) {
var item = data.items[key];
html = html + "<tr><td>" + item.item_name + "</td>"
+"<td style=\"text-align:right;\">" + parseFloat(item.quantity).toFixed(3) + "</td>"
+"<td style=\"text-align:right;\">" + parseFloat(item.rate).toFixed(2) + "</td>"
//+"<td style=\"text-align:right;\">" + (parseFloat(item.total) - parseFloat(item.tax)) + "</td>"
// +"<td style=\"text-align:right;\">" + item.tax + "</td>"
+"<td style=\"text-align:right;\">" + item.tax_rate + "</td>"
+"<td style=\"text-align:right;\">" + parseFloat(item.total).toFixed(2) + "</td>"
+"</tr>";
}
}
html = html + "</table></div>";
html = html + "<div style=\"border-top:1px dashed #000; padding:10px 0;\"><table style=\"margin-left: auto;font-size: 12px;\">";
html = html + "<tr><td>Net. Amount</td><td style=\"margin:0 15;\">:</td><td style=\"text-align:right;\">" + data.net_amount + "</td></tr>";
if(parseFloat(data.discount) > 0 ){
html = html + "<tr><td>Discount</td><td style=\"margin:0 15;\">:</td><td style=\"text-align:right;\">" + data.discount + "</td></tr>";
}
html = html + "<tr><td>Tax</td><td style=\"margin:0 15;\">:</td><td style=\"text-align:right;\">" + data.tax_amount + "</td></tr>";
html = html + "<tr><td>Total</td><td style=\"margin:0 15;\">:</td><td style=\"text-align:right;\">" + data.total + "</td></tr>";
html = html + "<tr><td>Paid</td><td style=\"margin:0 15;\">:</td><td style=\"text-align:right;\">" + total_paid + "</td></tr>";
html = html + "<tr style=\"font-size:18px;\"><td><b>Balance</b></td><td style=\"margin:0 15;\">:</td><td style=\"text-align:right;\"><b>" + balance + "</b></td></tr>";
html = html + "</table></div>";
// console.log("Creating bill : " + html);
$('div#print_container_body').html(html);
html = '';
html = '<font>Thank you for shoping</font><br/><font>Visit again...</font> ';
$('div#print_container_footer').html(html);
print();
$('div#print_container_header').empty();
$('div#print_container_body').empty();
$('div#print_container_footer').empty();
}
});
</script>
<?php
$form = ob_get_clean();
return $form;
}
function get_form_html($form_id, $id)
{
ob_start();
?>
<style>
.field_name{
width: 20%;
}
.field input{
width: 100%;
margin-left: 0px;
}
.field .parent{
padding: 0px 0px;
}
.field select{
width: 100%;
}
</style>
<div id="head_div" style="padding: 5px 0; background-color: #ECECEC; color: #21ACD7;
border-radius: 5px;margin-left: auto;display: none; text-align: center; ">
</div>
<?php
$tax_category = new tax_category();
if ($id != 0) {
$tax_category->id = $id;
$tax_category->getTaxCategory();
}
?>
<div style="margin-top: 10px; background-color:transparent;padding-bottom: 30px;">
<form action="#" method="post" class="action_form" operation="add" style="width:100%;" >
<table style="width:100%;">
<tr>
<td class="field_name">
<font>TAX CATEGORY NAME</font>
</td>
<td class="field">
<div class="parent">
<input value="<?php
echo $tax_category->tax_category_name;
?>
" type="text" id="tax_category_name" required placeholder="eg:5%"/>
</div>
</td>
</tr>
<tr>
<td class="field_name">
<font>TAX(%)</font>
</td>
<td class="field">
<div class="parent">
<input value="<?php
echo $tax_category->tax_percentage;
?>
" type="number" step="any" id="tax_percent" required placeholder="eg:5"/>
</div>
</td>
</tr>
<tr></tr>
<tr>
<td></td>
<td>
<div style="padding: 0px 12px;">
<div style="width: 100%; margin-left: -12px; padding: 12px;
background-color: #0d92bb; border-radius: 5px; float: left;">
<div style="width: 50%; float: right; ">
<input style="width: 100%;" type="submit" value="ADD" />
</div>
<div style="width: 50%;">
<input style="width: 100%;" type="reset" value="CANCEL" />
</div>
</div>
</div>
</td>
</tr>
</table>
</form>
</div>
<script type="text/javascript">
function setFormActionListener(){
$('form.action_form').on('submit', function(e) {
e.preventDefault();
var id = 42;
var operation = $(this).attr('operation');
if (operation == 'add') {
var data = {
form_id: id,
tax_category_name: $('form input#tax_category_name').val(),
tax_percent: $('form input#tax_percent').val()
}
add_form_data(data, function(message) {
load_tax_category_list();
alert(message);
}, function(message) {
alert(message);
});
}else if (operation == 'update') {
var tax_category_id = $(this).attr('tax_category_id');
var data = {
form_id: id,
tax_category_id: tax_category_id,
tax_category_name: $('form input#tax_category_name').val(),
tax_percent: $('form input#tax_percent').val()
}
update_form_data(data, function(message) {
load_tax_category_list();
alert(message);
}, function(message) {
alert(message);
});
} else {
alert("Invalid Operation " + id + ' - ' + operation);
}
});
};
setFormActionListener();
</script>
<?php
$form = ob_get_clean();
return $form;
}
$mysql_error = mysql_error();
if (empty($mysql_error)) {
$error_message = 'Some server error occured';
} else {
$error_message = $mysql_error;
}
$responce = array('status' => 'failed', 'error' => $error_message, 'data' => array());
}
} else {
$responce = array('status' => 'failed', 'error' => 'Data missing', 'data' => array());
}
} else {
if ($form_id == 42) {
//tax category add form
if (isset($_POST['tax_category_name']) and !empty($_POST['tax_category_name']) and isset($_POST['tax_percent']) and !empty($_POST['tax_percent'])) {
$tax_category = new tax_category();
$tax_category->tax_category_name = $_POST['tax_category_name'];
$tax_category->tax_percentage = $_POST['tax_percent'];
if ($tax_category->addTaxCategory()) {
$responce = array('status' => 'success', 'error' => '', 'data' => array('message' => 'Tax Category Added successfully'));
} else {
Log::e($tag, "Tax Category adding failed item : " . $tax_category->to_string() . 'Error : ' . mysql_error());
$mysql_error = mysql_error();
if (empty($mysql_error)) {
$error_message = 'Some server error occured';
} else {
$error_message = $mysql_error;
}
$responce = array('status' => 'failed', 'error' => $error_message, 'data' => array());
}
} else {
$user = new user();
$user->id = $_SESSION['user_id'];
$user->getUser();
$inventry = new inventry();
$inventries = $inventry->getInventryForSpecificCompany($user->company_id);
if ($inventries) {
$stock_array = array();
foreach ($inventries as $inventry) {
$item = new item();
$item->id = $inventry->item_id;
$item->getItem();
$stock_item["item_id"] = $item->id;
$stock_item["item_code"] = $item->item_code;
$stock_item["item_name"] = $item->item_name;
$stock_item["item_unit"] = $item->unit;
$tax = new tax_category();
$tax->id = $inventry->tax_category_id;
$tax->getTaxCategory();
$stock_item["tax_percentage"] = $tax->tax_percentage;
$stock_item["stock_count"] = number_format($inventry->in_stock_count, 3, '.', '');
$stock_item["selling_prize"] = number_format($inventry->selling_prize, 2, '.', '');
array_push($stock_array, $stock_item);
}
$responce = array('status' => 'success', 'error' => '', 'data' => array("stock" => $stock_array));
} else {
$responce = array('status' => 'sucess', 'error' => '', 'data' => array("stock" => array()));
}
} else {
$responce = array('status' => 'failed', 'error' => 'Invalid Form', 'data' => array());
}
}
$mysql_error = mysql_error();
if (empty($mysql_error)) {
$error_message = 'Some server error occured';
} else {
$error_message = $mysql_error;
}
$responce = array('status' => 'failed', 'error' => $error_message, 'data' => array());
}
} else {
$responce = array('status' => 'failed', 'error' => 'Data missing', 'data' => array());
}
} else {
if ($form_id == 42) {
///tax category change form
if (isset($_POST['tax_category_id']) and !empty($_POST['tax_category_id']) and isset($_POST['tax_category_name']) and !empty($_POST['tax_category_name']) and isset($_POST['tax_percent']) and !empty($_POST['tax_percent'])) {
$tax_category = new tax_category();
$tax_category->id = $_POST['tax_category_id'];
$tax_category->getTaxCategory();
$tax_category->tax_category_name = $_POST['tax_category_name'];
$tax_category->tax_percentage = $_POST['tax_percent'];
if ($tax_category->updateTaxCategory()) {
$message = "Tax Category Updated Successfuly";
$responce = array('status' => 'success', 'error' => '', 'data' => array("message" => $message, "id" => $tax_category->id));
} else {
$description = "Tax Category update failed, Stock : " . $tax_category->to_string();
Log::e($tag, $description);
$mysql_error = mysql_error();
if (empty($mysql_error)) {
$error_message = 'Some server error occured';
} else {
$error_message = $mysql_error;
function get_form_html($form_id, $date)
{
ob_start();
?>
<div id="head_div" style="padding: 5px 0; background-color: #ECECEC; color: #21ACD7;
border-radius: 5px;margin-left: auto; text-align: center; ">
DAY END REPORT OF
<input id="date_field" value="<?php
if ($date == 0) {
$date = date('d/m/Y', time());
}
echo $date;
?>
" />
</div>
<div id="sales_items_table" style="margin-top: 10px; background-color:transparent;padding-bottom: 30px;">
<style>
div#purchace_items td{
border: 1px solid #21ACD7;
}
div#purchace_items tbody td{
padding: 5px 0 5px 5px;
}
div#purchace_items tbody td input,div#purchace_items tbody td select{
padding: 0;
border: 0;
margin: 0;
height: 100%;
width: 100%;
background-color: transparent;
}
</style>
<div id="purchace_items" style="width: 100%; padding: 10px 0; color: #21ACD7;">
<font>SALES ITEMS</font>
<table id="sales_items_table" style="border-collapse: collapse; width: 100%;
background-color: #fff; border-radius: 10px; color: #21ACD7; margin-top: 5px; margin-bottom: 20px;">
<thead style="text-align: center;">
<tr>
<td style="width: 5%;">
#
</td>
<td>
ITEM
</td>
<td style="width: 15%;">
COUNT
</td>
<td style="width: 15%;">
TOTAL
</td>
</tr>
</thead>
<tbody style="padding-left: 3px; text-align: center; ">
<?php
$grand_total = 0;
$total_count = 0;
$user = new user();
$user->id = $_SESSION['user_id'];
$user->getUser();
$shop = new company();
$shop->id = $user->company_id;
$shop->getCompany();
$sale_item = new sales_items();
$date = str_replace('/', '-', $date);
$date = date('Y-m-d', strtotime($date));
$sales_items = $sale_item->getOneDaysSaleItems($user->company_id, $date);
$i = 0;
if ($sales_items == NULL || sizeof($sales_items) == 0) {
echo '<tr><td colspan="8"> No Sales Items Found </td></tr>';
} else {
foreach ($sales_items as $sales_item) {
$grand_total = $grand_total + $sales_item->total;
$total_count = $total_count + $sales_item->quantity;
?>
<tr>
<td style="text-align: center;">
<?php
echo ++$i;
?>
</td>
<?php
$item = new item();
$item->id = $sales_item->item_id;
$item->getItem();
?>
<td style="text-align: left;">
<?php
echo $item->item_name . ' ( ' . $item->item_code . ' )';
?>
</td>
<td>
<?php
echo number_format($sales_item->quantity, 3, '.', '');
?>
</td>
<td id="tax">
<?php
echo number_format($sales_item->total, 2, '.', '');
?>
</td>
</tr>
<?php
}
}
?>
<tr>
<td></td>
<td style="text-align: right;"> TOTAL </td>
<td><?php
echo number_format($total_count, 3, '.', '');
?>
</td>
<td><?php
echo number_format($grand_total, 2, '.', '');
?>
</td>
</tr>
</tbody>
</table>
<font>STATISTICS</font>
<table id="sales_statistics_table" style="border-collapse: collapse; width: 100%;
background-color: #fff; border-radius: 10px; color: #21ACD7; margin-top: 5px; margin-bottom: 20px;">
<thead style="text-align: center;">
<tr>
<td style="width: 5%;">
#
</td>
<td>
STATISTICS
</td>
<td style="width: 15%;">
COUNT
</td>
<td style="width: 15%;">
TOTAL TAX
</td>
<td style="width: 15%;">
TOTAL NET. AMOUNT
</td>
<td style="width: 15%;">
TOTAL DISCOUNT
</td>
<td style="width: 15%;">
TOTAL AMOUNT
</td>
</tr>
</thead>
<tbody style="text-align: center;">
<tr style="margin-top: 20px;">
<?php
$sale = new sales();
$vals = $sale->getOneDaysSaleStatistics($user->company_id, $date);
?>
<td>1</td>
<td style="text-align: left;">SALES</td>
<td><?php
echo $vals['count'];
?>
</td>
<td><?php
echo number_format($vals['tax_amount'], 2, '.', '');
?>
</td>
<td><?php
echo number_format($vals['net_amount'], 2, '.', '');
?>
</td>
<td><?php
echo number_format($vals['discount'], 2, '.', '');
?>
</td>
<td><?php
echo number_format($vals['amount'], 2, '.', '');
?>
</td>
</tr>
</tbody>
</table>
<font>TAX</font>
<table id="sales_statistics_table" style="border-collapse: collapse; width: 100%;
background-color: #fff; border-radius: 10px; color: #21ACD7; margin-top: 5px;">
<thead style="text-align: center;">
<tr>
<td style="width: 5%;">
#
</td>
<td>
TAX(%)
</td>
<td style="width: 20%;">
COUNT
</td>
<td style="width: 20%;">
TOTAL TAX
</td>
</tr>
</thead>
<tbody style="text-align: center;">
<?php
$total_tax = 0;
$total_count = 0;
$tax_category = new tax_category();
$tax_categories = $tax_category->getTaxCategories();
if (is_array($tax_categories) and count($tax_categories)) {
$i = 0;
foreach ($tax_categories as $tax_category) {
?>
<tr style="margin-top: 20px;">
<?php
$tax_vals = $sale->getOneDayTaxDetails($user->company_id, $date, $tax_category->id);
?>
<td><?php
echo ++$i;
?>
</td>
<td style="text-align: left; padding-left: 10px;"><?php
echo $tax_category->tax_category_name;
?>
</td>
<td><?php
echo number_format($tax_vals['count'], 0, '.', '');
?>
</td>
<td><?php
echo number_format($tax_vals['tax'], 2, '.', '');
?>
</td>
</tr>
<?php
$total_tax += $tax_vals['tax'];
$total_count += $tax_vals['count'];
}
}
?>
<tr style="margin-top: 20px;">
<td></td>
<td style="text-align: right; padding-right: 10px;">TOTAL</td>
<td><?php
echo number_format($total_count, 0, '.', '');
?>
</td>
<td><?php
echo number_format($total_tax, 2, '.', '');
?>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<script type="text/javascript">
function load_day_end_report(){
var date = $('input#date_field').val();
get_form(24,
function(html, tools) {
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
}, function(message) {
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
},
date);
}
function on_print_clicked() {
var date = $('input#date_field').val();
var header = '<font style="color:#21ACD7; font-size:24px; "><?php
echo $shop->company_name . " " . $shop->company_code;
?>
</font>'
+'<br/><font style="color:#21ACD7; font-size:20px; ">DAY END REPORT OF '+date+'</font>';
$('div#print_container_header')
.html(header);
var html = $('div#sales_items_table').html();
$('div#print_container_body').html(html);
print();
$('div#print_container_header').empty();
$('div#print_container_body').empty();
$('div#print_container_footer').empty();
}
function setup_datepicker(){
$('input#date_field').datepick({
minDate:'26/04/2015',
dateFormat:'dd/mm/yyyy',
maxDate:'0',
onSelect:function(){
load_day_end_report();
}
});
}
setup_datepicker();
</script>
<?php
$form = ob_get_clean();
return $form;
}
$mysql_error = mysql_error();
if (empty($mysql_error)) {
$error_message = 'Some server error occured';
} else {
$error_message = $mysql_error;
}
$responce = array('status' => 'failed', 'error' => $error_message, 'data' => array());
}
} else {
$responce = array('status' => 'failed', 'error' => 'Data missing', 'data' => array());
}
} else {
if ($form_id == 41) {
///tax category delete
if (isset($_POST['tax_category_id']) and !empty($_POST['tax_category_id'])) {
$tax_category = new tax_category();
$tax_category->id = $_POST['tax_category_id'];
if ($tax_category->deleteTaxCategory()) {
$message = "Tax Category deleted Successfuly";
$responce = array('status' => 'success', 'error' => '', 'data' => array("message" => $message, "id" => $tax_category->id));
} else {
$description = "Tax Category delete failed, Tax Category : " . $tax_category->to_string() . " Error : " . mysql_error();
Log::e($tag, $description);
$mysql_error = mysql_error();
if (empty($mysql_error)) {
$error_message = 'Some server error occured';
} else {
$error_message = $mysql_error;
}
$responce = array('status' => 'failed', 'error' => $error_message, 'data' => array());
}
function get_form_html($form_id, $id)
{
ob_start();
?>
<style>
.field_name{
width: 20%;
}
.field input{
width: 100%;
margin-left: 0px;
}
.field .parent{
padding: 0px 0px;
}
.field select{
width: 100%;
}
</style>
<div id="head_div" style="padding: 5px 0; background-color: #ECECEC; color: #21ACD7;
border-radius: 5px;margin-left: auto;display: none; text-align: center; ">
</div>
<div style="margin-top: 10px; background-color:transparent;padding-bottom: 30px;">
<form action="#" method="post" class="action_form" operation="add" style="width:100%;" >
<table style="width:100%;">
<tr>
<td class="field_name">
<font>ITEM NAME</font>
</td>
<td class="field">
<div class="parent">
<input type="text" id="item_name" required />
</div>
</td>
</tr>
<tr>
<td class="field_name">
<font>ITEM CODE </font>
</td>
<?php
$item = new item();
$item_code = $item->getMaxItemCode() + 1;
$item_code = sprintf('%04d', $item_code);
?>
<td class="field">
<div class="parent">
<input type="text" id="item_code" required value="<?php
echo $item_code;
?>
"/>
</div>
</td>
</tr>
<tr>
<td class="field_name">
<font>ITEM MRP </font>
</td>
<td class="field">
<div style="padding: 0px 0px;">
<input type="number" id="mrp" required step="0.01" />
</div>
</td>
</tr>
<tr>
<td class="field_name">
<font>PURCHACE RATE</font>
</td>
<td class="field">
<div class="parent">
<input type="number" id="purchace_rate" required step="0.01"/>
</div>
</td>
</tr>
<tr>
<td class="field_name">
<font>TAX CATEGORY</font>
</td>
<td class="field">
<div class="parent">
<select id="tax_category" required >
<option value=""></option>
<?php
$tax_category = new tax_category();
$tax_categories = $tax_category->getTaxCategories();
foreach ($tax_categories as $tax_category) {
echo '<option id="' . $tax_category->id . '" value="' . $tax_category->tax_percentage . '">' . $tax_category->tax_category_name . '</option>';
}
?>
</select>
</div>
</td>
</tr>
<tr>
<td class="field_name">
<font>UNIT</font>
</td>
<td class="field">
<div class="parent">
<select id="unit" required >
<option value=""></option>
<option id="1" value="1">KGM</option>
<option id="2" value="2">PCS</option>
</select>
</div>
</td>
</tr>
<tr>
<td class="field_name">
<font>DISCOUNT PERCENT</font>
</td>
<td class="field">
<div class="parent">
<input type="number" id="discount_percent" min="0" max="100" required step="0.01"/>
</div>
</td>
</tr>
<tr></tr>
<tr>
<td></td>
<td>
<div style="padding: 0px 12px;">
<div style="width: 100%; margin-left: -12px; padding: 12px;
background-color: #0d92bb; border-radius: 5px; float: left;">
<div style="width: 50%; float: right; ">
<input style="width: 100%;" type="submit" value="ADD" />
</div>
<div style="width: 50%;">
<input style="width: 100%;" type="reset" value="CANCEL" />
</div>
</div>
</div>
</td>
</tr>
</table>
</form>
</div>
<script type="text/javascript">
function setFormActionListener(){
$('form.action_form').on('submit', function(e) {
e.preventDefault();
var id = 11;
var operation = $(this).attr('operation');
if (operation == 'add') {
var data = {
form_id: id,
item_name: $('form input#item_name').val(),
item_code: $('form input#item_code').val(),
mrp: $('form input#mrp').val(),
purchace_rate: $('form input#purchace_rate').val(),
discount_percent: $('form input#discount_percent').val(),
tax_category_id: $('form select#tax_category').find('option:selected').attr('id'),
unit: $('form select#unit').val()
}
add_form_data(data, function(message) {
get_form(11,
function(html, tools) {
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
}, function(message) {
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
});
alert(message);
}, function(message) {
alert(message);
});
} else if (operation == 'update') {
var item_id = $('form.action_form').attr('item_id');
var data = {
form_id: id,
item_id: item_id,
item_name: $('form input#item_name').val(),
item_code: $('form input#item_code').val(),
mrp: $('form input#mrp').val(),
purchace_rate: $('form input#purchace_rate').val(),
discount_percent: $('form input#discount_percent').val(),
tax_category_id: $('form select#tax_category').find('option:selected').attr('id'),
unit: $('form select#unit').val()
}
update_form_data(data, function(message) {
load_items_list();
alert(message);
}, function(message) {
alert(message);
});
} else {
alert("Invalid Operation " + id + ' - ' + operation);
}
});
};
setFormActionListener();
</script>
<?php
$form = ob_get_clean();
return $form;
}
function get_form_html($form_id, $id)
{
ob_start();
?>
<style>
.field_name{
width: 20%;
}
.field input{
width: 100%;
margin-left: 0px;
}
.field .parent{
padding: 0px 0px;
}
.field select{
width: 100%;
}
</style>
<div id="head_div" style="padding: 5px 0; background-color: #ECECEC; color: #21ACD7;
border-radius: 5px;margin-left: auto;display: none; text-align: center; ">
</div>
<div style="margin-top: 10px; background-color:transparent;padding-bottom: 30px;">
<form action="#" method="post" class="action_form" operation="update" style="width:100%;" >
<table style="width:100%;">
<tr>
<td class="field_name">
<font>ITEM NAME</font>
</td>
<td class="field">
<div class="parent">
<input type="text" id="item_name" required disabled="disabled" />
</div>
</td>
</tr>
<tr>
<td class="field_name">
<font>IN STOCK COUNT</font>
</td>
<td class="field">
<div class="parent">
<input type="number" step="0.001" id="in_stock_count" required disabled="disabled" />
</div>
</td>
</tr>
<tr>
<td class="field_name">
<font>MRP</font>
</td>
<td class="field">
<div style="padding: 0px 0px;">
<input type="number" step="0.01" id="mrp" required disabled="disabled" />
</div>
</td>
</tr>
<tr>
<td class="field_name">
<font>TAX CATEGORY</font>
</td>
<td class="field">
<div class="parent">
<select id="tax_category" required disabled="disabled" >
<option value=""></option>
<?php
$tax_category = new tax_category();
$tax_categories = $tax_category->getTaxCategories();
foreach ($tax_categories as $tax_category) {
echo '<option id="' . $tax_category->id . '" value="' . $tax_category->tax_percentage . '">' . $tax_category->tax_category_name . '</option>';
}
?>
</select>
</div>
</td>
</tr>
<tr></tr>
<tr>
<td></td>
<td>
<div style="padding: 0px 12px;">
<div style="width: 100%; margin-left: -12px; padding: 12px;
background-color: #0d92bb; border-radius: 5px; float: left;">
<div style="width: 50%; float: right; ">
<input style="width: 100%;" disabled="disabled" type="submit" value="UPDATE" />
</div>
<div style="width: 50%;">
<input style="width: 100%;" disabled="disabled" type="reset" value="CANCEL" />
</div>
</div>
</div>
</td>
</tr>
</table>
</form>
</div>
<script type="text/javascript">
function setFormActionListener(){
$('form.action_form').on('submit', function(e) {
e.preventDefault();
var id = 25;
var operation = $(this).attr('operation');
if (operation == 'update') {
var inventry_id = $('form.action_form').attr('inventry_id');
var data = {
form_id: id,
inventry_id: inventry_id,
in_stock_count: $('form input#in_stock_count').val(),
mrp: $('form input#mrp').val(),
tax_category_id: $('form select#tax_category').find('option:selected').attr('id')
}
update_form_data(data, function(message) {
get_form(20,
function(html, tools) {
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
}, function(message) {
$('font#section_heading').empty();
alert(message);
});
alert(message);
}, function(message) {
alert(message);
});
} else {
alert("Invalid Operation " + id + ' - ' + operation);
}
});
};
setFormActionListener();
</script>
<?php
$form = ob_get_clean();
return $form;
}
function get_form_html($form_id, $id, $page, $limit, $adjacents)
{
ob_start();
$purchace_obj = new purchaces();
$user = new user();
$user->id = $_SESSION['user_id'];
$user->getUser();
$count = $purchace_obj->getPurchacesCount($user->company_id);
if ($page == 1) {
$start = 0;
$head_message = "LAST {$limit} PURCHACES";
} else {
$start = ($page - 1) * $limit;
$head_message = "PURCHACE {$start} TO " . ($start + $limit);
}
?>
<div id="head_div" style="padding: 10px 0; background-color: #ECECEC; color: #21ACD7;
border-radius: 5px;margin-left: auto; text-align: center;overflow-x: auto; ">
<?php
echo $head_message;
?>
</div>
<div style="margin-top: 10px; background-color:transparent;padding-bottom: 30px;">
<style>
div#purchace_items td, div#purchace_items th{
border: 1px solid #21ACD7;
}
div#purchace_items tbody td{
padding: 5px 0 5px 5px;
}
div#purchace_items tbody td input,div#purchace_items tbody td select{
padding: 0;
border: 0;
margin: 0;
height: 100%;
width: 100%;
background-color: transparent;
}
</style>
<input type="text" id="search" placeholder="Enter Search Key here..." style="width: 100%; margin-left: 0px;" onkeyup="search()" />
<style>
img#search{
position: relative;
height: 20px;
width: 20px;
float: right;
top: -29px;
right: 10px;
}
</style>
<img id="search" src="../ui/images/search.png" onclick="search()" />
<div style="padding: 10px 0; background-color: transparent;
border-radius: 5px;margin-left: auto; text-align: center;overflow-x: auto; ">
<?php
echo pagination($limit, $adjacents, $count, $page);
?>
</div>
<div id="purchace_items" style="width: 100%; padding: 10px 0; color: #21ACD7;">
<table id="items_table" style="border-collapse: collapse; width: 100%;
background-color: #fff; border-radius: 10px; color: #21ACD7;">
<thead style="text-align: center;">
<tr>
<th>
#
</th>
<th>
ID
</th>
<th>
BILL NO.
</th>
<th>
DATE
</th>
<th style="">
PURCHACED FROM
</th>
<th style="">
PURCHACED BY
</th>
<th>
AMOUNT
</th>
<th style="">
STOCKED
</th>
<th style="">
</th>
</tr>
</thead>
<tbody style="padding-left: 3px; text-align: center; ">
<?php
$purchaces = $purchace_obj->getPurchacesDESC($user->company_id, $start, $limit);
$i = $start;
if ($purchaces == NULL || sizeof($purchaces) == 0) {
echo '<tr><td colspan="8"> No Purchace Found </td></tr>';
} else {
foreach ($purchaces as $purchace) {
?>
<tr id="<?php
echo $purchace->id;
?>
" onclick="select_row(this)" status="not_selected">
<td style="text-align: center;">
<?php
echo ++$i;
?>
</td>
<td>
<?php
echo $purchace->id;
?>
</td>
<td id="bill_number" >
<?php
echo $purchace->bill_number;
?>
</td>
<?php
$date = date('d/m/Y', strtotime($purchace->created_at) + 5.5 * 60 * 60);
$time = date('h:m A', strtotime($purchace->created_at) + 5.5 * 60 * 60);
?>
<td id="date" date="<?php
echo $date;
?>
">
<?php
echo $date . ' - ' . $time;
?>
</td>
<?php
$vendor = new wendors();
$vendor->id = $purchace->wendor_id;
$vendor->getWendor();
?>
<td id="vendor" vendor_address="<?php
echo $vendor->contact_address;
?>
"><?php
echo $vendor->wendor_name;
?>
</td>
<td>
<?php
$p_manager = new user();
$p_manager->id = $purchace->purchace_manager_id;
$p_manager->getUser();
echo $p_manager->name;
?>
</td>
<td id="amount"><?php
echo $purchace->amount;
?>
</td>
<td>
<?php
if ($purchace->stocked) {
echo "YES";
} else {
echo 'NO';
}
?>
</td>
<td id="down_button" style="width: 20px;text-align: center; padding: 10px;">
<img id="toggle_button" style="width: 20px; height: 20px; cursor: pointer;"
onclick="toggle_items_visibility(this)" src="../ui/images/down_arrow.png"/>
<img id="toggle_button" style="width: 20px; height: 20px; cursor: pointer; display: none;"
onclick="toggle_items_visibility(this)" src="../ui/images/up_arrow.png"/>
</td>
</tr>
<tr id="purchace_item" style="display: none;">
<td colspan="8" style="padding:0 0 20px 0;">
<table id="purchace_items" style="border-collapse: collapse; background-color: #c0effd; width: 80%; color: #21ACD7; float: right;">
<thead>
<tr>
<th>
ITEM
</th>
<th>
QUANTITY
</th>
<th>
PURCHACE RATE
</th>
<th>
MRP
</th>
<th>
TOTAL
</th>
</tr>
</thead>
<tbody>
<?php
if (is_array($purchace->getPurchaceItems()) and count($purchace->getPurchaceItems()) > 0) {
foreach ($purchace->getPurchaceItems() as $p_item) {
?>
<tr>
<td id="item_name"><?php
$item = new item();
$item->id = $p_item->item_id;
$item->getItem();
echo $item->item_name . ' ( ' . $item->item_code . ' )';
?>
</td>
<td id="quantity"><?php
echo $p_item->quantity;
?>
</td>
<?php
$tax = new tax_category();
$tax->id = $item->tax_category_id;
$tax->getTaxCategory();
?>
<td id="rate" tax_rate="<?php
echo $tax->tax_percentage;
?>
"><?php
echo $p_item->rate;
?>
</td>
<td><?php
echo $item->mrp;
?>
</td>
<td>
<?php
echo $p_item->quantity * $p_item->rate;
?>
</td>
</tr>
<?php
}
} else {
?>
<tr><td colspan="6">No Items found !</td></tr>
<?php
}
?>
</tbody>
</table>
</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
<div style="padding: 10px 0; background-color: transparent;
border-radius: 5px;margin-left: auto; text-align: center;overflow-x: auto; ">
<?php
echo pagination($limit, $adjacents, $count, $page);
?>
</div>
</div>
<script type="text/javascript">
function toggle_items_visibility(down_button) {
var row = $(down_button).closest('tr');
row.next('tr').fadeToggle();
row.find('img#toggle_button').toggle();
}
function select_row(row) {
var j_row = $(row);
if (j_row.attr('status') == 'selected') {
$('table#items_table tr').attr('status', 'not_selected');
$('table#items_table tr').css('background-color', '#FFF');
$('img#print').css('display', 'none');
$('img#print_fade').css('display', 'block');
$('img#delete').css('display', 'none');
$('img#delete_fade').css('display', 'block');
} else {
$('table#items_table tr').attr('status', 'not_selected');
$('table#items_table tr').css('background-color', '#FFF');
j_row.attr('status', 'selected');
j_row.css('background-color', '#C0EFFD');
$('img#print').css('display', 'block');
$('img#print_fade').css('display', 'none');
$('img#delete').css('display', 'block');
$('img#delete_fade').css('display', 'none');
}
}
function on_print_clicked() {
var selected_row = $('tr[status="selected"]');
var items_table_rows = selected_row.next('tr#purchace_item').find('table#purchace_items').find('tbody').children();
var items = new Array();
var i = 0;
var tax_amount = 0;
items_table_rows.each(function() {
var item_row = $(this);
var item_name = item_row.find('td#item_name').html();
var quantity = item_row.find('td#quantity').html();
var rate = item_row.find('td#rate').html();
var tax_rate = item_row.find('td#rate').attr('tax_rate');
var total = parseFloat(rate) * parseFloat(quantity);
total = total.toFixed(2);
var tax = (total * tax_rate) / (100);
tax_amount = parseFloat(tax_amount) + parseFloat(tax);
var item = {
item_name: item_name,
quantity: quantity,
rate: rate,
tax: tax,
tax_rate: tax_rate,
total: total
}
items[i++] = item;
});
tax_amount = tax_amount.toFixed(2);
var vendor_name = selected_row.find('td#vendor').html();
var vendor_address = selected_row.find('td#vendor').attr('vendor_address');
var amount = selected_row.find('td#amount').html();
amount = parseFloat(amount).toFixed(2);
var id = selected_row.attr('id');
var grand_total = (parseFloat(amount) + parseFloat(tax_amount));
grand_total = grand_total.toFixed(2);
var rounded_grand_total = Math.round(grand_total);
rounded_grand_total = rounded_grand_total.toFixed(2);
var round_off = grand_total - rounded_grand_total;
round_off = round_off.toFixed(2);
var bill_number = selected_row.find('td#bill_number').html();
var date = selected_row.find('td#date').attr('date');
var data = {
id: id,
vendor_name: vendor_name,
vendor_address: vendor_address,
amount: amount,
date: date,
less_discount: '0.00',
tax_amount: tax_amount,
grand_total: grand_total,
rounded_grand_total: rounded_grand_total,
round_off: round_off,
bill_number: bill_number,
items: items
}
print_purchace_invoice(data);
}
function print_purchace_invoice(data) {
var html = '';
html = '<font style="font-size:30px;">ROYALE PIKNIK TRADERS LLP</font><br/>'
+ '<font>29/861, PARAYANCHERI, CALICUT - 673006</font><br/>'
+ '<font>Tin No. 32110844692 </font><br/>'
+ '<font>PURCHACE BILL</font><br/><br/>';
$('div#print_container_header').html(html);
html = '';
//var d = new Date();
//var date = d.getDate()+"/"+(parseInt(d.getMonth())+parseInt(1))+"/"+d.getFullYear();
html = html + "<div<!-- style=\"padding:10px 0;\"><table style=\"float:right;\">"
+ "<tr><td>Date</td><td>:</td><td>" + data.date + "</td></tr></table>";
html = html + "<table>"
+ "<tr><td>Bill No. </td><td>:</td><td>" + data.bill_number/*id*/ + "</td></tr>"
+ "<tr><td>Name </td><td>:</td><td>" + data.vendor_name + "</td></tr>"
+ "<tr><td></td><td>:</td><td>" + data.vendor_address + "</td></tr></table></div>";
html = html + "<div style=\"border-top:1px dashed #000; margin:10px auto 0 auto;padding:0 0 10px 0;\"><table style=\"width:100%;\"><tr style=\"border-bottom: 1px dashed #000; border-top: 1px dashed #000;\">"
+ "<td style=\"width:5%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px;\">SNo</td>"
+ "<td style=\"width:30%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px;\">COMMODITY</td>"
+ "<td style=\"width:20%; border-bottom:1px dashed #000; border-left:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:center;\">SCH/HSN NO</td>"
+ "<td style=\"width:10%; border-bottom:1px dashed #000; border-left:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:center;\">RATE OF TAX</td>"
+ "<td style=\"width:10%; border-bottom:1px dashed #000; border-left:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:center;\">UNIT PRICE</td>"
+ "<td style=\"width:10%; border-bottom:1px dashed #000; border-left:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:center;\">QTY</td>"
+ "<td style=\"width:15%; border-bottom:1px dashed #000; border-left:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:center;\">PURCHACE VALUE</td></tr>";
var i = 1;
for (var key in data.items) {
var item = data.items[key];
html = html + "<tr><td>" + i++ + "</td>"
+ "<td colspan=\"2\">" + item.item_name + "</td>"
+ "<td style=\"text-align:center;\">" + item.tax_rate + "</td>"
+ "<td style=\"text-align:center;\">" + item.rate + "</td>"
+ "<td style=\"text-align:center;\">" + item.quantity + "</td>"
//+"<td style=\"text-align:center;\">" + (parseFloat(item.total) - parseFloat(item.tax)) + "</td>"
//+"<td style=\"text-align:center;\">" + item.tax + "</td>"
+ "<td style=\"text-align:right;\">" + item.total + "</td>"
+ "</tr>";
}
html = html + "</table></div>";
html = html + "<div style=\"border-top:1px dashed #000; padding:10px 0;\"><table style=\"margin-left: auto;\">";
html = html + "<tr><td>Amount</td><td style=\"margin:0 30px;\"></td><td style=\"text-align:right;\">" + data.amount + "</td></tr>";
html = html + "<tr><td>Less Discount</td><td style=\"margin:0 30px;\"></td><td style=\"text-align:right;\">" + data.less_discount + "</td></tr>";
html = html + "<tr><td>VAT</td><td style=\"margin:0 30px;\"></td><td style=\"text-align:right;\">" + data.tax_amount + "</td></tr>";
html = html + "<tr><td>Round off</td><td style=\"margin:0 30px;\"></td><td style=\"text-align:right;\">" + data.round_off + "</td></tr>";
html = html + "<tr style=\"font-size:18px;\"><td><b>GRAND TOTAL</b></td><td style=\"margin:0 30px;\"></td><td style=\"text-align:right;\"><b>" + data.rounded_grand_total + "</b></td></tr>";
html = html + "</table></div>";
// console.log("Creating bill : " + html);
$('div#print_container_body').html(html);
html = '';
html = '<div style="width:100%;border-bottom:1px dashed #000;text-align:left;"><font>Rupees: ' + toWords(parseInt(data.rounded_grand_total)) + ' Only. </font></div>';
$('div#print_container_footer').html(html);
print();
$('div#print_container_header').empty();
$('div#print_container_body').empty();
$('div#print_container_footer').empty();
}
// American Numbering System
var th = ['', 'Thousand', 'Million', 'Billion', 'Trillion'];
var dg = ['Zero', 'One', 'Two', 'Three', 'Four', 'Five', 'Six', 'Seven', 'Eight', 'Nine'];
var tn = ['Ten', 'Eleven', 'Twelve', 'Thirteen', 'Fourteen', 'Fifteen', 'Sixteen', 'Seventeen', 'Eighteen', 'Nineteen'];
var tw = ['Twenty', 'Thirty', 'Forty', 'Fifty', 'Sixty', 'Seventy', 'Eighty', 'Ninety'];
function toWords(s) {
s = s.toString();
s = s.replace(/[\, ]/g, '');
if (s != parseFloat(s))
return 'not a number';
var x = s.indexOf('.');
if (x == -1)
x = s.length;
if (x > 15)
return 'too big';
var n = s.split('');
var str = '';
var sk = 0;
for (var i = 0; i < x; i++) {
if ((x - i) % 3 == 2) {
if (n[i] == '1') {
str += tn[Number(n[i + 1])] + ' ';
i++;
sk = 1;
} else if (n[i] != 0) {
str += tw[n[i] - 2] + ' ';
sk = 1;
}
} else if (n[i] != 0) {
str += dg[n[i]] + ' ';
if ((x - i) % 3 == 0)
str += 'hundred ';
sk = 1;
}
if ((x - i) % 3 == 1) {
if (sk)
str += th[(x - i - 1) / 3] + ' ';
sk = 0;
}
}
if (x != s.length) {
var y = s.length;
str += 'point ';
for (var i = x + 1; i < y; i++)
str += dg[n[i]] + ' ';
}
return str.replace(/\s+/g, ' ');
}
function search() {
var search_key = $('input#search').val();
if (search_key !== '') {
console.log("search key " + search_key);
searchTable(search_key);
} else {
$('#items_table tr').show();
$('#items_table tr#purchace_item').hide();
}
}
function searchTable(inputVal) {
var table = $('#items_table');
table.find('tr').each(function(index, row)
{
if ($(row).attr('id') !== 'purchace_item') {
var allCells = $(row).find('td');
if (allCells.length > 0)
{
var found = false;
allCells.each(function(index, td)
{
var regExp = new RegExp(inputVal, 'i');
if (regExp.test($(td).text()))
{
found = true;
return false;
}
});
if (found == true)
$(row).show();
else
$(row).hide();
}
var items_row = $(row).next('tr');
var allCells = items_row.find('td');
if (allCells.length > 0)
{
var found = false;
allCells.each(function(index, td)
{
var regExp = new RegExp(inputVal, 'i');
if (regExp.test($(td).text()))
{
found = true;
return false;
}
});
if (found == true) {
$(row).show();
items_row.show();
} else {
items_row.hide();
}
}
}
});
}
function on_delete_clicked() {
var selected_row = $('tr[status="selected"]');
var id = selected_row.attr('id');
if (confirm('Are you sure you want to delete PURCHACE-' + id + ' ?')) {
var data = {
form_id: 19,
purchace_id: id
}
delete_form_data(data, function(message) {
get_form(19,
function(html, tools) {
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
}, function(message) {
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
});
alert(message);
}, function(message) {
alert(message);
});
}
}
function set_pagination_listener(){
$('.pagination').on('click','.page-numbers',function(e){
e.preventDefault();
var page = $(this).attr('page');
var id = 0;
get_form(19,
function(html, tools) {
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
}, function(message) {
$('font#section_heading').empty();
alert(message);
},id
,page
);
return false;
});
}
set_pagination_listener();
</script>
<?php
$form = ob_get_clean();
return $form;
}
function get_form_html($form_id, $id)
{
ob_start();
?>
<div id="head_div" style="height: 150px;
width: 320px; background-color: #ECECEC;
border-radius: 5px;margin-left: auto;display: none; ">
</div>
<div style="margin-top: 10px; background-color:transparent;padding-bottom: 30px;">
<style>
div#purchace_items td{
border: 1px solid #21ACD7;
}
div#purchace_items tbody td{
padding: 5px 0 5px 5px;
}
div#purchace_items tbody td input,div#purchace_items tbody td select{
padding: 0;
border: 0;
margin: 0;
height: 100%;
width: 100%;
background-color: transparent;
}
</style>
<div id="purchace_items" style="width: 100%; padding: 10px 0; color: #21ACD7;">
<table id="items_table" style="border-collapse: collapse; width: 100%;
background-color: #fff; border-radius: 10px; color: #21ACD7;">
<thead style="text-align: center;">
<tr status="not_selected">
<td>
#
</td>
<td>
ID
</td>
<td>
TAX CATEGORY NAME
</td>
<td style="">
TAX(%)
</td>
</tr>
</thead>
<tbody style="padding-left: 3px; text-align: center; ">
<?php
$tax_category = new tax_category();
$tax_categories = $tax_category->getTaxCategories();
$i = 0;
if (is_array($tax_categories) and count($tax_categories)) {
foreach ($tax_categories as $tax_category) {
?>
<tr id="<?php
echo $tax_category->id;
?>
" onclick="select_row(this)">
<td style="text-align: center;"><?php
echo ++$i;
?>
</td>
<td id="tax_category_id"><?php
echo 'TAX-' . $tax_category->id;
?>
</td>
<td id="tax_category_name"><?php
echo $tax_category->tax_category_name;
?>
</td>
<td id="tax_category_value"><?php
echo $tax_category->tax_percentage;
?>
</td>
</tr>
<?php
}
} else {
echo '<tr><td colspan="8"> No Tax Category Found </td></tr>';
}
?>
</tbody>
</table>
</div>
</div>
<script type="text/javascript">
function select_row(row) {
var j_row = $(row);
if(j_row.attr('status') == 'selected'){
$('table#items_table tr').attr('status', 'not_selected');
$('table#items_table tr').css('background-color', '#FFF');
$('img#edit').css('display', 'none');
$('img#edit_fade').css('display', 'block');
$('img#delete').css('display', 'none');
$('img#delete_fade').css('display', 'block');
}else{
$('table#items_table tr').attr('status', 'not_selected');
$('table#items_table tr').css('background-color', '#FFF');
j_row.attr('status', 'selected');
j_row.css('background-color', '#C0EFFD');
$('img#edit').css('display', 'block');
$('img#edit_fade').css('display', 'none');
$('img#delete').css('display', 'block');
$('img#delete_fade').css('display', 'none');
}
}
function on_edit_clicked(){
var selected_row = $('tr[status="selected"]');
var id = selected_row.attr('id');
get_form(42, ///tax category create form
function (html, tools){
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
var form = $('div#form-body').find('form.action_form');
form.attr('operation', 'update');
form.attr('tax_category_id', id);
form.find('input[type=submit]').val('UPDATE');
$('div#head_div').html('ID : TAX CATEGORY - '+id);
$('div#head_div').css('display', 'block');
},
function (message){
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
},
id
);
}
function on_add_clicked(){
get_form(42, ///tax category create form
function (html, tools){
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
},
function (message){
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
}
);
}
function on_delete_clicked(){
var selected_row = $('tr[status="selected"]');
var id = selected_row.attr('id');
if(confirm('Are you sure you want to delete TAX-'+id+' ?' )){
var data = {
form_id : 41,
tax_category_id : id
}
delete_form_data(data, function(message) {
get_form(41,
function(html, tools) {
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
}, function(message) {
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
});
alert(message);
}, function(message) {
alert(message);
});
}
}
</script>
<?php
$form = ob_get_clean();
return $form;
}
function get_form_html($form_id, $id, $page, $limit, $adjacents)
{
ob_start();
$sale_obj = new sales();
$user = new user();
$user->id = $_SESSION['user_id'];
$user->getUser();
$count = $sale_obj->getLastThreeDaysSalesCount($user->company_id);
if ($page == 1) {
$start = 0;
$head_message = "LAST {$limit} SALES OF LAST 3 DAYS";
} else {
$start = ($page - 1) * $limit;
$head_message = "SALES {$start} TO " . ($start + $limit) . " SALES OF LAST 3 DAYS";
}
?>
<div id="head_div" style="padding: 5px 0; background-color: #ECECEC; color: #21ACD7;
border-radius: 5px;margin-left: auto; text-align: center; ">
<?php
echo $head_message;
?>
</div>
<div style="margin-top: 10px; background-color:transparent;padding-bottom: 30px;">
<style>
div#purchace_items td,div#purchace_items th{
border: 1px solid #21ACD7;
}
div#purchace_items tbody td{
padding: 5px 0 5px 5px;
}
div#purchace_items tbody td input,div#purchace_items tbody td select{
padding: 0;
border: 0;
margin: 0;
height: 100%;
width: 100%;
background-color: transparent;
}
</style>
<input type="text" id="search" placeholder="Enter Search Key here..." style="width: 100%; margin-left: 0px;" onkeyup="search()" />
<style>
img#search{
position: relative;
height: 20px;
width: 20px;
float: right;
top: -29px;
right: 10px;
}
</style>
<img id="search" src="../ui/images/search.png" onclick="search()" />
<div style="padding: 10px 0; background-color: transparent;
border-radius: 5px;margin-left: auto; text-align: center;overflow-x: auto; ">
<?php
echo pagination($limit, $adjacents, $count, $page);
?>
</div>
<div id="purchace_items" style="width: 100%; padding: 10px 0; color: #21ACD7;">
<table id="items_table" style="border-collapse: collapse; width: 100%;
background-color: #fff; border-radius: 10px; color: #21ACD7;">
<thead style="text-align: center;">
<tr status="not_selected" >
<th>
#
</th>
<th>
ID
</th>
<th>
DATE & TIME
</th>
<th>
CUSTOMER
</th>
<th style="">
DISCOUNT
</th>
<th style="">
TAX
</th>
<th style="">
NET. AMOUNT
</th>
<th style="">
TOTAL
</th>
<th style="">
</th>
</tr>
</thead>
<tbody style="padding-left: 3px; text-align: center; ">
<?php
$sales = $sale_obj->getLastThreeDaysSales($user->company_id, $start, $limit);
$i = $start;
if ($sales == NULL || sizeof($sales) == 0) {
echo '<tr><td colspan="8"> No Sales Found </td></tr>';
} else {
foreach ($sales as $sale) {
?>
<tr id="<?php
echo $sale->id;
?>
" onclick="select_row(this)" status="not_selected" >
<td style="text-align: center;">
<?php
echo ++$i;
?>
</td>
<td>
<?php
echo $sale->id;
?>
</td>
<?php
$date = date('d/m/Y', strtotime($sale->sale_at) + 5.5 * 60 * 60);
$time = date('h:m A', strtotime($sale->sale_at) + 5.5 * 60 * 60);
?>
<td id="date" date="<?php
echo $date;
?>
" time="<?php
echo $time;
?>
">
<?php
echo $date . ' - ' . $time;
?>
</td>
<?php
$customer = new customer();
$customer->id = $sale->customer_id;
$customer->getCustomer();
?>
<td id="customer" c_name="<?php
echo $customer->customer_name;
?>
" c_id="<?php
echo $customer->id;
?>
" >
<?php
echo $customer->customer_name . ' ( ID : ' . $customer->id . ' )';
?>
</td>
<td id="discount">
<?php
echo number_format($sale->discount, 2, '.', '');
?>
</td>
<td id="tax">
<?php
echo number_format($sale->tax_amount, 2, '.', '');
?>
</td>
<td id="net_amount">
<?php
echo number_format($sale->net_amount, 2, '.', '');
?>
</td>
<td id="total">
<?php
echo number_format($sale->amount, 2, '.', '');
?>
</td>
<td id="down_button" style="width: 20px;text-align: center; padding: 10px;">
<img id="toggle_button" style="width: 20px; height: 20px; cursor: pointer;"
onclick="toggle_items_visibility(this)" src="../ui/images/down_arrow.png"/>
<img id="toggle_button" style="width: 20px; height: 20px; cursor: pointer; display: none;"
onclick="toggle_items_visibility(this)" src="../ui/images/up_arrow.png"/>
</td>
</tr>
<tr style="display: none;" id="sale_items">
<td colspan="8" style="padding:0 0 20px 0;">
<table id="sale_items" style="border-collapse: collapse; background-color: #c0effd; width: 80%; color: #21ACD7; float: right;">
<thead>
<tr>
<th>
ITEM
</th>
<th>
QUANTITY
</th>
<th>
RATE
</th>
<th>
NET. AMOUNT
</th>
<th>
DISCOUNT
</th>
<th>
TAX
</th>
<th>
TOTAL
</th>
</tr>
</thead>
<tbody>
<?php
if (is_array($sale->getSalesItems()) and count($sale->getSalesItems())) {
foreach ($sale->getSalesItems() as $s_item) {
?>
<tr id="<?php
echo $s_item->id;
?>
">
<?php
$item = new item();
$item->id = $s_item->item_id;
$item->getItem();
?>
<td id="item"
item_name="<?php
echo $item->item_name . ' - ' . $item->item_code;
?>
"
item_id="<?php
echo $item->id;
?>
">
<?php
echo $item->item_name . ' - ' . $item->item_code;
?>
</td>
<td id="quantity" val="<?php
echo $s_item->quantity;
?>
">
<?php
echo number_format($s_item->quantity, 3, '.', '');
?>
</td>
<td id="rate" val="<?php
echo $s_item->rate;
?>
">
<?php
echo number_format($s_item->rate, 2, '.', '');
?>
</td>
<?php
$tax_category = new tax_category();
$tax_category->id = $item->tax_category_id;
$tax_category->getTaxCategory();
$total = $s_item->quantity * $s_item->rate;
if ($total == 0) {
$discount_percent = 0;
} else {
$discount_percent = $s_item->discount * 100 / $total;
}
$total = $total - $s_item->discount;
?>
<td>
<?php
echo number_format($total - $s_item->tax, 2, '.', '');
?>
</td>
<td id="discount" val="<?php
echo $s_item->discount;
?>
" discount_percent="<?php
echo $discount_percent;
?>
">
<?php
echo number_format($s_item->discount, 2, '.', '');
?>
</td>
<td id="tax" val="<?php
echo $s_item->tax;
?>
" tax_rate="<?php
echo $tax_category->tax_percentage;
?>
">
<?php
echo number_format($s_item->tax, 2, '.', '');
?>
</td>
<td id="total" val="<?php
echo $total;
?>
">
<?php
echo number_format($total, 2, '.', '');
?>
</td>
</tr>
<?php
}
} else {
echo '<tr><td colspan="7">No item found</td></tr>';
}
?>
</tbody>
</table>
</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
<div style="padding: 10px 0; background-color: transparent;
border-radius: 5px;margin-left: auto; text-align: center;overflow-x: auto; ">
<?php
echo pagination($limit, $adjacents, $count, $page);
?>
</div>
</div>
<script type="text/javascript">
function on_edit_clicked(){
var selected_row = $('tr[status="selected"]');
var sale_items_table = selected_row.next('tr').find('table#sale_items');
var sale_items = sale_items_table.find('tbody').children();
var items = new Array();
var i = 0;
sale_items.each(function() {
var item_name = $(this).find('td#item').attr('item_name');
var item_id = $(this).find('td#item').attr('item_id');
var id = $(this).attr('id');
var quantity = $(this).find('td#quantity').attr('val');
quantity = parseFloat(quantity).toFixed(3);
var rate = $(this).find('td#rate').attr('val');
rate = parseFloat(rate).toFixed(2);
var tax = $(this).find('td#tax').attr('val');
var tax_rate = $(this).find('td#tax').attr('tax_rate');
var discount = $(this).find('td#discount').attr('val');
var discount_percent = $(this).find('td#discount').attr('discount_percent');
var total = $(this).find('td#total').attr('val');
var item = {
id: id,
quantity: quantity,
rate: rate,
item_name: item_name,
item_id: item_id,
total: total,
discount:discount,
discount_percent:discount_percent,
tax_rate: tax_rate,
tax: tax
}
items[i++] = item;
});
var c_name = selected_row.find('td#customer').attr('c_name');
var c_id = selected_row.find('td#customer').attr('c_id');
var sale_id = selected_row.attr('id');
var total = selected_row.find('td#total').html();
total = parseFloat(total).toFixed(2);
var total_tax = selected_row.find('td#tax').html();
var total_discount = selected_row.find('td#discount').html();
var date = selected_row.find('td#date').attr('date');
var time = selected_row.find('td#date').attr('time');
var net_total = selected_row.find('td#net_amount').html();
get_form(2, ///sales return invoice
function (html, tools){
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
$('input#sale_id').val(sale_id);
var form = $('div#form-body').find('form.action_form');
form.attr('operation', 'update');
form.find('input#customer_id').val(c_name+' ( ID : '+c_id+' )');
form.find('input#customer_id').attr('disabled', 'true');
form.find('input#date_and_time').val(date + ' - ' + time);
form.find('input#date_and_time').attr('date', date);
form.find('input#date_and_time').attr('time', time);
$('table#items_table tbody').empty();
for(var i = 0; i<items.length; i++){
add_sale_item();
var row = $('table#items_table tbody tr:last-child');
var item = items[i];
row.find('input#item').attr('disabled', 'disabled');
row.find('input#item').val(item.item_name);
row.find('input#item').attr('item_id', item.item_id);
row.find('input#quantity').val(item.quantity);
row.find('input#quantity').attr('max', item.quantity);
row.find('input#rate').val(item.rate);
row.find('input#rate').attr('tax', item.tax_rate);
row.find('input#discount_percent').val(item.discount_percent);
row.find('input#total').val(item.total);
row.find('input#total').attr('tax', item.tax);
row.find('input#total').attr('discount', item.discount);
row.find('input#discount').val(item.discount);
row.attr('previous', true);
}
form.find('span#total').html(total);
form.find('span#total').attr('tax', total_tax);
form.find('span#total').attr('discount', total_discount);
form.find('span#total_paid').html(total);
form.find('span#balance').html('0.00');
form.attr('sale_id', sale_id);
form.attr('customer_name', c_name);
form.attr('customer_id', c_id);
},
function (message){
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
}
);
}
function on_print_clicked() {
var selected_row = $('tr[status="selected"]');
var sale_items_table = selected_row.next('tr').find('table#sale_items');
var sale_items = sale_items_table.find('tbody').children();
var items = new Array();
var i = 0;
sale_items.each(function() {
var item_name = $(this).find('td#item').attr('item_name');
var id = $(this).attr('id');
var quantity = $(this).find('td#quantity').attr('val');
var rate = $(this).find('td#rate').attr('val');
var tax = $(this).find('td#tax').attr('val');
var tax_rate = $(this).find('td#tax').attr('tax_rate');
var discount = $(this).find('td#discount').attr('val');
var total = $(this).find('td#total').attr('val');
total = parseFloat(total);
total = total.toFixed(2);
var item = {
id: id,
quantity: quantity,
rate: rate,
item_name: item_name,
total: total,
discount:discount,
tax: tax,
tax_rate: tax_rate
}
items[i++] = item;
});
var c_name = selected_row.find('td#customer').attr('c_name');
var c_id = selected_row.find('td#customer').attr('c_id');
if(c_id == 0){
c_name = 'Not Regd.';
}
var sale_id = selected_row.attr('id');
var total = selected_row.find('td#total').html();
total = parseFloat(total);
total = total.toFixed(2);
var total_tax = selected_row.find('td#tax').html();
total_tax = parseFloat(total_tax);
total_tax = total_tax.toFixed(2);
var total_discount = selected_row.find('td#discount').html();
total_discount = parseFloat(total_discount);
total_discount = total_discount.toFixed(2);
var net_total = selected_row.find('td#net_amount').html();
net_total = parseFloat(net_total);
net_total = net_total.toFixed(2);
var date = selected_row.find('td#date').attr('date');
var time = selected_row.find('td#date').attr('time');
var data = {
customer_id: c_id,
total: total,
net_amount: net_total,
tax_amount: total_tax,
discount:total_discount,
items: items,
date: date,
time: time
}
print_bill(data, c_name, sale_id);
}
function print_bill(data, customer_name, sale_id) {
var html = '';
html ='<img id="logo_bill" src="images/nutiez.png"/><br/><font id="print_container_header_company_adderss">Royal Piknik Traders LLP, 29/861</font>'
+'<br/><font id="print_container_header_company_adderss">Parayancheri, Calicut</font><br/><font id="print_container_header_company_adderss">'
+'Phone : 0495 2741095,+91 9388627725</font><br/><font id="print_container_header_company_adderss">The kerala value added tax rules 2005/ form no. 8</font>'
+'<br/><font id="print_container_header_company_adderss">Tin : 32110844692</font>'
+'<br/><font id="print_container_header_company_adderss">True Copy</font>';
$('div#print_container_header').html(html);
html = '';
html = html + "<div<!-- style=\"padding:10px 0;\"><table style=\"float:right; font-size: 12px;\">"
+"<tr><td>Date</td><td>:</td><td style=\"text-align:right;\">" + data.date + "</td></tr>"
+"<tr><td>Time</td><td>:</td><td style=\"text-align:right;\">" + data.time + "</td></tr></table>";
html = html + "<table style=\"font-size: 12px;\">"
+"<tr><td>Bill No.</td><td>:</td><td>" + sale_id + "</td></tr>"
+"<tr><td>Cust. ID</td><td>:</td><td>" + data.customer_id + "</td></tr>"
+"<tr><td>Cust. Name</td><td>:</td><td>" + customer_name + "</td></tr></table></div>";
html = html + "<div style=\"border-top:1px dashed #000; margin:10px auto 0 auto;padding:0 0 10px 0;\">"
+ "<table style=\"width:100%;font-size: 12px;\"><tr style=\"border-bottom: 1px solid #000; border-top: 1px solid #000;\">"
+ "<td style=\"width:44%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px;\">Description</td>"
+ "<td style=\"width:14%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:right;\">Qty</td>"
+ "<td style=\"width:14%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:right;\">Rate</td>"
// + "<td style=\"width:15%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:right;\">Amount</td>"
// + "<td style=\"width:10%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:right;\">Tax</td>"
+ "<td style=\"width:14%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:right;\">Tax(%)</td>"
+ "<td style=\"width:14%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:right;\">Total</td></tr>";
var i = 0;
for (var key in data.items) {
var item = data.items[key];
html = html + "<tr><td>" + item.item_name + "</td>"
+"<td style=\"text-align:right;\">" + parseFloat(item.quantity).toFixed(3) + "</td>"
+"<td style=\"text-align:right;\">" + parseFloat(item.rate).toFixed(2) + "</td>"
//+"<td style=\"text-align:right;\">" + (parseFloat(item.total) - parseFloat(item.tax)) + "</td>"
// +"<td style=\"text-align:right;\">" + item.tax + "</td>"
+"<td style=\"text-align:right;\">" + item.tax_rate + "</td>"
+"<td style=\"text-align:right;\">" + parseFloat(item.total).toFixed(2) + "</td>"
+"</tr>";
}
html = html + "</table></div>";
html = html + "<div style=\"border-top:1px dashed #000; padding:10px 0;\"><table style=\"margin-left: auto;font-size: 12px;\">";
html = html + "<tr><td>Net. Amount</td><td style=\"margin:0 15;\">:</td><td style=\"text-align:right;\">" + data.net_amount + "</td></tr>";
if(parseFloat(data.discount) > 0 ){
html = html + "<tr><td>Discount</td><td style=\"margin:0 15;\">:</td><td style=\"text-align:right;\">" + data.discount + "</td></tr>";
}
html = html + "<tr><td>Tax</td><td style=\"margin:0 15;\">:</td><td style=\"text-align:right;\">" + data.tax_amount + "</td></tr>";
html = html + "<tr style=\"font-size:18px;\"><td><b>Total</b></td><td style=\"margin:0 15;\">:</td><td style=\"text-align:right;\"><b>" + data.total + "</b></td></tr>";
html = html + "</table></div>";
// console.log("Creating bill : " + html);
$('div#print_container_body').html(html);
html = '';
html = '<font>Thank you for shoping</font><br/><font>Visit again...</font> ';
$('div#print_container_footer').html(html);
print();
$('div#print_container_header').empty();
$('div#print_container_body').empty();
$('div#print_container_footer').empty();
}
function select_row(row) {
var j_row = $(row);
if(j_row.attr('status') == 'selected'){
$('table#items_table tr').attr('status', 'not_selected');
$('table#items_table tr').css('background-color', '#FFF');
$('img#edit').css('display', 'none');
$('img#edit_fade').css('display', 'block');
$('img#print').css('display', 'none');
$('img#print_fade').css('display', 'block');
}else{
$('table#items_table tr').attr('status', 'not_selected');
$('table#items_table tr').css('background-color', '#FFF');
j_row.attr('status', 'selected');
j_row.css('background-color', '#C0EFFD');
$('img#edit').css('display', 'block');
$('img#edit_fade').css('display', 'none');
$('img#print').css('display', 'block');
$('img#print_fade').css('display', 'none');
}
}
function toggle_items_visibility(down_button) {
var row = $(down_button).closest('tr');
row.next('tr').fadeToggle();
row.find('img#toggle_button').toggle();
}
function search(){
var search_key = $('input#search').val();
if(search_key !== ''){
console.log("search key "+ search_key);
searchTable(search_key);
}else{
$('#items_table tr').show();
$('#items_table tr#sale_items').hide();
}
}
function searchTable(inputVal)
{
var table = $('#items_table');
table.find('tr').each(function(index, row)
{
if($(row).attr('id')!=='sale_items'){
var allCells = $(row).find('td');
if(allCells.length > 0)
{
var found = false;
allCells.each(function(index, td)
{
var regExp = new RegExp(inputVal, 'i');
if(regExp.test($(td).text()))
{
found = true;
return false;
}
});
if(found == true)$(row).show();else $(row).hide();
}
var items_row = $(row).next('tr');
var allCells = items_row.find('td');
if(allCells.length > 0)
{
var found = false;
allCells.each(function(index, td)
{
var regExp = new RegExp(inputVal, 'i');
if(regExp.test($(td).text()))
{
found = true;
return false;
}
});
if(found == true){
$(row).show();
items_row.show();
}else{
items_row.hide();
}
}
}
});
}
function set_pagination_listener(){
$('.pagination').on('click','.page-numbers',function(e){
e.preventDefault();
var page = $(this).attr('page');
var id = 0;
get_form(3,
function(html, tools) {
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
}, function(message) {
$('font#section_heading').empty();
alert(message);
},id
,page
);
return false;
});
}
set_pagination_listener();
</script>
<?php
$form = ob_get_clean();
return $form;
}
function get_form_html($form_id, $date)
{
ob_start();
?>
<div id="head_div" style="padding: 5px 0; background-color: #ECECEC; color: #21ACD7;
border-radius: 5px;margin-left: auto; text-align: center; ">
SALES REPORT OF
<input id="date_field" value="<?php
if ($date == 0) {
$date = date('d/m/Y', time());
}
echo $date;
?>
" />
</div>
<div style="margin-top: 10px; background-color:transparent;padding-bottom: 30px;">
<style>
div#purchace_items td{
border: 1px solid #21ACD7;
}
div#purchace_items tbody td{
padding: 5px 0 5px 5px;
}
div#purchace_items tbody td input,div#purchace_items tbody td select{
padding: 0;
border: 0;
margin: 0;
height: 100%;
width: 100%;
background-color: transparent;
}
</style>
<div id="purchace_items" style="width: 100%; padding: 10px 0; color: #21ACD7;">
<table id="items_table" style="border-collapse: collapse; width: 100%;
background-color: #fff; border-radius: 10px; color: #21ACD7;">
<thead style="text-align: center;">
<tr>
<td>
#
</td>
<td>
ID
</td>
<td>
DATE & TIME
</td>
<td>
CUSTOMER
</td>
<td style="">
TAX
</td>
<td style="">
NET. AMOUNT
</td>
<td style="">
TOTAL
</td>
<td style="">
</td>
</tr>
</thead>
<tbody style="padding-left: 3px; text-align: center; ">
<?php
$sale_obj = new sales();
$user = new user();
$user->id = $_SESSION['user_id'];
$user->getUser();
$date = str_replace('/', '-', $date);
$date = date('Y-m-d', strtotime($date));
$sales = $sale_obj->getSalesOfADay($user->company_id, $date);
$i = 0;
if (is_array($sales) and count($sales) != 0) {
foreach ($sales as $sale) {
?>
<tr id="<?php
echo $sale->id;
?>
" onclick="select_row(this)" status="not_selected" >
<td style="text-align: center;">
<?php
echo ++$i;
?>
</td>
<td>
<?php
echo $sale->id;
?>
</td>
<?php
$date = date('d/m/Y', strtotime($sale->sale_at) + 5.5 * 60 * 60);
$time = date('h:m A', strtotime($sale->sale_at) + 5.5 * 60 * 60);
?>
<td id="date" date="<?php
echo $date;
?>
" time="<?php
echo $time;
?>
">
<?php
echo $date . ' - ' . $time;
?>
</td>
<?php
$customer = new customer();
$customer->id = $sale->customer_id;
$customer->getCustomer();
?>
<td id="customer" c_name="<?php
echo $customer->customer_name;
?>
" c_id="<?php
echo $customer->id;
?>
" >
<?php
echo $customer->customer_name . ' ( ID : ' . $customer->id . ' )';
?>
</td>
<td id="tax">
<?php
echo $sale->tax_amount;
?>
</td>
<td id="net_amount">
<?php
echo $sale->net_amount;
?>
</td>
<td id="total">
<?php
echo $sale->amount;
?>
</td>
<td id="down_button" style="width: 20px;text-align: center; padding: 10px;">
<img id="toggle_button" style="width: 20px; height: 20px; cursor: pointer;"
onclick="toggle_items_visibility(this)" src="../ui/images/down_arrow.png"/>
<img id="toggle_button" style="width: 20px; height: 20px; cursor: pointer; display: none;"
onclick="toggle_items_visibility(this)" src="../ui/images/up_arrow.png"/>
</td>
</tr>
<tr style="display: none;">
<td colspan="8" style="padding:0 0 20px 0;">
<table id="sale_items" style="border-collapse: collapse; background-color: #c0effd; width: 80%; color: #21ACD7; float: right;">
<thead>
<tr>
<td>
ITEM
</td>
<td>
QUANTITY
</td>
<td>
RATE
</td>
<td>
NET. AMOUNT
</td>
<td>
TAX
</td>
<td>
TOTAL
</td>
</tr>
</thead>
<tbody>
<?php
if (is_array($sale->getSalesItems()) and count($sale->getSalesItems())) {
foreach ($sale->getSalesItems() as $s_item) {
?>
<tr id="<?php
echo $s_item->id;
?>
">
<?php
$item = new item();
$item->id = $s_item->item_id;
$item->getItem();
?>
<td id="item" item_name="<?php
echo $item->item_name;
?>
"><?php
echo $item->item_name . ' - ' . $item->item_code;
?>
</td>
<td id="quantity" val="<?php
echo $s_item->quantity;
?>
">
<?php
echo number_format($s_item->quantity, 3, '.', '');
?>
</td>
<td id="rate" val="<?php
echo $s_item->rate;
?>
">
<?php
echo number_format($s_item->rate, 2, '.', '');
?>
</td>
<td>
<?php
echo number_format($s_item->quantity * $s_item->rate - $s_item->tax, 2, '.', '');
?>
</td>
<?php
$tax_category = new tax_category();
$tax_category->id = $item->tax_category_id;
$tax_category->getTaxCategory();
?>
<td id="tax" val="<?php
echo $s_item->tax;
?>
" tax_rate="<?php
echo $tax_category->tax_percentage;
?>
">
<?php
echo number_format($s_item->tax, 2, '.', '');
?>
</td>
<td id="total" val="<?php
echo $s_item->quantity * $s_item->rate;
?>
">
<?php
echo number_format($s_item->quantity * $s_item->rate, 2, '.', '');
?>
</td>
</tr>
<?php
}
} else {
echo '<tr><td colspan="6">No item found</td></tr>';
}
?>
</tbody>
</table>
</td>
</tr>
<?php
}
} else {
echo '<tr><td colspan="8"> No Sales Found </td></tr>';
}
?>
</tbody>
</table>
</div>
</div>
<script type="text/javascript">
function load_sales_report(){
var date = $('input#date_field').val();
get_form(15,
function(html, tools) {
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
}, function(message) {
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
},
date);
}
function toggle_items_visibility(down_button) {
var row = $(down_button).closest('tr');
row.next('tr').fadeToggle();
row.find('img#toggle_button').toggle();
}
function on_print_clicked() {
var selected_row = $('tr[status="selected"]');
var sale_items_table = selected_row.next('tr').find('table#sale_items');
var sale_items = sale_items_table.find('tbody').children();
var items = new Array();
var i = 0;
sale_items.each(function() {
var item_name = $(this).find('td#item').attr('item_name');
var id = $(this).attr('id');
var quantity = $(this).find('td#quantity').attr('val');
var rate = $(this).find('td#rate').attr('val');
var tax = $(this).find('td#tax').attr('val');
var total = $(this).find('td#total').attr('val');
total = parseFloat(total);
total = total.toFixed(2);
var item = {
id: id,
quantity: quantity,
rate: rate,
item_name: item_name,
total: total,
tax: tax
}
items[i++] = item;
});
var c_name = selected_row.find('td#customer').attr('c_name');
var c_id = selected_row.find('td#customer').attr('c_id');
if(c_id == 0){
c_name = 'Not Regd.';
}
var sale_id = selected_row.attr('id');
var total = selected_row.find('td#total').html();
total = parseFloat(total);
total = total.toFixed(2);
var total_tax = selected_row.find('td#tax').html();
total_tax = parseFloat(total_tax);
total_tax = total_tax.toFixed(2);
var net_total = selected_row.find('td#net_amount').html();
net_total = parseFloat(net_total);
net_total = net_total.toFixed(2);
var date = selected_row.find('td#date').attr('date');
var time = selected_row.find('td#date').attr('time');
var data = {
customer_id: c_id,
total: total,
net_amount: net_total,
tax_amount: total_tax,
items: items,
date: date,
time: time
}
print_bill(data, c_name, sale_id);
}
function print_bill(data, customer_name, sale_id) {
var html = '';
html ='<img id="logo_bill" src="images/nutiez.png"/><br/><font id="print_container_header_company_adderss">Royal Piknik Traders LLP, 29/861</font>'
+'<br/><font id="print_container_header_company_adderss">Parayancheri, Calicut</font><br/><font id="print_container_header_company_adderss">'
+'Phone : 0495 2741095,+91 9388627725</font><br/><font id="print_container_header_company_adderss">The kerala value added tax rules 2005/ form no. 8</font>'
+'<br/><font id="print_container_header_company_adderss">Tin : 32110844692</font>'
+'<br/><font id="print_container_header_company_adderss">True Copy</font>';
$('div#print_container_header').html(html);
html = '';
html = html + "<div<!-- style=\"padding:10px 0;\"><table style=\"float:right;font-size: 12px;\">"
+"<tr><td>Date</td><td>:</td><td style=\"text-align:right;\">" + data.date + "</td></tr>"
+"<tr><td>Time</td><td>:</td><td style=\"text-align:right;\">" + data.time + "</td></tr></table>";
html = html + "<table style=\"font-size: 12px;\">"
+"<tr><td>Bill No.</td><td>:</td><td>" + sale_id + "</td></tr>"
+"<tr><td>Cust. ID</td><td>:</td><td>" + data.customer_id + "</td></tr>"
+"<tr><td>Cust. Name</td><td>:</td><td>" + customer_name + "</td></tr></table></div>";
html = html + "<div style=\"border-top:1px dashed #000; margin:10px auto 0 auto;padding:0 0 10px 0;\">"
+ "<table style=\"width:100%;font-size: 12px;\"><tr style=\"border-bottom: 1px solid #000; border-top: 1px solid #000;\">"
+ "<td style=\"width:45%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px;\">Description</td>"
+ "<td style=\"width:17%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:right;\">Qty</td>"
+ "<td style=\"width:17%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:right;\">Rate</td>"
// + "<td style=\"width:15%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:right;\">Amount</td>"
// + "<td style=\"width:10%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:right;\">Tax</td>"
+ "<td style=\"width:21%; border-bottom:1px dashed #000; padding-bottom:5px; margin-bottom:5px; text-align:right;\">Total</td></tr>";
var i = 0;
for (var key in data.items) {
var item = data.items[key];
html = html + "<tr><td>" + item.item_name + "</td>"
+"<td style=\"text-align:right;\">" + parseFloat(item.quantity).toFixed(3) + "</td>"
+"<td style=\"text-align:right;\">" + parseFloat(item.rate).toFixed(2) + "</td>"
//+"<td style=\"text-align:right;\">" + (parseFloat(item.total) - parseFloat(item.tax)) + "</td>"
// +"<td style=\"text-align:right;\">" + item.tax + "</td>"
+"<td style=\"text-align:right;\">" + parseFloat(item.total).toFixed(2) + "</td>"
+"</tr>";
}
html = html + "</table></div>";
html = html + "<div style=\"border-top:1px dashed #000; padding:10px 0;\"><table style=\"margin-left: auto;font-size: 12px;\">";
html = html + "<tr><td>Net. Amount</td><td style=\"margin:0 15;\">:</td><td style=\"text-align:right;\">" + data.net_amount + "</td></tr>";
html = html + "<tr><td>Tax</td><td style=\"margin:0 15;\">:</td><td style=\"text-align:right;\">" + data.tax_amount + "</td></tr>";
html = html + "<tr style=\"font-size:18px;\"><td><b>Total</b></td><td style=\"margin:0 15;\">:</td><td style=\"text-align:right;\"><b>" + data.total + "</b></td></tr>";
html = html + "</table></div>";
// console.log("Creating bill : " + html);
$('div#print_container_body').html(html);
html = '';
html = '<font>Thank you for shoping</font><br/><font>Visit again...</font> ';
$('div#print_container_footer').html(html);
print();
$('div#print_container_header').empty();
$('div#print_container_body').empty();
$('div#print_container_footer').empty();
}
function select_row(row) {
var j_row = $(row);
if(j_row.attr('status') == 'selected'){
$('table#items_table tr').attr('status', 'not_selected');
$('table#items_table tr').css('background-color', '#FFF');
$('img#edit').css('display', 'none');
$('img#edit_fade').css('display', 'block');
$('img#print').css('display', 'none');
$('img#print_fade').css('display', 'block');
}else{
$('table#items_table tr').attr('status', 'not_selected');
$('table#items_table tr').css('background-color', '#FFF');
j_row.attr('status', 'selected');
j_row.css('background-color', '#C0EFFD');
$('img#edit').css('display', 'block');
$('img#edit_fade').css('display', 'none');
$('img#print').css('display', 'block');
$('img#print_fade').css('display', 'none');
}
}
function setup_datepicker(){
$('input#date_field').datepick({
minDate:'26/04/2015',
dateFormat:'dd/mm/yyyy',
maxDate:'0',
onSelect:function(){
load_sales_report();
}
});
}
setup_datepicker();
</script>
<?php
$form = ob_get_clean();
return $form;
}
function get_form_html($form_id, $id)
{
ob_start();
?>
<div id="head_div" style="padding: 5px 0; background-color: #ECECEC; color: #21ACD7;
border-radius: 5px;margin-left: auto; text-align: center; ">
<?php
$user = new user();
$user->id = $_SESSION['user_id'];
$user->getUser();
$company = new company();
$company->id = $user->company_id;
$company->getCompany();
echo "STOCK REPORT OF {$company->company_name} - {$company->company_code}";
?>
</div>
<div style="margin-top: 10px; background-color:transparent;padding-bottom: 30px;">
<style>
div#purchace_items td{
border: 1px solid #21ACD7;
}
div#purchace_items tbody td{
padding: 5px 0 5px 5px;
}
div#purchace_items th{
border: 1px solid #21ACD7;
}
div#purchace_items tbody th{
padding: 5px 0 5px 5px;
}
div#purchace_items tbody td input,div#purchace_items tbody td select{
padding: 0;
border: 0;
margin: 0;
height: 100%;
width: 100%;
background-color: transparent;
}
</style>
<input type="text" id="search" placeholder="Enter Search Key here..." style="width: 100%; margin-left: 0px;" onkeyup="search()" />
<style>
img#search{
position: relative;
height: 20px;
width: 20px;
float: right;
top: -29px;
right: 10px;
}
</style>
<img id="search" src="../ui/images/search.png" onclick="search()" />
<div id="purchace_items" style="width: 100%; padding: 10px 0; color: #21ACD7;">
<table id="items_table" style="border-collapse: collapse; width: 100%;
background-color: #fff; border-radius: 10px; color: #21ACD7;">
<thead style="text-align: center;">
<tr>
<th>
#
</th>
<th>
ITEM
</th>
<th>
STOCK COUNT
</th>
<th style="">
SELLING PRIZE
</th>
<th style="">
TAX
</th>
</tr>
</thead>
<tbody style="padding-left: 3px; text-align: center; ">
<?php
$inventry = new inventry();
$inventries = $inventry->getInventryForSpecificCompany($user->company_id);
$i = 0;
if ($inventries == NULL || sizeof($inventries) == 0) {
echo '<tr><td colspan="8"> No Stock Found </td></tr>';
} else {
foreach ($inventries as $inventry) {
?>
<tr id="<?php
echo $inventry->id;
?>
" >
<td style="text-align: center;">
<?php
echo ++$i;
?>
</td>
<td>
<?php
$item = new item();
$item->id = $inventry->item_id;
$item->getItem();
echo $item->item_name . ' - ' . $item->item_code;
?>
</td>
<td>
<?php
echo number_format($inventry->in_stock_count, 3, '.', '');
?>
</td>
<td>
<?php
echo number_format($inventry->selling_prize, 2, '.', '');
?>
</td>
<td>
<?php
$tax = new tax_category();
$tax->id = $inventry->tax_category_id;
$tax->getTaxCategory();
echo $tax->tax_category_name;
?>
</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
</div>
<script type="text/javascript">
function search(){
var search_key = $('input#search').val();
if(search_key !== ''){
console.log("search key "+ search_key);
searchTable(search_key);
}else{
$('#items_table tr').show();
}
}
function searchTable(inputVal)
{
var table = $('#items_table');
table.find('tr').each(function(index, row)
{
var allCells = $(row).find('td');
if(allCells.length > 0)
{
var found = false;
allCells.each(function(index, td)
{
var regExp = new RegExp(inputVal, 'i');
if(regExp.test($(td).text()))
{
found = true;
return false;
}
});
if(found == true)$(row).show();else $(row).hide();
}
});
}
</script>
<?php
$form = ob_get_clean();
return $form;
}
