Guest User

Untitled

a guest
Oct 18th, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.30 KB | None | 0 0
  1. $('#city').on('change',function(){
  2. var branchName= $('#city option:selected').html();
  3. $('#branchSel').html('<span><b>Branch Name: </b></span>'+branchName).addClass("appear");
  4. var stateName= $('#state option:selected').html().toLowerCase();
  5. var countryName= $('#country option:selected').html().toLowerCase();
  6. countryName = countryName.replace(/s+/g, '-');
  7. stateName = stateName.replace(/s+/g, '-');
  8. branchName = branchName.replace(/s+/g, '-').toLowerCase();
  9. var cityID = $(this).val();
  10. if(cityID){
  11. window.history.pushState('', '', '<?php echo base_url($bank_rename.'/ifsc-code'); ?>/'+countryName+'/'+stateName+'/'+branchName);
  12. $.ajax({
  13. type:'POST',
  14. url:'<?php echo base_url('bank/getBranchDetail'); ?>',
  15. data:'city_id='+cityID,
  16. success:function(data){
  17. $('#dataDisplay').remove();
  18. $('#ifsc').html("").removeClass("appear");
  19. $('#micr').html("").removeClass("appear");
  20. $('#contact').html("").removeClass("appear");
  21. $('#address').html("").removeClass("appear");
  22. var dataObj = jQuery.parseJSON(data);
  23. $(dataObj).each(function(){
  24. var ifsc = $('#ifsc').html("<span><b>IFSC Code: </b></span>");
  25. var micr = $('#micr').html("<span><b>MICR Code: </b></span>");
  26. var contact = $('#contact').html("<span><b>Contact No: </b></span>");
  27. var address = $('#address').html("<span><b>Address: </b></span>");
  28. ifsc.append(this.ifsc_code).addClass("appear");
  29. var ab= this.ifsc_code;
  30. micr.append(this.micr_code).addClass("appear");
  31. contact.append(this.contact_no).addClass("appear");
  32. address.append(this.address).addClass("appear");
  33. $('#branch_code').html('<span><b>Branch Code: </b></span>Last six characters of IFSC Code represent Branch code.');
  34.  
  35. });
  36. }
  37. });
  38. }else {
  39. window.history.pushState('', '', '<?php echo base_url($bank_rename.'/ifsc-code'); ?>/'+countryName+'/'+stateName);
  40. $('#dataDisplay').html('Select State, District, Branch Name to Display Details Here');
  41. $('#branch_code').html("").removeClass("appear");
  42. $('#ifsc').html("").removeClass("appear");
  43. $('#micr').html("").removeClass("appear");
  44. $('#contact').html("").removeClass("appear");
  45. $('#address').html("").removeClass("appear");
  46. }
  47. });
  48. });
  49.  
  50. <td><p id="ifsc"></p></td>
  51.  
  52. public function getBranchDetail(){
  53. $branch = array();
  54. $city_id = $this->input->post('city_id');
  55. if($city_id){
  56. $con['conditions'] = array('id'=>$city_id);
  57. $branchData = $this->Bank_model->getBranchData($con);
  58. }
  59. echo json_encode($branchData);
  60. }
  61.  
  62. function getBranchData($params = array()){
  63. $this->db->select('c.micr_code, c.ifsc_code, c.contact_no, c.address');
  64. $this->db->from($this->branchTbl.' as c');
  65.  
  66. //fetch data by conditions
  67. if(array_key_exists("conditions",$params)){
  68. foreach ($params['conditions'] as $key => $value) {
  69. if(strpos($key,'.') !== false){
  70. $this->db->where($key,$value);
  71. }else{
  72. $this->db->where('c.'.$key,$value);
  73. }
  74. }
  75. }
  76.  
  77. $query = $this->db->get();
  78. $result = ($query->num_rows() > 0)?$query->result_array():FALSE;
  79.  
  80. //return fetched data
  81. return $result;
  82. }
Add Comment
Please, Sign In to add comment