ESH/health_risk.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="#">Masters</li>
					<li class="active">Health Risk</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_health_risk">
						<div id="flex1" style="width:100%">
						</div>
						<input type="hidden" name="flex_health_risk_id" id="flex_health_risk_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: 'health_risk_script.php',
			dataType: 'json',
			colModel: [{
					display: 'Sr',
					name: 'count',
					width: w * .04,
					sortable: false,
					align: 'left'
				},

				{
					display: 'Health Risk Name',
					name: 'health_risk_name',
					width: w * .2,
					sortable: true,
					align: 'left'
				},
				{
					display: 'Health Risk Category',
					name: 'health_risk_cat',
					width: w * .2,
					sortable: true,
					align: 'left'
				},

				{
					display: '',
					name: '',
					width: w * .3,
					sortable: false,
					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: 'Health Risk Name',
					name: 'health_risk_name',
					isdefault: true
				},
				{
					display: 'Health Risk Category',
					name: 'health_risk_cat'
				}
			],
			sortname: "health_risk_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 add() {
		$(".save_button").show();
		$("#health_risk_id").val("");
		$("#health_risk_name").val("");
		$("#health_risk_cat").val("");

		$('#modal-add-health_risk').modal("show");
	}

	function pdf() {
		window.open('health_risk_pdf.php');
	}

	function excel() {
		window.location = 'health_risk_excel.php';
	}

	function delete_health_risk(health_riskId) {
		$("#flex_health_risk_id").val(health_riskId);

		BootstrapDialog.confirm('Are you sure to delete the Health Risk?', function(result) {
			if (result) {
				$.ajax({
					url: 'delete_health_risk.php',
					type: "POST",
					data: $("#flex_form_health_risk").serialize(),
					success: function(data) {
						if (data.indexOf("SUCCESS") != -1) {
							BootstrapDialog.alert('Health Risk Deleted Successfully.');
							$("#flex1").flexReload();

						} else {
							BootstrapDialog.alert('Error Deleting Health Risk ');
						}
						return;
					},
					error: function(data) {
						BootstrapDialog.alert('Error Deleting Health Risk');
						return;
					}
				});
			}
		});

	}

	function validate() {
		var health_risk_name = $('#health_risk_name').val();
		if (health_risk_name == '') {
			BootstrapDialog.alert('Please Enter Health Risk Name.!!!');
			return false;
		}
		var health_risk_cat = $('#health_risk_cat').val();
		if (health_risk_cat == '') {
			BootstrapDialog.alert('Please Enter Health Risk Category.!!!');
			return false;
		}

		for (let i = 0; i < health_risk_cat.length; i++) {
			let result = isValid(health_risk_cat[i]);
			if (!result) {
				BootstrapDialog.alert("You can not enter spaces and special characters in column name");
				return result;
			}
		}

		
		for (let i = 0; i < health_risk_name.length; i++) {
			let result = isValid(health_risk_name[i]);
			if (!result) {
				BootstrapDialog.alert("You can not enter spaces and special characters in column name");
				return result;
			}
		}

		function isValid(str) {
			return !/[~`!@#$%\^&*()+=\-\\\[\]\\';,/{}|\\":<>\?]/g.test(str);
		}

		save_health_risk();
	}

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


	function open_health_risk(health_riskId, action) {
		var health_risk_id = "";
		if (action == "V") {
			$(".save_button").hide();

		} else {
			$(".save_button").show();
		}
		$.ajax({
			url: 'select_health_risk.php?health_riskId=' + health_riskId + ' ',
			type: 'POST',
			success: function(data) {
				//alert(data);
				var data = $.parseJSON(data);
				//alert(data);

				$("#health_risk_id").val(data.health_risk_id);
				$("#health_risk_name").val(data.health_risk_name);
				$("#health_risk_cat").val(data.health_risk_cat);

				$('#modal-add-health_risk').modal("show");
			},
			error: function(data) {
				BootstrapDialog.alert('Error Populating Health Risk');
				return;
			}
		});
	}
</script>

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