EVOLUTION-NINJA
Edit File: link_product.php
<div class="page-content-wrapper"> <div class="page-content"> <h3 class="page-title">Link Product </h3> <div class="page-bar"> <ul class="page-breadcrumb"> <li><i class="fa fa-home"></i> <a href="<?php echo base_url();?>dashboard/dashboard_fun">Home</a> <i class="fa fa-angle-right"></i> <a href="#" > Product to Vendor Link </a></li> </ul> </div> <input type="hidden" id="delete_id" class="delete_id" value="<?php if(empty($access_row)) { } else { echo $access_row->delete_id; } ?>" > <form class="form-inline" style="padding-top:3%;"> <div class="row" style="padding-bottom:15px;"> <div class="" style="padding-bottom:2%; padding-top:2%;"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-3 col-xs-5" style="padding-left: 0 !important;">Select Product</label> <input type="text" onkeyup="searchname()" onfocusout="myFunction()" id="pro_name" name="productname" class="col-sm-9 col-xs-7" value="" required="required"> </div> <div class="form-group col-sm-12 col-md-6"></div> </div> <!-- row 4---> <!--<div class="col-sm-7"> <div class="form-group col-sm-12 col-md-12"> <label class="col-sm-3 col-xs-5" style="padding-right:0 !important;">Select Product </label> <!--<input type="text" class="col-sm-9 col-xs-7" id="productname" name="productname" > <input type="text" onkeyup="searchname()" onfocusout="myFunction()" id="pro_name" name="productname" class="col-sm-9 col-xs-7" value="" required="required"> <!--<input type="text" id="customer_id" class="form-control ss col-sm-8" name="c" value="" required="required" readonly> </div> </div>--> </div> <!-- row 1---> <div class="row select_product"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-xs-5">Product</label> <input type="text" class="col-sm-8 col-xs-7" name="p_name" id="pp_name" readonly> </div> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-xs-5">Product Type</label> <input type="text" class="col-sm-8 col-xs-7" name="p_type" id="pp_type" readonly> </div> </div> <!-- row 2---> <div class="row select_product" style="padding-bottom:15px;"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-xs-5" style="padding-right: 0 !important;">Product Description</label> <input type="text" class="col-sm-8 col-xs-7" name="p_desc" id="pp_desc" readonly> </div> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-xs-5"></label> <input type="text" class="col-sm-8 col-xs-7" name="name"> </div> </div> <!-- row 3---> <!-- form 2 END ----------------------------------------------------------> <div class="row" style="padding-bottom:2%; padding-top:2%;"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-3 col-xs-5" style="padding-left: 0 !important;">Vendor Name</label> <input type="text" onkeyup="vendor_searchname()" onfocusout="vendor_myFunction()" id="vendor_name" name="ve_name" class="col-sm-9 col-xs-7" value="" required="required"> </div> <div class="form-group col-sm-12 col-md-6"></div> </div> <!-- row 4---> <div class="row select_product"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-xs-5">Name</label> <input type="text" class="col-sm-8 col-xs-7" name="v_name" id="v_name" readonly> </div> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-xs-5">Phone</label> <input type="text" class="col-sm-8 col-xs-7" name="v_phone" id="v_phone" readonly> </div> </div> <!-- row 2---> <div class="row select_product" style="padding-bottom:15px;"> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-xs-5">Address</label> <input type="text" class="col-sm-8 col-xs-7" name="v_address" id="v_address" readonly> </div> <div class="form-group col-sm-12 col-md-6"> <label class="col-sm-4 col-xs-5">Email</label> <input type="text" class="col-sm-8 col-xs-7" name="v_email" id="v_email" readonly> </div> </div> <!-- row 3---> <div style="text-align:center;padding-top:15px;"> <button id="add_link" name="add_link" class="btn add" style="padding:3px 24px !important;">Link</button> </div> </form> <br/><br/> <!-- form 3 ----------------------------------> <div id = "jaytab" class="jaytab"> <table id="list2"></table> <div id="pager2"></div> <div id="dialogSelectRow" title="Warning" style="display:none"> <p>Please select row</p> </div> </div> </div> <!-- page-content --> </div> <!-- page-content-wrapper --> <style> #jaytab{ width:100%; overflow:auto; } #ui-id-1 { display: none; width: 350px; top: 258px; overflow-x: hidden !important; overflow-y: scroll !important; height: 203px !important; } #ui-id-2 { display: none; width: 350px; top: 258px; overflow-x: hidden !important; overflow-y: scroll !important; height: 203px !important; } #search_list2 { display:none; } #refresh_list2 { display:none; } .btn{ padding: 4px 29px !important; font-size: 15px !important; font-weight: bold; } .select_product label{ background: #485b7f; color: white; height: 23px; padding-top: 2px; margin-bottom:0; } .select_product input{ background: #e8ecf2; border: transparent; height: 25px; border-bottom: 2px solid white; } @media only screen and (min-width:320px) and (max-width:640px) { .add{ //margin-left: 40%; margin-top: 10px; } } .form-group { margin-bottom:0 !important; } </style> <script src="<?php echo base_url(); ?>assets/js/sweetalert.min.js" type="text/javascript"></script> <link href="<?php echo base_url(); ?>assets/css/sweetalert.min.css" rel="stylesheet" type="text/css" > <script type="text/javascript"> $("#add").click(function(e) { e.preventDefault(); var product_name =$('#product_name').val(); var product_type =$('#product_type').val(); var product_desc =$('#product_desc').val(); if(product_name != '' && product_type != '' ) { $.ajax({ url:"<?php echo base_url('vendor/insert_product_data');?>", type:"POST", data:{'product_name':product_name,'product_type':product_type,'product_desc':product_desc}, async:false, success:function(data) { swal({ title: "Successfully Added", text: "", }); $("#product_name").val(''); $("#product_type").val(''); $("#product_desc").val(''); } }); } else{ swal({ title: "Please Fill All The Fields", text: "", }); } }); $("#add_link").click(function(e) { e.preventDefault(); var p_name =$('#pp_name').val(); var p_type =$('#pp_type').val(); var p_desc =$('#pp_desc').val(); var v_name =$('#v_name').val(); var v_phone =$('#v_phone').val(); var v_address =$('#v_address').val(); var v_email =$('#v_email').val(); if(p_name != '' && p_type != '' && v_name != '' && v_phone != '' && v_address != '' && v_email != '' ) { $.ajax({ url:"<?php echo base_url('vendor/insert_product_link_data');?>", type:"POST", data:{'p_name':p_name,'p_type':p_type,'p_desc':p_desc,'v_name':v_name,'v_phone':v_phone,'v_address':v_address,'v_email':v_email}, async:false, success:function(data) { $("#product_name").val(''); $("#product_type").val(''); $("#product_desc").val(''); window.location.reload(); } }); } else{ swal({ title: "Please Fill All The Fields", text: "", }); } }); </script> <link rel="stylesheet" href="<?php echo base_url('assets/css/code_jquery.min.css');?>"> <script src="<?php echo base_url('assets/js/jquery-ui.min.js'); ?>" type="text/javascript"></script> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('assets/css/jquery-ui.min.css'); ?>" /> <script> $(document).ready(function() { $( "#pro_name" ).autocomplete({ source: '<?php echo base_url('vendor/auto_sea'); ?>', }); }); function searchname() { var customer = document.getElementById('pro_name').value; $.ajax({ url:"<?php echo base_url('vendor/search_by_fetch')?>", dataType: "json", data:{'customer':customer}, type:"POST", async:true, success:function(data) { // alert('hai'); var obj=JSON.parse(data); document.getElementById('pp_name').value=obj[0].product; document.getElementById('pp_type').value=obj[0].product_type; document.getElementById('pp_desc').value=obj[0].product_description; } }); } function myFunction() { var customer = document.getElementById('pro_name').value; $.ajax({ url:"<?php echo base_url('vendor/search_by_fetch')?>", dataType: "json", data:{'customer':customer}, type:"POST", async:true, success:function(data) { // alert('hai'); var obj=JSON.parse(data); document.getElementById('pp_name').value=obj[0].product; document.getElementById('pp_type').value=obj[0].product_type; document.getElementById('pp_desc').value=obj[0].product_description; } }); } $(document).ready(function() { $( "#vendor_name" ).autocomplete({ source: '<?php echo base_url('vendor/auto'); ?>', }); }); function vendor_searchname() { var customer = document.getElementById('vendor_name').value; $.ajax({ url:"<?php echo base_url('vendor/vendor_search_by_fetch')?>", dataType: "json", data:{'customer':customer}, type:"POST", async:true, success:function(data) { // alert('hai'); var obj=JSON.parse(data); document.getElementById('v_name').value=obj[0].name; document.getElementById('v_phone').value=obj[0].phone; document.getElementById('v_address').value=obj[0].address; document.getElementById('v_email').value=obj[0].email; } }); } function vendor_myFunction() { var customer = document.getElementById('vendor_name').value; $.ajax({ url:"<?php echo base_url('vendor/vendor_search_by_fetch')?>", dataType: "json", data:{'customer':customer}, type:"POST", async:true, success:function(data) { // alert('hai'); var obj=JSON.parse(data); document.getElementById('v_name').value=obj[0].name; document.getElementById('v_phone').value=obj[0].phone; document.getElementById('v_address').value=obj[0].address; document.getElementById('v_email').value=obj[0].email; } }); } </script> <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/jquery.jqGrid.min.js'); ?>"></script> <!-- This is the localization file of the grid controlling messages, labels, etc. <!-- We support more than 40 localizations --> <script type="text/ecmascript" src="<?php echo base_url('jqgrid/js/i18n/grid.locale-en.min.js'); ?>"></script> <!-- A link to a jQuery UI ThemeRoller theme, more than 22 built-in and many more custom --> <!-- The link to the CSS that the grid needs --> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid.min.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid-bootstrap.min.css'); ?>" /> <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('jqgrid/css/ui.jqgrid-bootstrap-ui.min.css'); ?>" /> <link rel="stylesheet" type="text/css" href="<?php echo base_url();?>assets/css/bootstrap-datepicker.min.css"/> <script src="<?php echo base_url();?>assets/js/bootstrap-datepicker.min.js"></script> <script> $('.datepicker').datepicker({ format: 'yyyy/mm/dd', }); </script> <style type="text/css"> .ss{ padding-right: 0 !important; padding-left: 0 !important; } label { font-weight: normal; text-align: left; } .hr-line{ border-top: 1px solid #465A81; } .well-sm { padding: 3px !important; border-radius: 0px !important; } input[type="file"] { padding-bottom: 28px !important; height: 25px !important; color:transparent; } .portlet.box.blue-madison { border: 1px solid #fff !important; border-top: 0; background:#fff !important; } input[type=file] { display: none; } .ui-jqgrid .ui-jqgrid-caption { text-align: left; background: rgb(72,91,127); color: white; } .ui-jqdialog .ui-jqdialog-titlebar { padding: .1em .1em; min-height: 35px; background: rgb(72,91,127); color: white; } .ui-jqdialog .ui-jqdialog-titlebar-close span { display: block; margin: -9px; } #sData { height: 27px; } #cData { height: 27px; } #dData { height: 27px; } #eData { height: 27px; } </style> <script> $(document).ready(function (){ //var l=$("#loc").val(); //alert(l); jQuery("#list2").jqGrid({ url:"<?php echo base_url('vendor/add_vendor_link_product_details')?>", datatype: "json", colNames:['Id','Product Name','Product Type','Product Description','Vendor Name','Vendor Address','Vendor Phone No.','Vendor Email'], colModel:[ {name:'id',index:'id',hidden:true, width:50,editable:true,width:100}, {name:'product',index:'product', width:138,editable:false}, {name:'product_type',index:'product_type', width:138,editable:true,editrules:{required: true}}, {name:'product_description',index:'product_description', editable:true,editrules:{required: true},width:148}, {name:'vendor_name',index:'vendor_name', width:148,editable:false}, {name:'vendor_address',index:'vendor_address', width:148,editable:true,editrules:{required: true}}, {name:'vendor_phone',index:'vendor_phone', editable:true,editrules:{required: true},width:148}, {name:'vendor_email',index:'vendor_email', editable:true,editrules:{required: true},width:168}, ], rowNum:50, rowTotal: 200000000000000000000000000, rowList : [50,100,200,300,500,1000,5000], rownumbers: true, pager: '#pager2', sortname:'id', viewrecords: true, loadonce:true, gridview: true, sortorder:"desc", caption:"Product Link Details", // multiselect: true, // onPaging : function(but) { // alert("Button: "+but + " is clicked"); // } }); //$("#list2").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required jQuery("#list2").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn" }); $("#list2").jqGrid('navGrid','#pager2', {edit:false,add:false,del:false,search:true,refreshstate:"current"}, { }, { }, { }, { sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'], closeOnEscape: true, multipleSearch: true, closeAfterSearch: true, multipleGroup:true, caption:"search" } ); $("#list2").navButtonAdd('#pager2', { caption:"Delete", buttonicon:"ui-icon-trash", onClickButton: deleteRow, position: "last", title:"", cursor: "pointer", id:"client_delete" } ); }); function deleteRow() { // Get the currently selected row var v=$('#delete_id').val(); if(v == 1) { var row = $("#list2").jqGrid('getGridParam','selrow'); $("#id").val(row); if( row != null ) $("#list2").jqGrid('delGridRow',row, { modal:true,jqModal:true, recreateForm: true, beforeSubmit: function(postdata,formid){ $.ajax({ url:"<?php echo base_url('vendor/delete_product_delete');?>", type:"POST", data:{'id':row}, async:false, success:function(data){ if(data==""){ alert('Successfully Deleted'); $("#delmodlist2").remove(); $("#list2").trigger("reloadGrid"); window.location.reload(); } else{ alert('Successfully Deleted'); $("#delmodlist2").remove(); $("#list2").trigger("reloadGrid"); window.location.reload(); } } }); }, closeAfterEdit: true, reloadAfterSubmit:false, afterSubmit : false }); else $( "#dialogSelectRow" ).dialog(); } else { swal({ title: "You Don't Have Access For This Delete", text: "", }); } } $("#update").click(function(e) { e.preventDefault(); // alert(); var product_id =$('#product_id').val(); var product_name =$('#product_name').val(); var product_type =$('#product_type').val(); var product_desc =$('#product_desc').val(); if(product_name != '' && product_type != '' && product_desc != '') { $.ajax({ url:"<?php echo base_url('vendor/update_product_link_data');?>", type:"POST", data:{'product_id':product_id,'product_name':product_name,'product_type':product_type,'product_desc':product_desc}, async:false, success:function(data) { window.location.href = '<?php echo base_url('vendor/add_link_product_details');?>'; } }); } else{ swal({ title: "Please Fill All The Fields", text: "", }); } }); </script>