HEX
Server: Apache/2.4.41 (Amazon) OpenSSL/1.0.2k-fips PHP/5.6.40
System: Linux ip-172-31-40-18 4.14.146-93.123.amzn1.x86_64 #1 SMP Tue Sep 24 00:45:23 UTC 2019 x86_64
User: apache (48)
PHP: 5.6.40
Disabled: NONE
Upload Files
File: /var/www/html/pmw24/app/application/views/admin/userjob/list.php
<style>
.button {
    display: block;
    width: 115px;
    height: 25px;
    background: #4E9CAF;
    padding: 10px;
    text-align: center;
    border-radius: 5px;
    color: white;
    font-weight: bold;
}
.cstm_view{font-size:15px;}
</style>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.4.1/js/bootstrap-datepicker.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.4.1/css/bootstrap-datepicker3.css"/><!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
          <h3>
           Dashboard Panel
            
          </h3>
          <!--<ol class="breadcrumb">
            <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
            <li class="active">Dashboard</li>
          </ol>-->
    </section>

    <!-- Main content -->
    <section class="content">
      <div class="row">
        <div class="col-xs-12">
          <div class="box box-primary">
            <div class="box-header with-border">
			<div class="admin_tab">
				 <ul>					
					<li><a href="javascript:void(0)" id="duser">Delete</a></li>					
				</ul>
				<!-- <a href="<?php echo base_url('admin/category/content');?>" class="btn btn-sm btn-primary" style="float:right">Add Category</a>	-->					
							<?php if($this->session->flashdata('error_msg')){?>
								<span style="color:red; font-weight:bold"><?php echo $this->session->flashdata('error_msg');?></span>
							<?php }?>
							<?php if($this->session->flashdata('success_msg')){?>
								<span style="color:green; font-weight:bold"><?php  echo $this->session->flashdata('success_msg'); ?></span>
							<?php }?>
				</div>	
            </div>
            <!-- /.box-header -->
            <div class="box-body">
			<div class="row" >
			 
			
			    <div class='col-sm-3'></div> 
				<div class='col-sm-2'>
					<div class="form-group">
						<div class='input-group date'>
							<input type='text' class="form-control" placeholder="Start Date" id="start_date"/>
							<span class="input-group-addon">
								<span class="glyphicon glyphicon-calendar"></span>
							</span>
						</div>
					</div>
				</div>
				<div class='col-sm-2'>
					<div class="form-group">
						<div class='input-group date'>
							<input type='text' class="form-control" placeholder="End Date" id="end_date"/>
							<span class="input-group-addon">
								<span class="glyphicon glyphicon-calendar"></span>
							</span>
						</div>
					</div>
				</div>
				<div class='col-sm-2'>
					<div class="form-group">
						<button class="form-control btn-primary" id="btn_filter">Filter</button>						
					</div>
				</div>				
				<div class='col-sm-3'></div>
			</div>
			<div class="box-body table-responsive">			
              <table id="example1" class="table table-bordered table-striped">
                <thead>
                <tr>
				  <th class="no-sort"><input type="checkbox" id="checkAll"></th>
				  <th>Job Category</th>	
				  <th>Client Name</th>
				  <th>Job Address</th>
				  <th>Location</th>
				  <th>Job Date</th>	
				  <th>Job Start Time</th>
				  <th>Job End Time</th>
				  <th>Staff Name</th>
				  <th>Job Status</th> 
				  <th class="no-sort">Action</th>
                </tr>
                </thead>
                <tbody>
                </tbody>
                <tfoot>
                </tfoot>
              </table>
          </div>
            </div>
            <!-- /.box-body -->
          </div>
          <!-- /.box -->
        </div>
        <!-- /.col -->
      </div>
      <!-- /.row -->
    </section>
    <!-- /.content -->
  </div>
  <!-- Modal -->
	  <div class="modal" id='myModal'>
          <div class="modal-dialog">
            <div class="modal-content">
              <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                  <span aria-hidden="true">×</span></button>
                <h4 class="modal-title">Message</h4>
              </div>
              <div class="modal-body" id='modalContent' title="">
               <!-- <p>Would you like to continue ?</p>-->
              </div>
              <div class="modal-footer">
                <button type="button" class="btn btn-default pull-left" data-dismiss="modal">Cancel</button>
                <button type="button" class="btn btn-primary" data-dismiss="modal" id="cdel">Ok</button>
              </div>
            </div>
            <!-- /.modal-content -->
          </div>
          <!-- /.modal-dialog -->
        </div>
		
		<div class="modal" id='myModalinactive'>
          <div class="modal-dialog">
            <div class="modal-content">
              <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                  <span aria-hidden="true">×</span></button>
                <h4 class="modal-title">Message</h4>
              </div>
              <div class="modal-body" id='modalContentinactive' title="">
               <!-- <p>Would you like to continue ?</p>-->
              </div>
              <div class="modal-footer">
                <button type="button" class="btn btn-default pull-left" data-dismiss="modal">Cancel</button>
                <button type="button" class="btn btn-primary" data-dismiss="modal" id="inactive">Ok</button>
              </div>
            </div>
            <!-- /.modal-content -->
          </div>
          <!-- /.modal-dialog -->
        </div>
		
	  <!-- Modal -->
    <!-- Modal -->
	<div class="modal" id='myModalmdelete'>
          <div class="modal-dialog">
            <div class="modal-content">
              <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                  <span aria-hidden="true">×</span></button>
                <h4 class="modal-title">Message</h4>
              </div>
              <div class="modal-body" id='modalContentmdelete' title="">
               <!-- <p>Would you like to continue ?</p>-->
              </div>
              <div class="modal-footer">
                <button type="button" class="btn btn-default pull-left" data-dismiss="modal">Cancel</button>
                <button type="button" class="btn btn-primary" data-dismiss="modal" id="mdel">Ok</button>
              </div>
            </div>
            <!-- /.modal-content -->
          </div>
          <!-- /.modal-dialog -->
        </div>
    <div class="modal" id='myModal2'>
          <div class="modal-dialog">
            <div class="modal-content">
              <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                  <span aria-hidden="true">×</span></button>
                <h4 class="modal-title">User Job Details</h4>
              </div>
              <div class="modal-body" id='modalContent2' title="">
               <!-- <p>Would you like to continue ?</p>-->
              </div>
              <div class="modal-footer">
                <button type="button" class="btn btn-primary" data-dismiss="modal" id="cdel2">Ok</button>
              </div>
            </div>
            <!-- /.modal-content -->
          </div>
          <!-- /.modal-dialog -->
        </div>
    <!-- Modal -->
<script src="<?php echo base_url()?>public/admin_assets/plugins/datatables/jquery.dataTables.min.js"></script>
<script src="<?php echo base_url()?>public/admin_assets/plugins/datatables/dataTables.bootstrap.min.js"></script>
<script>
$(document).ready(function() { 
	table = $('#example1').DataTable({ 
        "pageLength": 100,
        "processing": true, //Feature control the processing indicator.
        "serverSide": true, //Feature control DataTables' server-side processing mode.
        "order": [], //Initial no order.
 
        // Load data for the table's content from an Ajax source
        "ajax": {
            "url": "<?php echo site_url('admin/userjob/all_content_list')?>",
            "type": "POST",
			"data": function(args){
						args.start_date = $('#start_date').val(),
						args.end_date = $('#end_date').val()
					}
        },
 
        //Set column definition initialisation properties.
        "columnDefs": [
        { 
            "targets": 'no-sort', //1st and last column
            "orderable": false, //set not orderable
        },
        ],
		"fnRowCallback": function( nRow, aData, iDisplayIndex, iDisplayIndexFull ) {
			switch(aData[2]){
				case 'Nursing':
					$(nRow).css('color', 'red')
					break;
				case 'Hospitality':
					$(nRow).css('color', 'green')
					break;
				case 'Catering':
					$(nRow).css('color', 'blue')
					break;
				case 'Others':
					$(nRow).css('color', 'Violet')
					break;
			}
		}
    });
	
	$('#btn_filter').click(function(){
		table.draw();
	});
	
	$('#start_date').datepicker({
		maxDate: '0',
		format: 'dd/mm/yyyy'
	});
	
	$('#end_date').datepicker({
		maxDate: '0',
		format: 'dd/mm/yyyy'
	});
	
	var dtable = $("#example1").dataTable().api();
	
	$(".dataTables_filter input")
    .unbind() // Unbind previous default bindings
    .bind("input", function(e) { // Bind our desired behavior
        // If the length is 3 or more characters, or the user pressed ENTER, search
        if(this.value.length >= 3 || e.keyCode == 13) {
            // Call the API search function
            dtable.search(this.value).draw();
        }
        // Ensure we clear the search if they backspace far enough
        if(this.value == "") {
            dtable.search("").draw();
        }
        return;
    });
	
	$(document).on( "click",'#duser',function(){
		$('#modalContentmdelete').html('<p>Would you like to continue ?</p>');
		var id=$(this).prop('title');
		$('#modalContentmdelete').attr('title',id);
		$('#myModalmdelete').modal('show');
	});
	
	$("#checkAll").change(function () {
		$("#example1 input[type=checkbox]").prop('checked', $(this).prop("checked"));	
	});
	
	$(document).on('click','#mdel',function(){
		var ids = [];
		
		$('#example1 input[type=checkbox]:checked').each(function () {			   
			ids.push($(this).attr('title'));			
		});
		
		if(ids.length === 0){
			alert('Please Select Check Box to Delete');
		}else{
			$.ajax({
			  type: "POST",
			  url: '<?php echo base_url('admin/userjob/multiple_del')?>',
			  data: 'users_job_ids='+ids,
			  dataType:'json',
			  success: function(response){
				$('#modalContentmdelete').html(response.message);  
				$('#myModalmdelete').modal('show');
				setTimeout(function(){
					$('#myModalmdelete').modal('hide')
				},400);
				window.location.reload('<?php echo base_url('admin/usersetting'); ?>');			
			  }
			});
		}
	});
	
	
	
	$(document).on( "click",'#delete.cstm_view',function() {
		$('#modalContent').html('<p>Would you like to continue ?</p>');
		var id=$(this).prop('title');
		$('#modalContent').attr('title',id);
		$('#myModal').modal('show');
	});
	$(document).on('click','#cdel',function(){
	var id=$('#modalContent').prop('title');
	$.ajax({
	  type: "POST",
	  url: '<?php echo base_url('admin/usersetting/del')?>',
	  data: 'user_id='+id,
	  dataType:'json',
	  success: function(response){
		$('#modalContent').html(response.message);  
		$('#myModal').modal('show');
		setTimeout(function(){
			$('#myModal').modal('hide')
		},400);
		window.location.reload('<?php echo base_url('admin/cms'); ?>');
		
	  },
	  error:function(response){
		$('#modalContent').html(response.message);  
		$('#myModal').modal('show');
		setTimeout(function(){
			$('#myModal').modal('hide')
		},400);
	  }
	});
});
$(document).on( "click",'#view.cstm_view',function() {
    var id=$(this).prop('title');
    var content='<div class="box-body"><table class="table table-bordered">';
    $.ajax({
      type:'POST',
      url :'<?php echo base_url('admin/userjob/all_details');?>',
      data:'users_job_id='+id,
      dataType:'json',
      success:function(result){	
			var name = result.first_name+' '+result.last_name;		  
		   content+='<tr><td>Job Category</td> <td>'+result.category_name+'</td></tr>';
		   content+='<tr><td>Job Sub Category</td> <td>'+result.sub_category.category_name+'</td></tr>';
		   content+='<tr><td>Client Name</td> <td>'+result.client_name+'</td></tr>';
		   content+='<tr><td>Client Phone No</td> <td>'+result.client_phoneno+'</td></tr>';
		   content+='<tr><td>Client Address</td> <td>'+result.job_address+'</td></tr>';
		   content+='<tr><td>Job Date</td> <td>'+result.job_date+'</td></tr>';
		   content+='<tr><td>Job Start Time</td> <td>'+result.job_start_time+'</td></tr>';
		   content+='<tr><td>Job End Time</td> <td>'+result.job_end_time+'</td></tr>';		   
		   content+='<tr><td>Staff Name</td> <td>'+name+'</td></tr>';
		   content+='<tr><td>Staff Email</td> <td>'+result.email+'</td></tr>';
		   content+='<tr><td>Staff Phone No</td> <td>'+result.phoneno+'</td></tr>';
		    content+='<tr><td>Staff Emergency Contact No</td> <td>'+result.emergency_phoneno+'</td></tr>';
		   content+='<tr><td>Staff Experience</td> <td>'+result.experience+'</td></tr>';		   
		   content+='</table></div>';
      $('#modalContent2').html(content);  
      $('#myModal2').modal('show');
      },error:function(){

      }
    });
  });
  
  $(document).on( "click",'#active.cstm_view_status',function() {
		var p = $(this);
		p.html('---');
		p.css("color", "green");
		var id=$(this).prop('title');
		$.ajax({
		  type: "POST",
		  url: '<?php echo base_url('admin/usersetting/inactive')?>',
		  data: 'user_id='+id,
		  dataType:'json',
		  success: function(response){
			p.attr("id", "inactive");
			p.text('Disapproved');
			p.css("color","red");
			//window.location.reload('<?php echo base_url('admin/feedback'); ?>');	
		  }
		});
	});
	
	$(document).on( "click",'#inactive.cstm_view_status',function() {
		var pactive = $(this);
		pactive.html('---');
		pactive.css("color","red");
		var id=$(this).prop('title');
		$.ajax({
		  type: "POST",
		  url: '<?php echo base_url('admin/usersetting/active')?>',
		  data: 'user_id='+id,
		  dataType:'json',
		  success: function(response){
			pactive.attr("id", "active");
			pactive.text('Approved');
			pactive.css("color", "green");
			//pactive.html('<a class="cstm_view_status_active" id="active" style="color:green" href="javascript:void(0)" title="'+id+'">Active</a>');
			//window.location.reload('<?php echo base_url('admin/feedback'); ?>');		
		  }
		});
	});
});
</script>