ESH/techsyn_item_stock_list.php

<?php  include('techsyn_header.php'); ?>    
<?php  include('techsyn_sidebar.php'); ?> 


<!--breadcrumb-->

<div class="sidebar-toggle sidebar-collapse" id="sidebar-collapse">
    <i id="sidebar-toggle-icon" class="ace-icon fa fa-angle-double-left ace-save-state" data-icon1="ace-icon fa fa-angle-double-left" data-icon2="ace-icon fa fa-angle-double-right"></i>
</div>
</div>

<div class="main-content">
    <div class="main-content-inner">
        <!--do not modify anything above-->
        <div class="breadcrumbs ace-save-state" id="breadcrumbs">
            <ul class="breadcrumb">
                <li>
                    <i class="ace-icon fa fa-home home-icon"></i>
                    <a href="#">Home</a>
                </li>
                <li class="#">Reports</li><li class="active">Inventory Report</li>
            </ul>
        </div>
        <div style="margin-left:3px">

            <form name="f1" method="post" action="<?php  echo  $this_script ?>">
                <div id="flex1" >
                </div>
            </form>	
        </div>

        
        
         <!--do not modify anything below-->
    </div><!-- /.page-content -->
</div>
</div><!-- /.main-content -->




<?php  include('techsyn_footer.php'); ?>  
<script type="text/javascript">

$(function() {
     var w =$(".main-content-inner").width()-15;
     var h=$(".main-content").height();
    $("#flex1").flexigrid({
            url: 'item_stock_list_script.php',
            dataType: 'json',
            colModel : [
                    {display: 'Sr', name : 'count', width : w*.05, sortable : false, align: 'left'},
					{display: 'Warehouse', name : 'warehouse', width : w*.15, sortable : true, align: 'left'},
					{display: 'Item Code', name : 'itemCode', width : w*.2, sortable : true, align: 'left'},
			       	{display: 'Item Desc', name : 'itemdesc', width : w*.2, sortable : false, align: 'left'},
			       	{display: 'Inven Qty', name : 'avail_qty', width : w*.1, sortable : false, align: 'left'},	
					{display: 'AvailQty', name : 'avail_qty', width : w*.1, sortable : false, align: 'left'},						
					
            ],
            buttons : [
					   
            ],
            searchitems : [
								{display: 'Item Code', name : 'itemCode', isdefault: true},
                    			{display: 'Item Desc', name : 'itemDesc'},
                    			{display: 'Warehouse', name : 'warehouse'},
                    
            ],
            sortname: "warehouse_id",
            sortorder: "asc",
            usepager: true,//pagination
            title: "Item Stock",
            useRp: true,
            rp: 50,//records per page
            showTableToggleBtn: false,//toggle button for the whole table
            resizable: false,
            width: w,
            height: h,
            singleSelect: true
    });
});

function doCommand(com, grid) {
	if (com == 'Add') {
		location.href="";
	}
	if (com == 'Print') {
			
	}
	if (com == 'Edit') {
		$('.trSelected', grid).each(function() {
		var id = $(this).attr('id');
		id = id.substring(id.lastIndexOf('row')+3);
		alert("Edit row " + id);
		});
		location.href="store_item.php?acn=update";
		
	} else if (com == 'Delete') {
		$('.trSelected', grid).each(function() {
		var id = $(this).attr('id');
		alert((this));
		alert(id);
		id = id.substring(id.lastIndexOf('row')+3);
		alert("Delete row " + id);
		});
	}
}

function delete_menu(button, grid) {
        var total_count = $('.trSelected', grid).length;
        var deleted     = 0;

        $.each($('.trSelected', grid), function() {
            var id = $('td:nth-child(1) div', this).html();
            $.ajax({
                url: '/api/book/' + id,
                type: 'DELETE',
                data: {},
                dataType: 'json',
                success: function() {
                    deleted++;
                    if (deleted == total_count) {
                        $('#books_grid').flexReload();
                    }
                }
            });
        });
    }
function add_menu(button, grid) {
        var form_div = $('#book_form');

        form_div.load('/ajax/book_form_add', null, function() {
            $('#book_form form').ajaxForm({
                url: '/ajax/book_form_add',
                success: function() {
                    form_div.hide();
                    $('#books_grid').flexReload();
                }
            });
            form_div.show();
        });
    }

    function edit_menu(button, grid) {
        var id = $('.trSelected td:nth-child(1) div', grid).html();
        var form_div = $('#book_form');
        var url = '/ajax/book_form_edit/' + id;                                                                                

        form_div.load(url, null, function() {
            $('#book_form form').ajaxForm({
                url: url,
                success: function() {
                    form_div.hide();
                    $('#books_grid').flexReload();
                }
            });
            form_div.show();
        });
    }

</script>