ESH/section_list.php

<?php  include('techsyn_header.php'); ?>    
<!-- Main Content Container for side bar and body-->
<div class="main-container ace-save-state" id="main-container">
		<script type="text/javascript">
			try{ace.settings.loadState('main-container')}catch(e){}
		</script>
<?php  include('techsyn_sidebar.php'); ?>    

<!--breadcrumb-->
<div class="main-content">
    <div class="main-content-inner">
        <div class="breadcrumbs ace-save-state" id="breadcrumbs">
            <ul class="breadcrumb">
               
                <li class="#">Data Setup</li><li class="#">Company Setup</li><li class="active">Section</li>
            </ul>
        </div>
        <!-- End of breadcrumb -->
           
        	<div class="page-content">
			<div id="flexigridDiv" class="table-responsive">
			
				<form name="f1" method="post" action="" id="flex_form_section">
					<div id="flex1" style="width:100%">
					</div>
					<input type="hidden" name="flex_section_id" id="flex_section_id"/>
				</form>	
			</div>
			</div>



    </div><!-- /.page-content -->
</div>
</div><!-- /.main-content -->

                    


<script type="text/javascript">
    $(function () {
		var w=screen.width*.90;

	   	var h =0;
	       	 h =(window.innerHeight-($("#navbar").height()+$(".breadcrumbs").height()))*.75;
        $("#flex1").flexigrid({
            url: 'section_script.php',
            dataType: 'json',
            colModel: [
                {display: 'Sr', name: 'count', width: w*.04, sortable: false, align: 'left'},

                {display: 'Section Name', name: 'section_name', width: w*.2, sortable: true, align: 'left'},
                {display: 'Bussiness Unit', name: 'bu_id', width: w*.15, sortable: true, align: 'left'},
				{display: 'Department Name', name: 'dept_id', width: w*.15, sortable: true, align: 'left'},
				
				{display: '', name: '', width: w*.2, sortable: true, align: 'left'},
              
               
            ],
            buttons: [
              {name: 'Add', bclass: 'add', onpress : add},
			   {separator: true},
			   {name: 'PDF', bclass: 'print', onpress : pdf},
			   {separator: true},
			   {name: 'Excel', bclass: 'print_excel', onpress : excel},
               {separator: true}
            ],
            searchitems: [
          
                {display: 'Section Name', name: 'section_name', isdefault: true},
				      {display: 'Bussiness Unit', name: 'firm_name', isdefault: true},
				      {display: 'Department Name', name: 'sbu_name', isdefault: true},
				      {display: 'Section Head', name: 'fname', isdefault: true},
            ],
            sortname: "section_id",
            sortorder: "asc",
            usepager: true, //pagination

            useRp: true,
           rp: 50, //records per page
            showTableToggleBtn: false, //toggle button for the whole table
            resizable: true,
            //width: w,
            height: h,
            singleSelect: true
        });
    });

 function pdf(){
	window.open('pdf_section.php');
}
function excel(){
	window.location = 'excel_section.php';
} 

function add(){
	$(".save_button").show();
	$("#section_id").val("");
	$("#firm_id").val("");
	$("#sbu_name").val("");
	$("#section_name").val("");
     	$("#head_id").val("");
	$('#modal-add-section').modal("show");
}

function delete_section(sectionId){
	$("#flex_section_id").val(sectionId);
	
	BootstrapDialog.confirm('Are you sure to delete the Section?', function(result){
            if(result) {
               $.ajax({
					url : 'delete_section.php',
					type : "POST",
					data : $("#flex_form_section").serialize(),
					success : function(data) {
						if(data.indexOf("SUCCESS")!=-1){
							BootstrapDialog.alert('Section Deleted Successfully.');
							$("#flex1").flexReload();
								
						}else{
							BootstrapDialog.alert('Error Deleting Section');
						}
					return;
					},
					error : function(data) {
						BootstrapDialog.alert('Error Deleting Section');
						return;
					}
			});
            }
        });
	
}

function save_section(){
	$.ajax({
			url : 'save_section.php ',
			type : "POST",
			data : $("#section_form").serialize(),
			success : function(data) {
				BootstrapDialog.alert('Section Saved Successfully.');
				$("#flex1").flexReload();
				return;
			},
			error : function(data) {
				BootstrapDialog.alert('Error Saving Section');
				return;
			}
	});
    $('.close').click();
}



function open_section(sectionId, action) {

		if(action=="V"){
				$(".save_button").hide();

		}else{
				$(".save_button").show();
		}
		$.ajax({
			url : 'select_section.php?sectionId='+sectionId+' ',
			type : 'POST',
			success : function(data) {
	
			var data = $.parseJSON(data);
				
					$("#section_id").val(data.section_id);
				    $("#section_name").val(data.section_name);
					$("#bu_id").val(data.bu_id);
					$("#dept_name").val(data.dept_id);
				    $("#section_head_name").val(data.section_headname);
				    $("#section_head_email").val(data.section_head_email);
				
					$('#modal-add-section').modal("show");
			},
			error : function(data) {
				BootstrapDialog.alert('Error Populating Section');
				return;
			}
		});
}


function loadSBUList(bu_id, selectId) {
		$("#"+selectId).empty();
		$.ajax({
			url : 'getDynamicData.php?tableName=department&where_clause_field=bu_id&where_clause_value='+bu_id,
			type : 'GET',
			success : function(data) {
	
			var data = $.parseJSON(data);
				
				for(i=0;i<data.length;i++){
						var o=  new Option(data[i].dept_name,data[i].dept_id)
						$("#"+selectId).append(o); 
				}
				
			},
			error : function(data) {
				BootstrapDialog.alert('Error Populating Section');
				return;
			}
		});
}

</script>

<?php  include('techsyn_footer.php'); ?>    
<?php  include('form/add_section.php');?>