EVOLUTION-NINJA

Edit File: Execution_list.php

<?php $this->load->view('includes/header.php')?>

<div class="content-wrapper">
    <div class="content-header">
      <div class="container-fluid">
      <div class="row mb-2">
        <div class="col-sm-6">
        </div>
        <div class="col-sm-6">
        <ol class="breadcrumb float-sm-right">
          <li class="breadcrumb-item"><a href="#">Design</a></li>
          <li class="breadcrumb-item"> Revised Budget </li>
        </ol>
        </div> 
      </div> 
      </div>
    </div>
   <div class="row">
      
    <div class="col-md-12 grid-margin stretch-card">
      <div class="card">
        <div class="card-body">

<div id="revised_new_list">
          <div id ="jaytab3" style="margin-top:3%" class="grid table-responsive">
          <table id="list1"></table>
          <div id="pager1"></div>
          <div id="dialogSelectRow" title="Warning" style="display:none">
          <p>Please select row</p>
          </div>
          </div>
        </div>

</div>
      </div>
    </div>
  </div>
</div>
<div class=" myModal modal fade"  tabindex="-1" role="dialog" aria-labelledby="ModalLabel" aria-hidden="true" id="MymodalPreventScript">

<div class="modal-content ">
      <div class="modal-header">
         <h3 class="modal-title pull-right">Follow up</h3>
        <button type="button" class="close" data-dismiss="modal">&times;</button>
       
      </div>
      <form method="post" class="add_forms">
      <div class="modal-body">
       
        <p><b>Customer : </b><b id="customer_name"></b>
          <span style="padding-left: 175px;">
            <b>Contact No : </b>
            <b id="contact_no"></b>
          </span>
          <span style="float: right;">
            <b>Email ID : </b>
            <b id="email"></b>
          </span>
        </p>

<div id ="jaytab" style="margin-top:3%" class="grid table-responsive">
          <table id="list4"></table>
          <div id="pager4"></div>
          <div id="dialogSelectRow3" title="Warning" style="display:none">
            <p>Please select row</p>
          </div>
        </div>
        
      
        <hr>

<h5>Add followup</h5>
        <div class="row">
          <div class="col-sm-6">
            <label for="name">Progress</label>
            <div class="form-group">
              
                <select type="text" name="progress" class="form-control progress_type" required="">  
                  <option value="">Select</option>
                  <option value="Loan Followup ">Loan Followup </option>
                  <option value="Registration">Registration</option>
                  <option value="Records">Records</option>
                  <option value="Architecture ">Architecture </option>
                  <option value="Building Agreement">Building Agreement 
                  </option><option value="Execution">Execution</option>
                  <option value="House Service ">House Service</option>
                  <option value="Layout Service">Layout Service</option>
                  <option value="Customer Visit">Customer Visit</option>
                  <option value="Finalized Reject">Finalized Reject</option>
                  <option value="Recovery">Recovery</option>
                  <option value="Payment">Payment</option>
                </select>
              </div>
          </div>
          <div class="col-sm-6">
            <label for="name">Layout Name</label>
            <div class="form-group">
              
                <select type="text" name="" class="form-control booking_layout_id" required="" id="layout_idsss" disabled="">  
                  <option value="">Select</option>
                    <?php foreach($result_layout as $key => $value) { ?> 
                  <option value="<?php echo $value->id; ?>"><?php echo $value->layout_name;?></option>
                    <?php } ?>

</select>
                 
              </div>
          </div>
          <input type="hidden" name="layout_id" class="form-control" id="layout_id" >
          <div class="col-sm-6 followup_date">
            <div class="form-group">
              <label for="name">Follow Date :</label> 
              <input type="text" name="follow_date" class="date form-control date-picker date-picker1"  autocomplete="off"  required>
              <input type="hidden" name="followuser_id" class="followuser_id form-control">
               <input type="hidden" name="" class="site_idss form-control" >
            </div>
          </div>
          <div class="col-sm-6">
              
              <div class="form-group" id="leaves1">
            </div>
          </div>
          </div>
          <div class="row">
           
            
            <div class="col-sm-6">
              <label for="name">Assign Employee</label>
              <div class="form-group">
                <select name="employee" class="form-control employee_name"  required>
                  <option value="">Select</option>
                  <?php foreach($employee_type as $key => $value) { ?> 
                  <option value="<?php echo $value->emp_id; ?>"><?php echo $value->full_name;?> <?php echo $value->last_name;?> </option>
                  <?php } ?> 
                </select> 
              </div>
            </div>

<div class="col-sm-6">
            <div class="form-group">
               <label for="name">Department</label>
               <input type="text" class="form-control" name="department" id="department_name" readonly="" required="">
                <input type="hidden" name="department_id" id="department_id">
            </div>
          </div>
          <div class="col-sm-12">
              <div class="form-group">
                <label for="name">Description :</label>
                  <textarea name="description" name="description" class="date form-control" id="modal_input" required="required"></textarea>
              </div>
            </div>
             <div class="row">
           <div class="col-sm-6">
              
              <div class="form-group">
                <label for="name">File Attachment Name</label>
                <select name="file_name" class="form-control file_name"  required>
                  <option value="">Select</option>
                  <?php foreach($file_names as $key => $value) { ?> 
                  <option value="<?php echo $value->id; ?>"><?php echo $value->name;?></option>
                  <?php } ?> 
                </select> 
              </div>
            </div>
            <div class="col-sm-6">
            <div class="form-group">
               <label for="name">File Attachment</label>
               <input type="file" class="form-control file" name="file" id="file" required="" >
               
            </div>
          </div>

</div>

</div>
      <div class="modal-footer">
        <button type="submit" class="btn btn-primary add">Submit</button>
        <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
      </div>
    </form>
    </div>

</div>
</div>

#pager2_left
{
  display: none !important;
}

#pager2_center
{
  padding-left: 350px !important;
}     
.form-control:focus, input[type="Submit"]:focus, input[type="button"]:focus {
  border-color: #FF0000;
  box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075), 0 0 8px rgba(255, 0, 0, 0.6);
}
#FrmGrid_list2
{
  width: 100% !important;
}
.ui-jqdialog .ui-jqdialog-titlebar
{
  height: 29px !important;
  background-color: #001a00;
  color: white;
  padding-left: 10px;
}
.fm-button
{
  height: 21px !important;
  padding: 1px;         
  margin-right: 10px !important;
  height: 21px !important;            
    width: 43%;
    margin-top: -7px !important;
}
.ui-jqdialog-content td.navButton {
  padding-top: 12px !important;
}
.ui-jqgrid .ui-jqgrid-titlebar
{
  height: 27px !important;
  /*background:#1e7ad7 !important;*/
  color:white !important;
}
.ui-jqgrid-bdiv
{
  height: auto !important;
  
}
.ui-widget-overlay
{
  z-index:0 !important;
}
.ui-widget-header
{
/*background: #1e7ad7 !important;*/
}
.ui-jqgrid-hdiv ui-state-default
{
//width: 873px !important; 
cursor: default!important
}
ui-state-highlight, .ui-widget-content .ui-state-highlight, .ui-widget-header .ui-state-highlight 
{
border: 1px solid #fed22f;
background: #ffe45c;
}
.ui-state-default, .ui-widget-content .ui-state-default, .ui-widget-header .ui-state-default
{
  font-weight: bold;
  color: black;
}
.ui-jqgrid .ui-jqgrid-bdiv {
//overflow-y: scroll;
//overflow-x: scroll ;
//width: 100% !important;
}

.ui-jqgrid-htable{
  //width: 100% !important;
}
#list2{
  //width: 100% !important;
}
.ui-jqgrid-hdiv {
  //width: 100% !important;
}

@media only screen and (min-width:320px) and (max-width:640px)
{
  #jaytab {
    width: 1100px !important;
    overflow-x: scroll !important;
  }
  .ui-jqgrid ui-widget ui-widget-content ui-corner-all {
    //width: 900px !important;
  }
  .ui-jqgrid-view  {
    //width: 900px !important;
  }
  .ui-jqgrid-hdiv {
    //width: 900px !important;
  }
  .ui-jqgrid-htable {
    width: 900px !important;
  }
  .ui-jqgrid-bdiv {
    width: 900px !important;
  }
  #list2 {
    width: 900px !important;
  }
  #pager2 {
    width: 900px !important;
  }
  .subgrid-data {
    width: 1100px !important;
    overflow-x: scroll !important;
  }
  .table-responsive {
    border: transparent;
  }
  .ui-jqgrid {
    background-color: #ecf0f5;
    border: 1px solid #ecf0f5 !important;
    border-radius: 0px !important;
  }
  #myTable {
        overflow-x: scroll;
        width: 1200px;
  }
}
@media only screen and (min-width:641px) and (max-width:991px)
{
  #jaytab {
    width: 1100px !important;
    overflow-x: scroll !important;
  }
  .ui-jqgrid ui-widget ui-widget-content ui-corner-all {
    //width: 900px !important;
  }
  .ui-jqgrid-view  {
    width: 900px !important;
  }
  .ui-jqgrid-hdiv {
    width: 900px !important;
  }
  .ui-jqgrid-htable {
    width: 900px !important;
  }
  .ui-jqgrid-bdiv {
    width: 900px !important;
  }
  #list2 {
    width: 900px !important;
  }
  #pager2 {
    width: 900px !important;
  }
  .subgrid-data {
    width: 1100px !important;
    overflow-x: scroll !important;
  }
  .table-responsive {
    border: transparent;
  }
  .ui-jqgrid {
    background-color: #ecf0f5;
    border: 1px solid #ecf0f5 !important;
    border-radius: 0px !important;
  }
    
}

.table-bordered>thead>tr>th, .table-bordered>tbody>tr>td, .table-bordered>tbody>tr>th {
  border: 1px solid #555;
}
.table>thead:first-child>tr:first-child>th {
    border-top: 1px solid #555;
}
table.table-bordered th:last-child, table.table-bordered td:last-child {
  border-right: 1px solid #555;
}
  
</style>

function booking_up(id,site_id,layout_id)
{
  load_grid(id,site_id,layout_id);
  $('.followuser_id').val(id);
  $('.myModal').modal({
        backdrop: 'static',
        keyboard: false
    });
  var followuser_id = $('.followuser_id').val();
  $.ajax({
      type:'post',
      url:'<?php echo site_url('get-customer-name');?>',
      data:{'followuser_id':followuser_id},
      success:function(response){
      response=jQuery.parseJSON(response);

if(response.result==1)
      {  
      
        $('#customer_name').empty();
        $('#customer_name').text(response.customer.name);
        $('#contact_no').text(response.customer.phone);
        $('#email').text(response.customer.email);
        $('#layout_idsss').val(response.sales.layout_id);
        $('#layout_id').val(response.sales.layout_id);
        $('.site_idss').val(response.sales.site_id);
             $.ajax({
                            
              type:'post',
              url:'<?php echo site_url('get-site-based-on-layout');?>',
              data:{'layout_id':response.sales.layout_id},
              success:function(response){
              response=jQuery.parseJSON(response)

if(response.result==1)
                  {
                      var site_idss = $('.site_idss').val();

var con1 = '';
                      con1 += '<label for="name">Site No</label>';
                      con1 += '<select type="text" class="form-control site_list" name="" disabled>';
                      con1 += '<option value="">Select</option>';
                      $.each( response.sites, function( key, value2 ) {
                     
                        if(site_idss == value2.id)
                        {
                          con1+='<option value="'+value2.id+'" selected>'+value2.site_no+'</option>';
                        }
                        else
                        {
                          con1+='<option value="'+value2.id+'" >'+value2.site_no+'</option>';
                        }

});
                      con1 += '</select> ';  
                       con1 += '<input type="hidden" name="site_id" class="booking_layout_id form-control" readonly="" value="'+site_idss+'">';

$('#leaves1').empty();
                      $('#leaves1').append(con1);
                  }
                  else
                  {
                     $('#leaves1').empty();
                    toastr["error"](response.message);      
                  }
            }
            });
            
       }
       else
       {
          $('#customer_name').empty();
          toastr["error"](response.message);  
       }
      }
    });
}

rowNum:20,
          rowTotal: 2000,
          rowList : [20,30],
          rownumbers: true,
          //rownumWidth: 60,
          pager:"#pager1", 
          sortname:'id', 
          viewrecords: true,
          gridview: true,
          autowidth: true,
          sortorder:"asc",
          shrinkToFit: true,
          loadonce:true,
          autoencode: true,
      caption:"Revised New List",
      //Subgrid1...
        subGrid: false,

});

$("#list1").jqGrid("setLabel", "rn", "SL");
    $("#list1").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#list1").jqGrid('navGrid','#pager1',
      {edit:false,add:false,del:false,search:false,refreshstate:"current"},
      { },
          { },
          { }, 
      {
          sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
            closeOnEscape: true, 
              multipleSearch: true, 
              closeAfterSearch: true,
              closeAfterDelete:true,
              closeAfterEdit:true
               },

);

}

function get_customer_details_for_sales(rowId,ids,layout_id,sale_id)
{
  var id = rowId;
 
  window.location.href  = '<?php echo site_url('budget-revised-page');?>/'+id+'/'+ids+'/'+layout_id+'/'+sale_id;          
}

function add_design(id)
{
  
  window.location.href  = '<?php echo site_url('revised-design');?>/'+id;          
}

function load_grid(id,site_id,layout_id)
{
 
    $("#list4").setGridParam(
    {
      url:"<?php echo site_url('budget-followup-list/')?>"+id+'/'+site_id+'/'+layout_id,   
        page:1
    }
    ).trigger("reloadGrid");//Reload grid trigger
    $("#list4").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
    return false
}

$("#list4").jqGrid({
    url:"<?php echo site_url('budget-followup-list/0/0/0')?>",   
    mtype : "get",   
    datatype: "json", 
    colNames:['id','Description','Follow Date','Progress','Employee','Department','Layout Name','Site No','Created By','Created At','Created Time'],
    colModel:[
               {name:'id',index:'id', width:100, hidden:true,editable:false,key:true},
            {name:'description',index:'description', width:300, hidden:false,editable:false},
            {name:'follow_date',index:'follow_date', width:100, hidden:false,editable:false,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
            {name:'progress',index:'progress', width:250, hidden:false,editable:false},
            {name:'employee',index:'employee', width:250, hidden:false,editable:false},
            {name:'department',index:'department', width:300, hidden:false,editable:false},
            {name:'layout_name',index:'layout_name', width:100, hidden:false,editable:false},
            {name:'site_no',index:'site_no', width:100, hidden:false,editable:false},
            {name:'name',index:'name', width:100, hidden:false,editable:false},
            {name:'created_at',index:'created_at', width:100, hidden:false,editable:false,formatter: 'date', formatoptions: { newformat: 'd-m-Y' }},
            {name:'created_time',index:'created_time', width:100, hidden:false,editable:false},
             ],

rowNum:20,
    rowTotal: 2000,
    rowList : [20,30],
    rownumbers: true,
    //rownumWidth: 60,
    pager:"#pager4", 
    sortname:'id', 
    viewrecords: true,
    gridview: true,
    // autowidth: true,
    sortorder:"asc",
    shrinkToFit: true,
    loadonce:true,
    autoencode: true,
    caption:"Customer Enquiry List",
  });

$("#list4").jqGrid("setLabel", "rn", "SL");
    $("#list4").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#list4").jqGrid('navGrid','#pager4',
      {edit:false,add:false,del:false,search:false,refreshstate:"current"},
      { },
      { },
      { }, 
      {
      sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
      closeOnEscape: true, 
      multipleSearch: true, 
      closeAfterSearch: true,
      closeAfterDelete:true,
      closeAfterEdit:true
      },
    );

$('.progress_type').change(function()
{
   var type = $(this).val();
  if(type == "Finalized Reject")
  {
   
    $('.date-picker').removeAttr('required');
    $('.followup_date').hide();
  }
  else
  {
     $('.date-picker').prop('required',true);
    $('.followup_date').show();
  }
});

$('.employee_name').change(function()
{
  var employee_name = $(this).val();
  $.ajax({
      type:'post',
      url:'<?php echo site_url('get-department-based-on-employee');?>',
      data:{'employee_name':employee_name},
      success:function(response){
      response=jQuery.parseJSON(response);

if(response.result==1)
      {

$('#department_name').empty();
        $('#department_id').empty();
        $('#department_name').val(response.message.dept_name);
        $('#department_id').val(response.message.id);
        
            
       }
       else
       {
          $('#department_id').empty();
          toastr["error"](response.message);  
       }
      }
    });
});

$(function() 
{
  $('.date-picker1').datepicker({
  changeMonth: true,
  changeYear: true,
  showButtonPanel: true,
  dateFormat: 'd-m-yy',

});
});

$('.add_forms').submit(function(e)
    {
        e.preventDefault();
        formdata = new FormData($(this)[0]);
        $(".add").attr('disabled', 'disabled');
        $(".add").text("Submtting...");
        $.ajax({

type   : 'post',
            url    : '<?php echo site_url("add-budget-followups")?>',
            data   : formdata,
            contentType: false,
            processData: false,
                                      
              success:function(response){
              response=jQuery.parseJSON(response);
              console.log(response);

if(response.result==1)
                {
                  
                  $('.myModal').modal('hide');
                  toastr["success"](response.message);
                  $('.add_forms')[0].reset();
                  $(".add").text("Submit");    
                  $(".add").removeAttr('disabled'); 
                  $("#list3").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
                  $("#list2").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
                }
                else 
                {
                  toastr["error"](response.message);                       
                  $(".add").text("Submit"); 
                  $(".add").removeAttr('disabled');  
                  $("#list3").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');           
                }               
            }           
      });             
    });

function fun_disapprove(rowId)
{

var id=rowId;
    swal({

title: "Are you sure?",
    type: "warning",   showCancelButton: true,
    confirmButtonColor: "#DD6B55",
    confirmButtonText: "Yes, DISAPPROVED   it!",
    cancelButtonText: "No, cancel!",
    closeOnConfirm: false,
    closeOnCancel: false 
    },
    function(isConfirm){

if (isConfirm) 
        { 
            $(".sweet-alert").hide();
            $(".sweet-overlay").hide();
            $.ajax({
            type : 'post',
            url  : "<?php echo site_url('revised-disapprove');?>",
            data : {'sales_id':id},
           success:function(response) {
           response=jQuery.parseJSON(response);
            console.log(response);
            if(response.result==1){

toastr["success"](response.message);
                $("#list3").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');
            }

}
      });

} 
        
  });
  
//   var id = rowId;
  //window.location.href  = '<?php echo site_url('unapprove');?>/'+id; 
       
}

</script>

background-color: transparent;

border: 1px solid transparent;

line-height: 1.6;

text-align: justify;

}

.form-control:focus, input[type="Submit"]:focus, input[type="button"]:focus {

border-color: #FF0000;

box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075), 0 0 8px rgba(255, 0, 0, 0.6);

}
.modal-content{
  width: 150%;
  background: aliceblue;
</style>
<?php $this->load->view('includes/footer.php')?>