ESH/flexi_pending_rnote.php

<title>R-Note</title>
<?php 
include('top.php');

?>

<script type="text/javascript">
$(function() {
var w=screen.width-25;
    $("#flex1").flexigrid({
            url: 'flexi_pending_rnote_script.php',
            dataType: 'json',
            colModel : [
                    {display: 'Sr', name : 'count', width : w*0.010, sortable : false, align: 'left'},
					{display: 'Client', name : 'client', width : w*0.090, sortable : true, align: 'left'},
					{display: 'Date ', name : 'date_marked_for_dispatch', width : w*0.045, sortable : true, align: 'left'},
					{display: 'Sales Order No', name : 'pf_no', width : w*0.045, sortable : true, align: 'left'},
					{display: 'Order File No', name : 'po_no', width : w*0.045, sortable : true, align: 'left'},
					{display: 'PL No', name : 'item_id', width : w*0.045, sortable : true, align: 'left'},
					{display: 'Item', name : 'item_id', width : w*0.045, sortable : true, align: 'left'},
					{display: 'Item Description', name : 'a.item_desc', width : w*0.400, sortable : true, align: 'left'},
				   //	{display: 'Installment No', name : 'call_installment_no', width : 80, sortable : true, align: 'left'},
                   //                   {display: 'Drawing', name : 'drawing_id', width : 70, sortable : true, align: 'left'},
				   	{display: 'Order Qty', name : 'external_result', width : w*0.045, sortable : true, align: 'left'},
					{display: 'Dispatch Qty', name : 'external_result', width : w*0.0450, sortable : true, align: 'left'},
                    {display: 'Delivery Challan', name : 'challan_no', width : w*0.045, sortable : true, align: 'left'},			
					{display: 'ADD', name : 'print_link', width : w*0.02, sortable : false, align: 'center'},
				
            ],
            buttons : [
                    {name:'<b><font size="2">R-Note</font></b>'},
					//{name: 'Add', bclass: 'add', onpress : doCommand},
					{name: 'Print', bclass: 'print_excel', onpress : doCommand},
            
                    {separator: true}
            ],
            searchitems : [
                                        {display: 'Sales Order No', name : 'purchase_order_no', isdefault: true},
                                        {display: 'Order File No', name : 'production_file_no'},
					{display: 'Date (DD/MM/YYYY)', name : 'date_marked_for_dispatch'},
				        {display: 'Item', name : 'item_name'},
					{display: 'PL No', name : 'pl_no'},
					{display: 'Firm', name : 'firm_code'},
					{display: 'Client', name : 'client'},
					{display: 'Date Spread (DD/MM/YYYY, DD/MM/YYYY)', name : 'submission_date_between'}
					  
            ],
            sortname: "a.date_marked_for_dispatch",
            sortorder: "asc",
            usepager: true,//pagination
           
            useRp: true,
            rp: 200,//records per page
            showTableToggleBtn: false,//toggle button for the whole table
            resizable: false,
            width: window.innerWidth,
            height: window.innerHeight-130,
			singleSelect: true
    });
});

function doCommand(com, grid) {
	if (com == 'Add') {
		location.href="manage_tender_entry.php?acn=add";
	}
	if (com == 'Print') {
		window.open('ajax_pdf.php','Pendingrnote');
	}
	
	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="menu_master.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>

<tr>

    <td height="350" valign="top" align="center">
    <table width="700px" border="0" cellspacing="0" cellpadding="0" align="center">
	<tr height="3px"></tr>
    <tr>
        <td align="justify">	
			<form name="f1" method="post" action="<?php  echo $this_script?>">
			<input type="hidden" name="pdf_action" id="pdf_action" value="excel_rnote_pending.php"/>
                           
				<table width="100%" border="0" cellspacing="0" cellpadding="4" id="flex1" >
				</table>
			</form>
 		</td>
 	</tr>

 </table>

 </td>

 </tr>